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 */
/
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