RE: Should we stop analyzing?

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:jonathan_at_jlcomp.demon.co.uk]
>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" <ORACLE-L_at_fatcity.com>
>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: jonathan_at_jlcomp.demon.co.uk
>
>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: ListGuru_at_fatcity.com (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: john.kanagaraj_at_hds.com

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: ListGuru_at_fatcity.com (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).