Query to find database uptime

  • Home
  • /
  • Query to find database uptime
Query to find database uptime

Query to find database uptime

Oracle 15 Apr 2018

Query to find database uptime

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;
Share: