-
BAMIMA Error
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
Suvashish
-
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,
________________
ShanDJ
-
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
Suvashish
-
Identify the large PL/SQL modules and pin them in memory.
-
BAMIMA error? Okay, I'm stumped. What does BAMIMA stand for?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|