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

Posted by Shipu at 02:38
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Shipu
View my complete profile

Blog Archive

  • ▼  2014 (16)
    • ▼  February (16)
      • RMAN STATUS from db
      • gathering schema status of object
      • DBA with linux
      • HTML FORMAT Report Coversion in R12
      • How To Trace a Concurrent Request And Generate TKP...
      • INVALID OBJECTS IN R12
      • linux cmd
      • relation between linux process and oracle process ...
      • kill sessions
      • ADR Utility
      • Recomplie object by script
      • oracle table size in mb
      • Alert and Listener logs
      • ORA-12012: error on auto execute of job “SYS”.”BSL...
      • creating password file
      • orapwd utility for accessing sys as sysdba by usin...
Simple theme. Powered by Blogger.