Gathering statistics on EM tables
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?
Windows Live™: Keep your life in sync.
http://www.freelists.org/webpage/oracle-l Received on Wed May 13 2009 - 02:22:57 CDT