Wednesday 13 May 2015

DB startup time sql query

SELECT TO_CHAR (startup_time, 'dd-mon-yyyy hh24:mi:ss') start_time from V$instance;
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Oracle : Database Startup Time

 Oracle Instance Startup Time SET LINES 2000 SET PAGES 9999 COLUMN INSTANCE_NAME FOR A20 SELECT     instance_name,     to_char(startup_time,...