Wednesday, October 17, 2012

Display Database uptime in Days and Hours









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

No comments:

Post a Comment