← 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