Skip to Main Content

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!

CPU usage high after running ANALYZE TABLE,EXEC DBMS_STATS.GATHER_SCHEMA_STATS

2699872Aug 4 2014 — edited Aug 4 2014

Hi all

Oracle 11g r2

After running ANALYZE TABLE ,EXEC DBMS_STATS.GATHER_SCHEMA_STATS CPU usage high.

The queries are below which I executed. Please help me

ANALYZE TABLE ITINERARY_DETAIL ESTIMATE STATISTICS;

Execution time 1 Mints

ANALYZE TABLE BOOKING ESTIMATE STATISTICS

Execution time 2 Mints

ANALYZE TABLE BOOKING_DETAIL ESTIMATE STATISTICS

Execution time 1 Mints3

EXEC DBMS_STATS.GATHER_SCHEMA_STATS('PJ2_TRAN')

Execution time : 3hours 30 mints

ANALYZE TABLE ITINERARY_DETAIL ESTIMATE STATISTICS;=27 Min.

ANALYZE TABLE BOOKING ESTIMATE STATISTICS;=47 Min

ANALYZE TABLE BOOKING_DETAIL ESTIMATE STATISTICS;=0.6

hdb.png

db02.png

Regards

Rajesh Mehra

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 1 2014
Added on Aug 4 2014
8 comments
2,570 views