Uptime of Oracle database
Here program like '%PMON%' means PMON background process
select ROUND(SYSDATE-logon_time) "Days", ROUND((SYSDATE-logon_time)*24 ) "Hours"
from sys.v_$session
where program like '%PMON%' /* this is PMON */;
Tags:
Oracle