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
Posted by at Join the discussion Email this post
Labels: ,

No comments:

Share your thoughts Join the conversation, ask follow-up questions, or add your experience related to this post.

Post a Comment

Subscribe to: Post Comments (Atom)