Re: ORA-04031

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