RE: Database up longer that host?

You may use following query will give you the uptime in hours and in minutes.

select sysdate, startup_time,
round( (sysdate - startup_time) *24*60 ,0 ) uptime_in_minutes, round( (sysdate - startup_time) *24 ,0) uptime_in_hours from v$instance

SYSDATE STARTUP_TIME UPTIME_IN_MINUTES UPTIME_IN_HOURS

-------------- -------------- ----------------- ---------------
20021202203918 20021202044608               953              16

Hope this is what you wanted.

-----Original Message-----
Sent: Monday, December 02, 2002 8:34 PM
To: Multiple recipients of list ORACLE-L

On Mon, 2 Dec 2002, Stephane Faroult wrote:

> Stephen Andert wrote:
> >
> > I use a script named db_uptime.sql (I think I got it from the list here)
> > to calculate how long the database has been up. The output compares
> > nicely to the unix uptime command.
>
> I hope that the query doesn't come from the list, because it is
> wrong. The error is to apply floor() before multiplying by 24 or 60 -
> you have tremendous rounding errors.
> My own database has not been up long enough to be 100% sure about it but
> I believe the following to be correct :

Hi:

    Neither of the scripts works for me. Try this?

select

    'Host Name : '||host_name|| chr(10)||
    'Instance Name : '||instance_name|| chr(10)||
    'Uptime : '     ||floor(xx)||'days '
                    || floor( 24 * (xx - floor(xx)) ) || 'hours '
                    || round( 60 * (24 * xx - floor(24 * xx))) || 'minutes '
    from (
             select host_name,instance_name ,(sysdate-STARTUP_TIME) xx
             from v$instance
         )

Meg Crocker

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Meg Crocker
  INET: crocker_at_monstertrak.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: <Govind.Arumugam_at_alltel.com
  INET: Govind.Arumugam_at_alltel.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).