Oracle UPTIME AND STARTUP History

Hello guys, the Oracle uptime and startup history is recorded in alert log files. But you also check these details using SQL Queries. “Oracle UPTIME AND STARTUP history”.

Connect with us on Social Network

Table of Contents

Heres is the steps to check oracle database uptime and startup history step by step.

1. Check Last Startup Time

Here is the query which is helping us to check the oracle database last startup time. “Oracle UPTIME AND STARTUP history”.

select instance_name,
to_char(startup_time,'mm/dd/yyyy hh24:mi:ss') as startup_time
from v$instance;

OUTPUT:

2. Check Oracle Database UPTIME History

The following query will return the details about database uptime history in days.

set lines 250 pagesize 300
col instance_name for a20
col host_name for a25

SELECT host_name, instance_name,
TO_CHAR(startup_time, 'DD-MM-YYYY HH24:MI:SS') startup_time,
FLOOR(sysdate-startup_time) days
FROM sys.v_$instance;

OUTPUT:

3. Check Oracle Database Startup History

The following command will help us to show the startup histroy with date and time of oracle database.

set lines 200 pagesize 200

select * from
( select STARTUP_TIME FROM dba_hist_database_instance ORDER BY startup_time DESC)
WHERE rownum < 5;

OUTPUT:

Connect with us on Social Network

How to Check Oracle UPTIME AND STARTUP history?