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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Regards

Rajesh Mehra

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 1 2014

Added on Aug 4 2014

#general-database-discussions

8 comments

2,464 views