Re: ORA-04031

From: Mohammad Rafiq <rafiq9857_at_hotmail.com>
Date: Thu, 26 Apr 2001 12:55:46 -0700
Message-ID: <F001.002F3682.20010426124546@fatcity.com>

Also pin your most frequent used/loaded objects at database startup time to avoid this problem...
You may use following query as a start to monitor such objects.You may change where clause as per your environment. I normally track such objects which have executions > 1000 regardless of size.....

Regards

Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Thu, 26 Apr 2001 09:32:02 -0800

Increase it...

 >>> siqbal_at_vianetworks.co.uk 04/26/01 12:00PM >>> Hi All

After upgrading from 8.1.6.0. to 8.1.6.3 I am getting the following error repeatedly.

ORA-04031: unable to allocate 4096 bytes of shared memory("shared pool","TRIG_OWSSUBS","PL/SQL MPCODE","BAMIMA: Bam Buffer")

Also this error appears in the Oracle Alert log (not sure wether its connected)

Errors in file /u01/app/oracle/admin/ukdb/udump/ukdb_ora_8432.trc: ORA-07445: exception encountered: core dump [kkects()+64] [SIGSEGV] [Address
not mapped to object] [8] [] []

This is my shared pool size at the moment.

shared_pool_size = 52428800

TIA Saj
--

Sajid Iqbal
Database Team Leader

--

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

Author: Sajid Iqbal

   INET: siqbal_at_vianetworks.co.uk

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: Tim Sawmiller

   INET: sawmillert_at_state.mi.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).

---

Get your FREE download of MSN Explorer at http://explorer.msn.com

--

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

Author: Mohammad Rafiq
  INET: rafiq9857_at_hotmail.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 Apr 26 2001 - 14:55:46 CDT