How to Find out Oracle Database Uptime in Hours or Days - Script

advertisements

_____________________________________________________________________________________________________________________

To find out the database uptime in Oracle, you can use the following SQL script. This script calculates the database uptime by subtracting the startup time from the current time Database uptime refers to the duration of time that a database has been running since its startup. 

Monitoring database uptime is important for ensuring the availability and reliability of the database. It helps track how long the database has been operational and can be useful for performance analysis, maintenance planning, and system monitoring. The v$instance view in Oracle provides information about the current instance of the database, including the startup time.

advertisements

 

Output in Hours

SELECT
  TO_CHAR(startup_time, 'YYYY-MM-DD HH24:MI:SS') AS "Database Startup Time",
  TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS') AS "Current Time",
  ROUND((SYSDATE - startup_time) * 24, 2) AS "Uptime (in hours)"
FROM
  v$instance;

Output in Days

 

SELECT
  TO_CHAR(startup_time, 'YYYY-MM-DD HH24:MI:SS') AS "Database Startup Time",
  TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS') AS "Current Time",
  ROUND((SYSDATE - startup_time), 2) AS "Uptime (in days)"
FROM
  v$instance;

The script retrieves the database startup time from the v$instance view and calculates the database uptime by subtracting the startup time from the current time. Here's what the script does: TO_CHAR(startup_time, 'YYYY-MM-DD HH24:MI:SS'): This converts the database startup time to a formatted string in the 'YYYY-MM-DD HH24:MI:SS' format. TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'): This converts the current date and time (SYSDATE) to a formatted string. ROUND((SYSDATE - startup_time) * 24, 2): This calculates the database uptime in hours. It subtracts the startup time from the current time, multiplies by 24 to convert to hours, and rounds the result to two decimal places.

Database Startup Ti Current Time	Uptime (in hours)
------------------- ------------------- -----------------
2023-08-11 05:11:21 2023-08-11 05:55:45 	      .74

Database Startup Ti Current Time	Uptime (in days)
------------------- ------------------- ----------------
2023-08-11 05:11:21 2023-08-11 05:55:55 	     .03

_____________________________________________________________________________________________________________________

Website Stats