Anuj Singh Oracle DBA
Monday, 9 August 2010
Oracle Instance up time
select
trunc(sysdate - startup_time) days,
trunc(mod(24 * (sysdate - startup_time), 24)) hours,
round(mod(60 * 24 * (sysdate - startup_time), 60)) minutes
from
sys.v_$instance
/
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment