Search the Site

Sponsors

bottom corner

Display Oracle instance uptime

Interested in finding out how long your Oracle database server has been up? This SQL statement will provide you with this information.

This page is filed under keyword(s): oracle.

Please note that, this query makes use of a v$ table, thus keep in mind you must be logged in as a DBA.

select instance_name,to_char(startup_time,'mm/dd/yyyy hh24:mi:ss') as startup_time from v$instance;

Your output should look something like that following:

INSTANCE_NAME    STARTUP_TIME
---------------- -------------------
orcl01           08/03/2008 00:23:08

Did you find this page useful? Please consider browsing other articles or subscribing to the RSS feed to keep up with latest.

This page is filed under keyword(s): oracle.
Author: C. Peter Chen
Last updated: 17 Sep 2008

bottom corner