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


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: 64103
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
Previous Topic: LogOn Problem
Next Topic: undo_tablespace - rollback segment OFFLINE
Goto Forum:
  


Current Time: Sat Dec 03 10:18:02 CST 2016

Total time taken to generate the page: 0.10040 seconds