I am surprised no one raised the issue of invalidations in the shared pool caused by Stats gathering, and the parsing/reloading load that is caused _after_ the extra I/O and changed plans due to ANALYZEs....
I have this 250Gb Apps database that is analyzed once a month and we have not suffered due to incorrect or stale statistics. Projects in the new year include revisting the Stats gathering schedules of all our 90+ databases, some of which are analyzed daily :( Have a happy, blessed new year all! John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** >-----Original Message----- >From: Jonathan Lewis [mailto:[EMAIL PROTECTED] >Sent: Tuesday, December 30, 2003 8:44 AM >To: Multiple recipients of list ORACLE-L >Subject: Re: Should we stop analyzing? > > > >That's (partly) what the 9i dynamic sampling >feature is for. And such tables are, of course, >going to be GTTs. > > >Regards > >Jonathan Lewis >http://www.jlcomp.demon.co.uk > > The educated person is not the person > who can answer the questions, but the > person who can question the answers -- T. Schick Jr > > >One-day tutorials: >http://www.jlcomp.demon.co.uk/tutorial.html > > >Three-day seminar: >see http://www.jlcomp.demon.co.uk/seminar.html >____UK___November > > >The Co-operative Oracle Users' FAQ >http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > >----- Original Message ----- >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Tuesday, December 30, 2003 4:09 PM > > >I'll see your 'analyzed every 4 hours' and raise you one. We have some >tables that are analyzed every time they are used! They are >'work' tables >that are sometimes empty, very full, or somewhere in between. Running >something when the statistics say the table is full but >actually is empty >takes a little longer when CBO says use indexes; however, if >CBO thinks the >table is empty and does a FTS when there's actually a million >records, well >let's just say it takes a while. Hints work sometimes; >however, analyzing >these table after they are populated and letting CBO do it's >job usually >works best. > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Jonathan Lewis > 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 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.net -- Author: John Kanagaraj 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 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).
