Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Help

RE: Help

From: <hemantchitale_at_charteredsemi.com>
Date: Thu, 20 Dec 2001 18:16:55 -0800
Message-ID: <F001.003E16ED.20011220174019@fatcity.com>

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." <PSherman_at_elcom.com> 21/12/2001 01:55 AM Sent by: root_at_fatcity.com

FYI Thank you,

Paul Sherman
DBA
voice - 781-501-4143 (office)
fax - 781-278-8341 (office)
email - psherman_at_elcom.com

-----Original Message-----

Sent: Thursday, December 20, 2001 11:22 AM To: 'ORACLE-L_at_fatcity.com'

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 - psherman_at_elcom.com

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

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.

>>> PSherman_at_elcom.com 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 - psherman_at_elcom.com

-----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: hamid.alavi_at_quovadx.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: Kimberly Smith
  INET: ksmith2_at_myfirstlink.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Wong, Bing
  INET: bing.wong_at_IngramMicro.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: Sherman, Paul R.
  INET: PSherman_at_elcom.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: Gene Sais
  INET: Gsais_at_co.palm-beach.fl.us
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!?
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: sknd100_at_yahoo.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: Sherman, Paul R.
  INET: PSherman_at_elcom.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: hemantchitale_at_charteredsemi.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). Received on Thu Dec 20 2001 - 20:16:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US