Query to find database uptime

Sunday, April 15, 2018

Query to find database uptime

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;

No comments

Post a Comment

Error 404

The page you were looking for, could not be found. You may have typed the address incorrectly or you may have used an outdated link.

Go to Homepage