Thursday, May 19, 2011

QUERY TO LAST ANALYZE OF A PARTICULAR TABLE FROM A SCHEMA

QUERY TO LAST ANALYZE OF A PARTICULAR TABLE FROM A SCHEMA
------------------------------------------------------------------------------------------------------------

SQL> select distinct trunc(last_analyzed) from dba_tables where owner ='' ;

No comments: