有一个不是很准确的,可以参考的时间是
对比dba_tables/dba_indexes的last_analyzed , 相邻的两个时间差,也许就是后面那个object的analyzed 的所用时间,前提就是连续分析
比如:
SELECT object_name, Round((LAST_ANALYZED - lag(LAST_ANALYZED) over(ORDER BY LAST_ANALYZED))*24*3600,1),LAST_ANALYZED
FROM (
SELECT LAST_ANALYZED,table_name AS object_name FROM dba_tables
WHERE LAST_ANALYZED IS NOT null
UNION ALL
SELECT LAST_ANALYZED,index_name AS object_name FROM dba_indexes
WHERE LAST_ANALYZED IS NOT null
)
ORDER BYLAST_ANALYZED desc
|