ORA 4031: How to examine?

Hi,

I have a database (Oracle 8.1.7) on a Linux box (SuSE 7.1) with 1 GB RAM. At first there were only 512M, I got an ORA 4031, so we installed 1G and adjusted the settings in init.ora to

shared_pool_size = 57160800

But we still get the same error when we try to insert a record with

INSERT INTO foo VALUES (90826, TO_DATE('5-07-2001 00:00:00', 'DD-MM-YYYY HH24:MI:SS'),938); There is an AFTER INSERT trigger connected with foo which inserts some data into fooval.

The error message is:

MSG :ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","STANDARD","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: in "SCOTT.fooval"

My question:

After adding memory and adjusting shared pool size we still get the same error (4096 bytes). This error does not always come up, we can not say when it will exactly happen. Does anyone have an idea what we can do to examine this error? And what we can do to prevent it (I know we can use dbms_shared_pool to pin large packages but this trigger is fairly small)?

Thanks,

Knut Received on Fri Jul 06 2001 - 02:18:58 CDT