ORACLE DBA
Thursday, 6 February 2014
gathering schema status of object
select count(*) from dba_tables where owner != 'SYS' and
to_char(last_analyzed,'DD/MM/YYYY HH24:MI:SS') > '09/04/2012 16:017:052 '
select sysdate-1/24 from dual
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment