aravindhreturns

 Profile Answers by aravindhreturns 

• Apr 22nd, 2010

 

Use this simple command in SQLPlus or an a query retreival tool of your choice.

select To_char(startup_time, 'Mon-dd-yyyy hh24:mi AM') as STARTUP_TIME from v$instance;

kishore

• Nov 15th, 2011

 

how to get instance startup time


>select to_char(startup_time,'dd-mon-yyyy HH12:MI:SS ')"db startup time"
2 from sys.v$instance;