ORA-4031: unable to allocate bytes of shared memory shared pool FileOpenBlock
Last updated on AUGUST 08, 2012
Applies to:Oracle Server - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
Getting error ORA-4031: unable to allocate 2600 bytes of shared memory ("shared
pool","unknown object","sga heap(1,0)","FileOpenBlock").
High hard parsing due to FileOpenBlock eating up shared pool memory.
Query X$KSMDD for FileOpenBlock object and there will be an increase in size of this object:
select * from X$KSMDD where name='FileOpenBlock';
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms