Re: Gathering statistics on EM tables

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 13 May 2009 09:34:42 +0100
Message-ID: <7765c8970905130134oc55c7c8xdd30f46df894ccaa_at_mail.gmail.com>

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?
>
> Thanks
> -Upendra
>
>
> _________________________________________________________________
> Windows Live�: Keep your life in sync.
> http://windowslive.com/explore?ocid=TXT_TAGLM_BR_life_in_synch_052009

-- 
Sent from Google Mail for mobile | mobile.google.com

Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 13 2009 - 03:34:42 CDT