Re: Gathering statistics on EM tables

From: Niall Litchfield <>
Date: Wed, 13 May 2009 09:34:42 +0100
Message-ID: <>

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 <> wrote:
> We have Oracle Grid control 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.

Sent from Google Mail for mobile |

Niall Litchfield
Oracle DBA
Received on Wed May 13 2009 - 03:34:42 CDT

Original text of this message