Re: ORA-04031: unable to allocate 8192 bytes of shared memory

On 7/1/04 11:07 AM, Frank Langelage wrote:

> oerr ora 4031:
> 04031, 00000, "unable to allocate %s bytes of shared memory
> (\"%s\",\"%s\",\"%s\",\"%s\")"
> // *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
> // INIT.ORA parameters "shared_pool_reserved_size" and
> // "shared_pool_size".
> // If the large pool is out of memory, increase the INIT.ORA
> // parameter "large_pool_size".

Here is my init.ora file:

---
db_block_size=8192
db_cache_size=67108864

open_cursors=300

background_dump_dest=/u01/app/oracle/admin/mydb/bdump
core_dump_dest=/u01/app/oracle/admin/mydb/cdump
timed_statistics=TRUE
user_dump_dest=/u01/app/oracle/admin/mydb/udump

db_domain=mydomain.com
remote_login_passwordfile=EXCLUSIVE

control_files=("/u01/app/oracle/oradata/mydb/control01.ctl", 
"/u01/app/oracle/oradata/mydb/control02.ctl", 
"/u01/app/oracle/oradata/mydb/control03.ctl")

dispatchers="(PROTOCOL=TCP)(SER=MODOSE)", 
"(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)", 
"(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"

compatible=9.0.0
db_name=mydb

instance_name=mydb


java_pool_size=83886080
large_pool_size=1048576
shared_pool_size=100663296

processes=150

fast_start_mttr_target=300

resource_manager_plan=SYSTEM_PLAN

sort_area_size=524288

undo_management=AUTO
undo_tablespace=UNDOTBS
---

What parameters should I change and what would be good values?

Thanks!