GremlinHunter
Programmer
Is there a way to find out total uptime on a database? I have one turning 7 years old tomorrow and I was curious how much of that was with database online.
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Oracle does not increment and store any counter that totals how many days/hours/minutes/seconds a database runs.GremlinHunter said:Is there a way to find out total uptime on a database?
select to_char(startup_time,'yyyy-mm-dd hh24:mi:ss')startup
from v$instance;
STARTUP
-------------------
2007-12-04 00:13:43