Thanks, but I'd rather have a nice shot of Scotch.
:)
Jared
"Stephen Andert" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/04/2002 03:39 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Database up longer that host?
Give the man a cigar. (virtual one of course :)
That is what I was looking for and makes unix uptime and db_uptime.sql
report a compatible time frame.
Thanks Jared.
Stephen
>>> [EMAIL PROTECTED] 12/03/02 04:02PM >>>
Try:
col uptime format a40 head 'UPTIME'
select to_char(sysdate,'hh:miam')
|| ' up ' || trunc( (sysdate - startup_time) ,0) || ' days, '
|| trunc( (sysdate - trunc(sysdate)) *24 ,0) || ':' -- hours
|| trunc( (sysdate - trunc(sysdate,'hh')) *24*60 ,0 ) || ', '
--
minutes
|| s.user_count || ' users' uptime
from v$instance i, (
select count(*) user_count
from v$session
where username is not null
) s
/
"Stephen Andert" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/02/2002 07:58 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject: RE: Database up longer that host?
Govind,
Actually, what I want it the same format as I have, I just want the
numbers to match (or fall within) the numbers reported by the unix
uptime command for example "up 4 days, 21:08 hours". In my case, the
unix uptime is saying the host was last restarted after the database
startup_time reported in v$instance.
Stephen
>>> [EMAIL PROTECTED] 12/02/02 07:43PM >>>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Stephen Andert
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Stephen Andert
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
