Home » RDBMS Server » Server Administration » ORA-04031: unable to allocate 16384 bytes
ORA-04031: unable to allocate 16384 bytes [message #229619] Mon, 09 April 2007 07:13 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 13:05:46 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.