Find Oracle Shutdown & Startup Time



Share this article :

Symptom

You want to check the Oracle shutdown & startup time.

Solution

1. Execute below command for startup time.

SQL> select to_char (startup_time, 'dd-mon-yyyy hh24:mi:ss') 
start_time from V$instance;

START_TIME
--------------------------
13-may-2013 19:17:59

2. Or this command.

SQL> SELECT startup_time "DB Startup Time" FROM v$instance;

DB Startup Time
---------------
13-MAY-13

3. Or below command for both downtime and startup time.

SQL> SELECT SCN_TO_TIMESTAMP(TIMESTAMP_TO_SCN(startup_time)) "DB Shutdown Time" ,
 startup_time "DB Startup Time" FROM v$instance;

DB Shutdown Time                  DB Startup Time
------------------------------    ---------------
13-MAY-13 07.09.30.000000000 PM   13-MAY-13

Related posts

List / Find Users in Oracle
ORA-01683: unable to extend index X partition X by X in tablespace X
Check Response Time & Runtime of Oracle SQL Statement
ORA-12518: TNS:listener could not hand off client connection
© 2018 ITsiti. All Rights Reserved
Powered by KEEM