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

From: Steve <smontgomerie_at_hotmail.com>
Date: 17 Sep 2002 11:53:13 -0700
Message-ID: <156709aa.0209171053.1ed526a@posting.google.com>

select SYSDATE-logon_time "Days", (SYSDATE-logon_time)*24 "Hours" from sys.v_$session
where sid=1

steve

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:<CyEh9.34733$g9.96375_at_newsfeeds.bigpond.com>...
> Hi Stan,
>
> Look at STARTUP_TIME in V$INSTANCE (pretty sure it was there back then)
>
> Cheers
>
> Richard
> "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 - 13:53:13 CDT