Database Scripts

Beta
 Log In    |   Sign Up

Oracle : Show Uptime

Added on Apr-09-2012 by tonyreg
For Oracle

Tags : availabilityuptime

Simple script to display the uptime of the Oracle database in days and hours

Versions

Oracle8i +

DOWNLOAD

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

    

Report Script

blog comments powered by Disqus