← Monitoring
Oracle · Monitoring

How to check Oracle instance uptime

Show Oracle instance name and startup time from V$INSTANCE.

Tested on11g12c18c19c21c23ai26ai

Instance name and the timestamp of the last startup. First thing to check after an outage or a restart — confirms which node came up when.

SELECT instance_name,
       TO_CHAR(startup_time, 'mm/dd/yyyy hh24:mi:ss') AS startup_time
FROM   v$instance;
monitoringv$instanceuptime