📋Steps in this guide1/1

Check stale stats

STALE STATS FOR TABLE

oracle configurationintermediate

by OracleDba

10 views

Check stale stats

STALE STATS FOR TABLE FOR INDEX

Code/Command (click line numbers to comment):

1
2

select owner,table_name,STALE_STATS from dba_tab_statistics where owner='&SCHEMA_NAME' and table_name='&TABLE_NAME';
select owner,INDEX_NAME,TABLE_NAME from DBA_IND_STATISTICS where owner='&SCHEMA_NAME' and index_name='&INDEX_NAME';

Comments (0)

Please to add comments

No comments yet. Be the first to comment!