Re: How can I tell how long an instance has been up?

You can do

1º from OS shell

ps -ef | grep pmon

2º from SQLPlus

select * from v$instance

Regards.

Marco.

"Stan Brown" <stanb_at_panix.com> wrote in message news:am749i$h6o$1_at_reader1.panix.com...
> How can I tell how long a given Oracle instance has been up?
>
> Oracle 7.3.4.5, HP-UX 10.20 if that helps.
>
>
> --
> "They that would give up essential liberty for temporary safety deserve
> neither liberty nor safety."
> -- Benjamin Franklin
Received on Tue Sep 17 2002 - 06:36:55 CDT