ora-04031 while generating server alert smg-3503 [message #349600] |
Mon, 22 September 2008 06:01 |
seema.taunk
Messages: 96 Registered: October 2006
|
Member |
|
|
Dear all,
We are getting this error ORA -04031 even thogh there is lot of free memory in shared pool.
We have flushed shared pool, then also we are getting error 04031 in alert log file. We are unable to run any stmt. We can't shut down it since it is production database.
Kindly help.
|
|
|
|
|
Re: ora-04031 while generating server alert smg-3503 [message #349611 is a reply to message #349600] |
Mon, 22 September 2008 06:24 |
|
Michel Cadot
Messages: 68718 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
ORA-04031: 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".
Regards
Michel
|
|
|
|
Re: ora-04031 while generating server alert smg-3503 [message #349624 is a reply to message #349613] |
Mon, 22 September 2008 07:18 |
|
Michel Cadot
Messages: 68718 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Once again you show that don't know other things than copy others post.
Copying Metalink materials is illegal and not allowed here.
Your post was just a copy and paste of Kelvin Woo's answer in Metalink forum thread 473260.995.
Another useful Metalink note is 146599.1 "Diagnosing and Resolving Error ORA-04031".
Regards
Michel
|
|
|