Shows Database uptime in Days,Hours - ORACLE SCRIPT

*****************************
rem Filename: uptime.sql
rem Purpose : Display database uptime in days and hours
rem : to SYS or SYSTEM
*****************************

select SYSDATE-logon_time "Days", (SYSDATE-logon_time)*24 "Hours"
from sys.v_$session
where sid=1 /* this is PMON */
/

0 Response to "Shows Database uptime in Days,Hours - ORACLE SCRIPT"

Post a Comment

Powered by Blogger