The Patch for 1967363 on 8.1.7.2/8.1.7.2.1 has been out for some time now.
(the patch
will not be released for 8.1.7.1 or 8.1.7.0)
I do have an 8.1.7.1 instance running and am waiting for scheduled downtime
to upgrade
to 8.1.7.2.1 + 1967363 on Tru64.
This instance is only a test environment and, yet, I see high wait-time
ratios for "cache buffer chains" latch
in the PerfStat reports.
(On Solaris it is only 8.1.7.2 -- 8.1.7.2.1 was released only on certain
platforms to replace a
defective 8.1.7.2 which would not upgrade 8.1.7.1 to 8.1.7.2).
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
"Sherman, Paul R." <[EMAIL PROTECTED]> 21/12/2001 01:55 AM
Sent by: [EMAIL PROTECTED]
FYI
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax - 781-278-8341 (office)
email - [EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, December 20, 2001 11:22 AM
To: '[EMAIL PROTECTED]'
Scott,
The cache buffer chains issue, I'm pretty sure that I've seen that on some
of our 8.1.6.2 and 8.1.6.3 systems. But I do not recall if the issue was
damaging or not.
So, 8.1.7.2.1 does not have this resolved, and I need to go to 8.1.7.3 ?
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax - 781-278-8341 (office)
email - [EMAIL PROTECTED]
-----Original Message-----
Sent: Wednesday, December 19, 2001 10:25 PM
To: Multiple recipients of list ORACLE-L
I heard that! We got bit on 8.1.7.1 by a 'Cache Buffer Chains' latch
contention bug (bug 1967363) that is not fixed until 8.1.7.3 or 9.0.2. The
releases are supposed to be out in January, IIRC.
--Scott
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 19, 2001 10:26 AM
I am still waiting for Oracle 8.1.7.3 final release for 8.1. Then start
looking at 9.1, when it comes out.
>>> [EMAIL PROTECTED] 12/19/01 10:35AM >>>
Hello,
FYI, my understanding is that 8.1.7.2.0 has problems, and that 8.1.7.2.1 is
the way to go.
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax - 781-278-8341 (office)
email - [EMAIL PROTECTED]
-----Original Message-----
Sent: Tuesday, December 18, 2001 10:40 PM
To: Multiple recipients of list ORACLE-L
If you are running 8.1.7.1, it has memory leak problem. Need to upgrade to
8.1.7.2.0.
-----Original Message-----
To: Multiple recipients of list ORACLE-L
Sent: 12/18/01 5:50 PM
Your SGA has become fragmented. You would not per chance be running
8.1.7 would you? If so I would go and do some searching on Metalink.
I see an upgrade in your future. You could try flushing the SGA but
if its what I think it is it won't help. A restart will for a while.
-----Original Message-----
Sent: Tuesday, December 18, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L
Any idea what this means ?
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
pool","BEGIN
DBMS_APPLICATION_INFO....","PL/SQL MPCODE","BAMIMA: Bam Buffer")
Begin
*
ERROR at line 1:
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
pool","OLWEAREPORTS","PL/SQL MPCODE","BAMIMA: Bam Buffer")
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 3
PasswordNotification12172001.txt: No such file or directory
PasswordNotification12172001.err: No such file or directory
Hamid Alavi
Office 818 737-0526
Cell 818 402-1987
The information contained in this message and any attachments is
intended
only for the use of the individual or entity to which it is addressed,
and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in
error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
INET: [EMAIL PROTECTED]
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: [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: Kimberly Smith
INET: [EMAIL PROTECTED]
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: [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: Wong, Bing
INET: [EMAIL PROTECTED]
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: [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: Sherman, Paul R.
INET: [EMAIL PROTECTED]
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: [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: Gene Sais
INET: [EMAIL PROTECTED]
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: [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).
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Shafer
INET: [EMAIL PROTECTED]
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: [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: Sherman, Paul R.
INET: [EMAIL PROTECTED]
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: [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 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: [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).
