Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is it recommened to flush shared pool after taking statistics??

510293Oct 31 2007 — edited Oct 31 2007

Hi, all.

The database is 2 node RAC 10.2.0.2.0 on 32-bit windows 2003 EE SP1.

I stoped the default statistics-gathering-job of GATHER_STATS_JOB
because it takes statistics of all objects in database and it runs everyday.
In addition, it seems to cause "library cache related" wait events in a RAC
environment.

I have a plan to take statistics of ONLY an application schema, not all objects
of a database, by using GATHER_SCHEMA_STATS procedure.

Is it recommended to flush shared pool after taking statistics of an application
schema??

Thanks and Regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 28 2007

Added on Oct 31 2007

#general-database-discussions

4 comments

1,164 views