Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-04031: unable to allocate 312 bytes of shared memory

JaffySep 30 2008 — edited Oct 7 2008

Hi,

Whenever User tries to login to a database he encounters a below problem. Now this is SGA fragmentation problem. Restart of database would avoid this error, is there any other solution so that i can avoid this error without restarting the database.

ORA-04031: unable to allocate 312 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","kgl lock hash table state").

thanks ad regards

Jafar Ali

This post has been answered by Aman.... on Sep 30 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 4 2008

Added on Sep 30 2008

#general-database-discussions, #memory

10 comments

1,515 views