FAQ
Patch:: Bug_1265297

Product:Oracle Server - Enterprise Edition V7

La=

st
updated:06-SEP-00
Platform:Sun SPARC Solaris

Pa=

tch
version:8.0.6
Info:Bug 1265297 - 8.0.6 fix for base bug 1084273: Hang during
startup/shutdown when system uptime greater than 248 days.

=

Size:30720

dgoulet_at_vicr.com wrote:
Not by my experience!!
=
____________________Reply Separator____________________
Author: Sanjeev Singh
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).
Get free email and a permanent address at http://www.amexmail.com/?A=3D1

From: Diana Duncan
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
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
What is the best way to measure transaction rates? I thought looking
at
the number of commits in report.txt would work but it seems too high.
=20
Thanks, Dave Turner
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20
Author: David Turner
INET: turner_at_tellme.com
=20
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).
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20
Author: Hatzistavrou Giannis
INET: j.hatzistavrou_at_telesoft.gr

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
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

Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

From: "Khedr, Waleed"
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
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
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

Search Discussions

  • Yigal Ran at Sep 27, 2000 at 8:49 pm
    Patch:: Bug_1265297

    Product:Oracle Server - Enterprise Edition V7

    La=

    st
    updated:06-SEP-00
    Platform:Sun SPARC Solaris

    Pa=

    tch
    version:8.0.6
    Info:Bug 1265297 - 8.0.6 fix for base bug 1084273: Hang during
    startup/shutdown when system uptime greater than 248 days.

    =

    Size:30720

    dgoulet_at_vicr.com wrote:
    Not by my experience!!
    =
    ____________________Reply Separator____________________
    Author: Sanjeev Singh
    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).
    Get free email and a permanent address at http://www.amexmail.com/?A=3D1

    From: Yigal Ran
    Date: 27 Sep 00 16:49:30 EDT
    Subject: Re: [Re:DBA Alert]

    Patch:: Bug_1265297

    Product:Oracle Server - Enterprise Edition V7

    La=

    st
    updated:06-SEP-00
    Platform:Sun SPARC Solaris

    Pa=

    tch
    version:8.0.6
    Info:Bug 1265297 - 8.0.6 fix for base bug 1084273: Hang during
    startup/shutdown when system uptime greater than 248 days.

    =

    Size:30720

    dgoulet_at_vicr.com wrote:
    Not by my experience!!
    =
    ____________________Reply Separator____________________
    Author: Sanjeev Singh
    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
  • Chuck Hamilton at Sep 28, 2000 at 12:32 pm
    --0-124208885-970144326=:54847
    Content-Type: text/plain; charset=us-ascii

    Is this a platform specific bug for Solaris only? What about other unix flavors such as IRIX?

    Yigal Ran wrote:

    Patch:: Bug_1265297

    Product:Oracle Server - Enterprise Edition V7
    Last
    updated:06-SEP-00
    Platform:Sun SPARC Solaris
    Patch
    version:8.0.6
    Info:Bug 1265297 - 8.0.6 fix for base bug 1084273: Hang during
    startup/shutdown when system uptime greater than 248 days.

    Size:30720

    dgoulet_at_vicr.com wrote:
    Not by my experience!!

    ____________________Reply Separator____________________
    Author: Sanjeev Singh
    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
    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).
    Get free email and a permanent address at http://www.amexmail.com/?A=1

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Yigal Ran
    INET: ydran_at_usa.net

    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).

    ---------------------------------
    Do You Yahoo!?
    Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
    --0-124208885-970144326=:54847
    Content-Type: text/html; charset=us-ascii

    Is this a platform specific bug for Solaris only? What about other unix flavors such as IRIX?
      Yigal Ran <ydran_at_usa.net> wrote:
    Patch:: Bug_1265297Product:Oracle Server - Enterprise Edition V7Lastupdated:06-SEP-00Platform:Sun SPARC SolarisPatchversion:8.0.6Info:Bug 1265297 - 8.0.6 fix for base bug 1084273: Hang duringstartup/shutdown when system uptime greater than 248 days.Size:30720dgoulet_at_vicr.com wrote:> Not by my experience!!> > ____________________Reply Separator____________________> Author: Sanjeev Singh > 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 con!
    secutive 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@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@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 fo!
    r other information (like subscribing).> -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com> -- > Author: > INET: dgoulet@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@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).____________________________________________________________________Get free email and a permanent address at http://www.amexmail.com/?A=1--Please see the official ORACLE-L FAQ: http://www!
    .orafaq.com--Author: Yigal RanINET: ydran_at_usa.netFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!?
    Yahoo!" rel="nofollow">http://photos.yahoo.com/">Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 27, '00 at 8:49p
activeSep 28, '00 at 12:32p
posts3
users2
websiteoracle.com

2 users in discussion

Yigal Ran: 2 posts Chuck Hamilton: 1 post

People

Translate

site design / logo © 2022 Grokbase