Re: Easy way to find total uptime ?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 03 Sep 1999 17:36:16 +0800
Message-ID: <37CF9690.4C21@yahoo.com>

Lisa Hudd wrote:
>
> On Fri, 03 Sep 1999 13:06:30 +0200, Frans Trip <tripf_at_vertis.nl>
> wrote:
>
> >Hi There,
> >
> > I need to supply information about the Oracle database up-time.
> > Where can i find this info in the database ?
> >
> > I need to present info about the availability of Oracle !!!
> >
> > Please mail your info to:
> >
> > tripf_at_vertis.nl
> >
> >Can i do something with V$thread or V$timer ?
> >
> >The management wants to know the total uptime + total downtime !!!
> >
> >Please help me !
>
> You can always look at the timestamps in the database alert log for
> information about when it has been opened/closed. This may
> give you the best picture of the amount of time that the db has
> been down as well. There may also be an easy query from within
> the database dynamic tables - check the Administrator's Reference
> Guide.
>
> - Lisa

Hi Lisa,

  SELECT NAME, ' Database Started at ',TO_DATE(A.VALUE,'J')

  || ':'|| FLOOR(B.VALUE/3600)
  || ':'|| (FLOOR(B.VALUE/60) - (FLOOR(B.VALUE/3600) * 60))
  || ':'|| (B.VALUE - (FLOOR(B.VALUE/60) * 60)) STTIME

  FROM V$INSTANCE A, V$INSTANCE B, V$DATABASE C   WHERE B.KEY LIKE 'STARTUP TIME - S%'
  AND A.KEY LIKE 'STARTUP TIME - J%' ; --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Sep 03 1999 - 04:36:16 CDT