Thursday, 28 April 2011

To Check Last analyzed table date ...........

select count(1),owner,trunc(last_analyzed) from dba_tables where owner not in ('SYS','SYSTEM','OUTLN','PERSTAT') group by owner,trunc(last_analyzed) order by owner,trunc(last_analyzed);

No comments:

Post a Comment