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 18.104.22.168 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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms