BAMIMA Error

[dsuva]

Hi,

I am getting this error. Can anyone help me identify the reason.
--------------------------------------------------------------------
ORA-04031: unable to allocate 4048 bytes of shared memory ("shared
pool","unknown object","sga heap","state objects")

The free memory gets reduced from 800M to 40M

BAMIMA error
-----------------------------------------------------------------

Thanks

[shandj]

Qoute from Oracle TECH Doc

Cause: More shared memory is needed than was allocated in the shared pool.
Action: If the shared pool is out of memory, either use the
DBMS_SHARED_POOL package to pin large packages, reduce your use of
shared memory, or increase the amount of available shared memory by
increasing the value of the initialization parameters
SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE. If the large
pool is out of memory, increase the initialization parameter
LARGE_POOL_SIZE.

Thanks,

[dsuva]

Thanks, but memory leak is taking place i guess. I think i have hit a bug. I am running 8.1.6.3.1.0 . Metalink says to apply patch 4 for version 8.1.7. Can anyone give me any solution for 8.1.6.3.1.0


Thanks

[tamilselvan]

Identify the large PL/SQL modules and pin them in memory.

[stecal]

BAMIMA error? Okay, I'm stumped. What does BAMIMA stand for?