ORA-04031: unable to allocate 4032 bytes of shared memory [message #91320] |
Mon, 15 July 2002 03:13 |
Chaitanya Sravanth
Messages: 10 Registered: April 2002
|
Junior Member |
|
|
When I'm trying to run loadjava on command prompt, it is displaying the following msg.
ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool",
"oracle/aurora/rdbms/CompilerSYS","joxlod: in ehe","ioc_allocate_pal")
loadjava: 1 errors.
Please anybody let me know how to solve this problem.
Send a response ASAP. Thanks in advance.
Regards,
Chaitanya Sravanth
|
|
|
|
|
|
|
Re: ORA-04031: unable to allocate 4032 bytes of shared memory [message #91776 is a reply to message #91320] |
Wed, 12 February 2003 08:35 |
Nupur
Messages: 1 Registered: February 2003
|
Junior Member |
|
|
You need to run the following command:
ALTER SYSTEM FLUSH SHARED_POOL;
If the problem persists, you need to increase the shared pool size. For this you need to edit your initxxx.ora file and increase the parameter shared_pool_size. After you save the file, restart the DB for this to take effect.
Regards.
|
|
|