| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: [Re:DBA Alert]
Patch:: Bug_1265297
Product:Oracle Server - Enterprise Edition V7
La=
st
Pa=
tch
=
Size:30720
dgoulet_at_vicr.com wrote:
> Not by my experience!!
> =
> ____________________Reply Separator____________________
> Author: Sanjeev Singh <ssingh_at_symyx.com>
> Date: 9/27/00 11:42 AM
> =
> Hi Folks,
> =
> Please read this very carefully. I was reading a article in eweek=
> magazine(September) on oracle. Following are exact words.
> =
> " Oracle has been quietly alerting customers that systems running oracl=
e
> 8.1.6 or earlier could find the database control file corrupted if the
> server runs for 248 consecutive days without a reboot". =
> =
> Is this legit??? =
> =
> Sanjeev Singh
> Sr. Database Administrator
> SYMYX Technologies, INC.
> 3100 Central Expressway =
> Santa Clara, CA 95051
> http://www.symyx.com
> =
> =
> -- =
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- =
> Author: Sanjeev Singh
> INET: ssingh_at_symyx.com
> =
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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: =
> INET: dgoulet_at_vicr.com
> =
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
From: Diana Duncan <Diana_at_fileFRENZY.com>
Date: Wed, 27 Sep 2000 16:51:51 -0400
Subject: RE: Transaction rates
I just tried out the query for fun, and on 8.1.6.2 it didn't work, =
because
there is no KEY column in v$instance. The query below worked, though.
select sum(s.value/(86400*(sysdate-i.startup_time))) "tps"
from v$sysstat s,v$instance i
where s.name in ('user commits','transaction rollbacks')
Diana
-----Original Message-----
From: Hatzistavrou Giannis [mailto:j.hatzistavrou_at_telesoft.gr]
Sent: Wednesday, September 27, 2000 6:30 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Transaction rates
Dear David,
I have found the following sql from an old mail posted to the list.
select sum(s.value/(86400*(sysdate-to_date(i.value,'J')))) "tps"
from v$sysstat s,v$instance i
where s.name in ('user commits','transaction rollbacks')
and i.key=3D'STARTUP TIME - JULIAN';
PS: Shows transactions/sec
Regards
Hatzistavrou Yannis
DBA/Telco Analyst
> -----Original Message-----
> From: David Turner [SMTP:turner_at_tellme.com]
> Sent: =D4=E5=F4=DC=F1=F4=E7, 27 =D3=E5=F0=F4=E5=EC=E2=F1=DF=EF=F5 =
2000 6:01 =F0=EC
> To: Multiple recipients of list ORACLE-L
> Subject: Transaction rates
>=20
>=20
>=20> To REMOVE yourself from this mailing list, send an E-Mail message
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------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).
From: Navtej B <navtej_b_at_yahoo.com>
Date: Wed, 27 Sep 2000 13:56:13 -0700 (PDT)
Subject: OPS
Hello Everybody
I need suggestion from senior guys
" Can we have Multiple database in Oracle Parallel Server. I had two new machine E5000 . I had two different application using two different Databases and Company is looking for OPS and now I need to check that is it feasible to run two databases and so multiple instances"
Please send me the reply
Thanks very much in advance
From: "Khedr, Waleed" <Waleed.Khedr_at_FMR.COM>
Date: Wed, 27 Sep 2000 16:56:58 -0400
Subject: RE: DBA Alert
http://metalink.oracle.com/metalink/plsql/ml2_documents.showBUG?p_id=1227119 &p_showHeader=1&p_showHelp=1
-----Original Message-----
From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com]
Sent: Wednesday, September 27, 2000 4:26 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:DBA Alert
Not by my experience!!
____________________Reply Separator____________________ Author: Sanjeev Singh <ssingh_at_symyx.com> Date: 9/27/00 11:42 AM
Hi Folks,
Please read this very carefully. I was reading a article in eweek magazine(September) on oracle. Following are exact words.
" Oracle has been quietly alerting customers that systems running oracle 8.1.6 or earlier could find the database control file corrupted if the server runs for 248 consecutive days without a reboot".
Is this legit???
Sanjeev Singh Received on Wed Sep 27 2000 - 15:49:30 CDT
 |
 |