On the subject on analyzed: We are doing analyze compute statistics and it takes about an hour. Do you know of ways to speed it up?
Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, July 24, 2002 3:54 PM > On Wed, Jul 24, 2002 at 04:48:41AM -0800, Boivin, Patrice J wrote: > > A question: > > > > If analyzing SYS objects is a bad idea, why is it included by default in the > > analyzing commands (dbms_stats, analyze, dbms_utility.analyze_database)? > > > bug, Doc ID: 203003.996, fixed in 9i...I hate it when that happens. > > > > > > > Please correct me if my assumption is wrong, we had strange behaviour here > > when SYS objects were analyzed on a development db. > > > > Regards, > > Patrice Boivin > > Systems Analyst (Oracle Certified DBA) > > > > Systems Admin & Operations | Admin. et Exploit. des syst�mes > > Technology Services | Services technologiques > > Informatics Branch | Direction de l'informatique > > Maritimes Region, DFO | R�gion des Maritimes, MPO > > > > E-Mail: [EMAIL PROTECTED] > > > > > > -----Original Message----- > > Sent: Wednesday, July 24, 2002 9:09 AM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: ANALYZE question > > > > DBMS_STATS can be used to analyze tables. > > > > Dave > > > > -----Original Message----- > > Sent: Wednesday, July 24, 2002 4:03 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Apart from explicity running an ANALYZE command against a table, what, if > > any, other events/actions can cause an analyze to be run on the table? > > > > ------------------------- > > Se�n O' Neill > > Organon (Ireland) Ltd. > > [subscribed: digest mode] > > -------------------------------------------------------------------- > > This message, including attached files, may contain confidential > > information and is intended only for the use by the individual > > and/or the entity to which it is addressed. Any unauthorized use, > > dissemination of, or copying of the information contained herein is > > not allowed and may lead to irreparable harm and damage for which > > you may be held liable. If you receive this message in error or if > > it is intended for someone else please notify the sender by > > returning this e-mail immediately and delete the message. > > -------------------------------------------------------------------- > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: O'Neill, Sean > > 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: Farnsworth, Dave > > 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: Boivin, Patrice J > > 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). > > -- > =============================================================== > Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ray Stell > 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: Yechiel Adar 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).
