Search This Blog

Total Pageviews

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:

Oracle DBA

anuj blog Archive