Unless Oracle has changed their tune .... and we know that never happens
..... then you should never analyze SYS or SYSTEM. I was always told that
the Catalog was optimized to use rule based queries and if you analyze it
you will populate the statistics.
-----Original Message-----
Sent: Thursday, June 07, 2001 4:59 PM
To: Multiple recipients of list ORACLE-L
On Thu, 7 Jun 2001,Koivu, Lisa scribbled on the wall in glitter crayon:
->Are you kidding? I thought that Oracle adamantly stated that you are
->NOT to analyze the data dictionary...?
->
->Plus the user who is local can do it in a snap. I can't.
->
->I can explain plan on a very small query, yes.
->
->List, am I off track with thinking NOT to analyze the data dictionary??
well, FWIW it don't give me the warm fuzzies. still i can't see where it
would hurt anything. but then i'll bet i'm missing something.;-)
--
Bill "Shrek" Thater Certifiable ORACLE DBA
Telergy, Inc. [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The program is absolutely right; therefore the computer must be wrong.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thater, William
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).
