Database Is Consuming All The Real Memory When Users Access The Application (Doc ID 799984.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 to 11.2.0.1.0 [Release 9.0.1 to 11.2]
IBM AIX on POWER Systems (64-bit)
z*OBSOLETE: IBM AIX 4.3 Based Systems (64-bit)
IBM AIX on POWER Systems (32-bit)
z*OBSOLETE: IBM AIX5L Based Systems (32-bit)
IBM AIX Based Systems (64-bit)IBM AIX5L Based Systems (32-bit)IBM AIX Based Systems (32-bit)IBM AIX 4.3 Based Systems (64-bit)
***Checked for relevance on 17-Jul-2016***


Symptoms

Database  performance deteriorates after the databases and applications are started. Application users connect to the database using dedicated connections (though can also happen in shared server configuration).  The memory consumption/ paging and swapping continues to grow until the system is unusable. Once the applications and databases are stopped the swap space is released and everything returns to normal.

Memory monitoring tools (e.g. Topas, NMON and vmstat) show Oracle processes have the highest memory usage.

No ORA-4030 errors are reported only the following are seen in the alert log:

ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3.

Changes

The customer may have recently switched storage or otherwise made changes to their file systems.

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