Database uptime

This query calculates and displays database uptime.

By using the query below, you can calculate and display the database uptime:

select 
'Host Name : '||host_name||chr(10)|| 
'Instance Name : '||instance_name||chr(10)|| 
'Uptime : '||floor(xx)||'days '||floor((xx-floor(xx))*24)||'hours '||round(((xx-floor(xx 
)*24)-floor((xx-floor(xx)*24)))*60)||'minutes' "Database Uptime" 
from (select host_name,instance_name ,(sysdate-STARTUP_TIME) xx from v$instance) 

For More Information


This was first published in June 2001

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close