Re: How to tell how long an instance has been running

Peter Shankey wrote:

> Is there a v$ which tells how long a instances has been running in both 7
> and 8?
>
> Thanks
> Pete

v$instance.

You can also run listener status to find out how long the listener has been up:

lsnrctl status in ORACLE_HOME/bin

Daniel A. Morgan Received on Wed Jun 20 2001 - 01:19:20 CDT