select startup_time from v$instance;
SELECT TO_CHAR (startup_time, 'DD-MON-YYYY HH24:MI:SS') started_at,
TRUNC (SYSDATE - (startup_time))
|| ' day(s), '
|| TRUNC (
24
* ((SYSDATE - startup_time) - TRUNC (SYSDATE - startup_time)
)
)
|| ' hour(s), '
|| MOD (TRUNC (
1440
* (
(SYSDATE - startup_time)
- TRUNC (SYSDATE - startup_time)
)
),
60
)
|| ' minute(s), '
|| MOD (TRUNC (
86400
* (
(SYSDATE - startup_time)
- TRUNC (SYSDATE - startup_time)
)
),
60
)
|| ' seconds' uptime
FROM v$instance;