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!

Oracle 10G - Shared memory problem

440316Nov 14 2006 — edited Nov 23 2006

Dear All

I have a RH 4.2 box running 10G. As of this morning it has started giving the following error message when executing certain queries:

ORA-04031: unable to allocate bytes of shared memory ("","","","")

An example of a specific query is:

select p.description as name from mlm_proj_parents mpp, projects p where p.id=mpp.parentid and mpp.typeid = 2 and mpp.projectid = 3588

Other queries seem to run fine. I have looked the relevant error number up and can see that there is a problem with shared memory but what is confusing me is the fact that there are no parameters in the error message.

Can anyone suggest what is wrong?

Thanks

Paul

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 21 2006

Added on Nov 14 2006

#general-database-discussions

9 comments

753 views