My Oracle Support Banner

ORA-04031 During QUERY Compilation After Upgrade From TO (Doc ID 2011532.1)

Last updated on FEBRUARY 28, 2017

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


ORA-04031 after upgrade from Oracle release TO

ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select u1.user#, u2.user#, u...","SQLA","tmp")
ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 3952 bytes of shared memory ("shared pool","explain plan set statement_i...","qksqb.c.kgght","qksqb.c.kgght")

ORA-4031: unable to allocate 48 bytes of shared memory ("shared pool","unknown object","parameters","kglpda")
ORA-4031: unable to allocate 136 bytes of shared memory ("shared pool","select streams_pool_size_for...","SQLA^4648ffe","kkeStatdef:

Explain Plan for a SELECT statement accessing materialized views in the database fails with error ORA-04031.



 Upgrade from Oracle release TO


To view full details, 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 a vibrant support community of peers and Oracle experts.