8 Ocak 2011 Cumartesi

When is my table last analyzed?

Following query shows the latest analysis time of tables in Oracle:

SELECT distinct stattype_locked, table_name, last_analyzed
FROM dba_tab_statistics 
WHERE owner = 'HR' order by last_analyzed desc;

Hiç yorum yok: