ORA-04031 During QUERY Compilation After Upgrade From 11.2.0.2 TO 11.2.0.4.4

(Doc ID 2011532.1)

Last updated on FEBRUARY 28, 2017

Applies to:

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

Symptoms

ORA-04031 after upgrade from Oracle release 11.2.0.2.0 TO 11.2.0.4.4:


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:
kkeStatAdd")

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

 

Changes

 Upgrade from Oracle release 11.2.0.2.0 TO 11.2.0.4.4

Cause

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