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!

How to select auto stats collection history

ronald_2017Dec 16 2020 — edited Dec 16 2020

Hi All,

Oracle 11g

I want to see the results of auto stats collection that which tables have been calculated etc. Is there a way to see the history? DBA_AUTOTASK_CLIENT_HISTORY table only shows the duration.

I also use DBMS_STATS, so which one do you recommend? Do I need to use auto stats collection if I use DBMS_STATS GATHER_SCHEMA_STATS?

>>SELECT status FROM dba_autotask_client where client_name = 'auto optimizer stats collection';
>>ENABLED

Thanks in advance

This post has been answered by user9540031 on Dec 16 2020

Jump to Answer

Added on Dec 16 2020

#general-database-discussions

4 comments

3,021 views