UPTIME da INSTÂNCIA

[CVPRADOParticipante]

select STARTUP_TIME,
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’
from sys.v_$instance;