SQL Script Database Uptime

Updated: 06-Jun-2000
Version: 1.0

Description

Simple Script to display the database uptime i.e. How long the database has been running

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 


col stime form a20 Heading "Database Started At"

select to_char(to_date(i1.value||' '||i2.value,'J SSSSS')
         ,'DD-MON-YYYY HH24:MI:SS') stime
from v$instance i1, v$instance i2
where i1.key='STARTUP TIME - JULIAN'
and i2.key='STARTUP TIME - SECONDS';

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links