Gathering statistics on EM tables
- From: Upendra N <nupendra@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 13 May 2009 03:22:57 -0400
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
Other related posts:
