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!

Table Stats taking long time

ad21417c-1502-4e65-8f48-c548bba87e4fJul 4 2018 — edited Jul 5 2018

Hi Team,

Below table stats query is taking 3 hours . Any insights to improve the performance ?

This table has indexes and partitioned. It has around 80 million records.

begin dbms_stats.gather_table_stats(ownname => 'RTDMCDM', tabname => 'CI_SUBS_RESPONSE_HISTORY_ARC',estimate_percent =>

DBMS_STATS.AUTO_SAMPLE_SIZE,method_opt => 'FOR ALL COLUMNS SIZE AUTO'

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 2 2018

Added on Jul 4 2018

#general-database-discussions

3 comments

779 views