Statistics information

select * from dba_tab_statistics where STALE_STATS=’YES’;

SELECT instance_id,JOB_NAME,ACTUAL_START_DATE,RUN_DURATION,STATUS
FROM DBA_SCHEDULER_JOB_RUN_DETAILS
WHERE JOB_NAME like ‘%OPT%’
order by ACTUAL_START_DATE desc;

Leave a Reply

Your email address will not be published. Required fields are marked *