Re: Gathering statistics on EM tables
Date: Wed, 13 May 2009 09:34:42 +0100
Well as the repository is a 10g database, you'll be gathering stats every night by default anyway. Do the execution plans show bad cardinality estimates?
On 5/13/09, Upendra N <nupendra_at_hotmail.com> wrote:
> We have Oracle Grid control 10.2.0.2 on solaris 10. Some of the custom
> written reports are eating up quite a bit of CPU cycles (tables are not
> large). The issue seems to be incorrect query plan. Do we need to anything
> special on gathering schema/object statistics?
> I am thinking of gathering statistics once a week for the entire schema.
> Any suggestions?
> Windows Live™: Keep your life in sync.
-- Sent from Google Mail for mobile | mobile.google.com Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Wed May 13 2009 - 03:34:42 CDT