Home » RDBMS Server » Server Administration » ora-04031 while generating server alert smg-3503 (oracle 10.2.0. 3 on hp-ux)
ora-04031 while generating server alert smg-3503 [message #349600] Mon, 22 September 2008 06:01 Go to next message
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 #349601 is a reply to message #349600] Mon, 22 September 2008 06:08 Go to previous messageGo to next message
dilip56
Messages: 6
Registered: September 2008
Junior Member
can you copy paste the exact error you are gertting??
Re: ora-04031 while generating server alert smg-3503 [message #349604 is a reply to message #349601] Mon, 22 September 2008 06:11 Go to previous messageGo to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
ora-04031 encountered while generating server alert SMG-3503
Re: ora-04031 while generating server alert smg-3503 [message #349611 is a reply to message #349600] Mon, 22 September 2008 06:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
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 #349613 is a reply to message #349611] Mon, 22 September 2008 06:28 Go to previous messageGo to next message
dilip56
Messages: 6
Registered: September 2008
Junior Member
The ORA-04031 error is usually due to fragmentation in the library cache or shared pool reserved space.

[Edit MC: Remove Metalink materials]

[Updated on: Mon, 22 September 2008 07:14] by Moderator

Report message to a moderator

Re: ora-04031 while generating server alert smg-3503 [message #349624 is a reply to message #349613] Mon, 22 September 2008 07:18 Go to previous message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Keep log statement
Next Topic: Moving Cluster to another Tablespace
Goto Forum:
  


Current Time: Mon Jul 08 01:45:47 CDT 2024