My Oracle Support Banner

ORA-04031 or ORA-04036 in Alert Log File with Large Amounts of Free Memory in non-CDBs or when PDB Memory Size is Being Reduced (Doc ID 2628582.1)

Last updated on JULY 01, 2020

Applies to:

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

Symptoms

When using non-CDBs, Oracle Databases before Oracle Database 12c

For Oracle Versions BELOW 19.1

The errors ORA-04031 or ORA-04036 can occur in alert log file due to different causes or known bugs.

For example: ORA-4031 or ORA-4036 error may be raised with large amounts of free memory.

To check free memory in shared pool and actual size in bytes of shared pool, __shared_pool_size, you can run following queries:

select name, bytes from v$sgastat where pool='shared pool' and bytes > 10000000 and name like '%free memory%';

SELECT x.ksppinm NAME, y.ksppstvl VALUE, ksppdesc DESCRIPTION FROM x$ksppi x, x$ksppcv y
WHERE x.inst_id = userenv('Instance')AND y.inst_id = userenv('Instance') AND x.indx = y.indx AND SUBSTR(x.ksppinm,1,1) = '_' and x.ksppinm like '__shared_pool_size' -- substitue parameter name
ORDER BY 1;

 

When using Oracle 12c Multitenant

For Oracle Versions BELOW 19.1

In ATP mode, ORA-4031 and ORA-4036 may result when PDB sga_target or PDB pga_aggregate_limit respectively are reduced below the current values. In ATP mode, ORA-4031 and ORA-4036 may result when PDB sga_target or PDB pga_aggregate_limit respectively are reduced below the current values:
ORA-4031: When the PDB's sga usage is 125% of it's sga_target
ORA-4036: When PDB's pga usage is over the PDB pga_aggregate_limit all the processes having PGA above the limit will get ORA-4036

For Oracle Versions BELOW 20.1 

ORA-04031 On PDB Downscale:
PDB ORA-4031 and ORA-4036 happens when PDB is downscaled.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.