Tuesday 23 September 2014

DB : Database start time

select TO_CHAR(startup_time, 'Dy DD-Mon-YYYY HH24:MI:SS') as "START_TIME" FROM sys.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,...