Hi Niall, Thanks for your suggestion. I did check, I don't see stats gathered. 1 select trunc(last_analyzed) date_analyzed, count(*) from dba_tables where owner='SYSMAN' 2* group by trunc(last_analyzed) SQL> / DATE_ANALYZED COUNT(*) ------------------- ---------- 15 08/05/2009 00:00:00 1 07/05/2009 00:00:00 2 09/05/2009 00:00:00 1 23/03/2007 00:00:00 762 I will also get the information on cardinality soon. -Upendra > Date: Wed, 13 May 2009 09:34:42 +0100 > Subject: Re: Gathering statistics on EM tables > From: niall.litchfield@xxxxxxxxx > To: nupendra@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx > > 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 _________________________________________________________________ Hotmail® has ever-growing storage! Don’t worry about storage limits. http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutorial_Storage1_052009