DBA Hub

📋Steps in this guide1/1

Table statistics history

For getting history of TABLE statistics

oracle configurationintermediate
by OracleDba
13 views
1

Table statistics history

For getting history of TABLE statistics

Code/Command (click line numbers to comment):

1
2
3
4
setlines 200
col owner for a12
col table_name for a21
select owner,TABLE_NAME,STATS_UPDATE_TIME from dba_tab_stats_history where table_name='&TABLE_NAME';

Comments (0)

Please to add comments

No comments yet. Be the first to comment!