RE: Should we stop analyzing?

2003-12-30 Thread Josh Collier
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Table recovery from RMAN backup

2003-12-12 Thread Josh Collier
from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: RMAN restore on another server

2003-12-08 Thread Josh Collier
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle Data Guard

2003-12-08 Thread Josh Collier
to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

bitmap index not used

2003-10-29 Thread Josh Collier
://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: bitmap index not used

2003-10-29 Thread Josh Collier
/2003 03:09:39 PM, Josh Collier wrote: Hi, I have a puzzle. A bitmap index on a varchar2(25) column. table has 7131413 rows, of which 7125290 are null for the column in question, the rest of the rows are unique values. There is a histogram on this column, it has 2 buckets. A select

RE: Oracle analog to xp_fixeddrives

2003-10-06 Thread Josh Collier
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: RMAN Problem

2003-09-23 Thread Josh Collier
: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858

maturing monitoring scheme

2003-09-23 Thread Josh Collier
: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send

dbms_application_info rewrite

2003-08-25 Thread Josh Collier
the functionality of sys.dbms_application_info and to pass it the correct parameters. Has anyone else done something like this? I am working on 9i Solaris. Thanks, Josh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network

time/date granularity

2003-08-22 Thread Josh Collier
Hi, Is there a way for me to get the time of a particular sysdate past the granularity of one second? Thanks! Josh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: time/date granularity

2003-08-22 Thread Josh Collier
-- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing

RE: time/date granularity

2003-08-22 Thread Josh Collier
dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Josh Collier [mailto:[EMAIL PROTECTED]] Sent: Friday, August 22, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: time/date

RE: Multiple parses with bind variables

2003-08-20 Thread Josh Collier
of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

2003-08-20 Thread Josh Collier
Title: RE: URGENT!!! My 9i databases are not shutting down cleanly/consistently like they used to or starting up What exactly "goes wrong"? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 9:25 AMTo: Multiple recipients of list

RE: 9i-OCP Question

2003-07-30 Thread Josh Collier
(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Veritas like RMAN?

2003-07-23 Thread Josh Collier
If there is no evidence in the alert log, and no backups/file copies/incarnations are registered in rman, my bet is that the database isn't backed up.-Original Message-From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 23, 2003 9:50 AMTo: Multiple recipients of

RE: parallel processes

2003-07-23 Thread Josh Collier
oramagic. parallel_clause Use the PARALLEL clause to change the default degree of parallelism for queries and DML on the index. Restriction: You cannot specify this clause for an index on a temporary table. Note: The syntax of the parallel_clause

Job to run first Wednesday

2003-07-22 Thread Josh Collier
Greetings, How can I set the interval in my dbms job to have it run on the first Wednesday of every month? Is this even possible? I have been trying to noodle it thru for a week to no avail. tia, Josh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier

Recall: Job to run first Wednesday

2003-07-22 Thread Josh Collier
Josh Collier would like to recall the message, Job to run first Wednesday. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Job to run first Wednesday

2003-07-22 Thread Josh Collier
trying to noodle it thru for a week to no avail. tia, Josh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: Job to run first Wednesday

2003-07-22 Thread Josh Collier
, How can I set the interval in my dbms job to have it run on the first Wednesday of every month? Is this even possible? I have been trying to noodle it thru for a week to no avail. tia, Josh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier

RE: alert_sid.log file: Performance statistics empty: data overfl

2003-07-17 Thread Josh Collier
-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE