ORACLE SCRIPTS
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment