OraFAQ Forum: Server Administration » ORA-04031: unable to allocate 16384 bytes

Home » RDBMS Server » Server Administration » ORA-04031: unable to allocate 16384 bytes

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-04031: unable to allocate 16384 bytes [message #229619]

Mon, 09 April 2007 07:13

grk28
Messages: 38
Registered: June 2006

Member

Hi frnds,

I am newbie to dba....

I am getting the following error when i am trying to execute queries in my database.

"ORA-04031: unable to allocate 16384 bytes of shared memory ("shared pool","unknown object","kgghtInit","kgghtInit")"

there seems to be some problem with the size of shared pool.please correct me if i am wrong

Can any one of you please tell me the root cause of the problem along with the solution?

Immediate help would be appreciated.

Thanks

Report message to a moderator

Re: ORA-04031: unable to allocate 16384 bytes [message #229635 is a reply to message #229619]

Mon, 09 April 2007 07:59

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
If you want to know about ORA-04031 error
check metalink note : Doc ID: Note:396940.1

Regards
Taj

[Updated on: Mon, 09 April 2007 08:28]

Report message to a moderator

Re: ORA-04031: unable to allocate 16384 bytes [message #229648 is a reply to message #229619]

Mon, 09 April 2007 08:27

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And maybe you don't have a problem with shared pool size but with your application.
Ask your DBA to execute StatsPack and analyze the parse ratio and waits on shared pool caches.

Regards
Michel

Report message to a moderator

Previous Topic:	LogOn Problem
Next Topic:	undo_tablespace - rollback segment OFFLINE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 23:37:01 CDT 2024