Re: Gathering statistics on EM tables
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: nupendra@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- 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@xxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
