ORA-04030 OUT OF PROCESS MEMORY - MEMORY INCREASING - ABEND U4093 (LE STORAGE ALLOCATION FAILURE)
(Doc ID 1907959.1)
Last updated on AUGUST 02, 2024
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and laterOracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
IBM z/OS on System z
Symptoms
Memory is increasing (storage creep) based on the OSDI Database service command DISPLAY MEMORY output in "MIR0513I Server memory display" at various 15 minute intervals.
The DISPLAY MEMORY command shows that 'Region Memory' minus 'Shared Memory' does not equal 'Session Memory'.
Alert for for the database on z/OS contains multiple "ORA-04030: out of process memory.." errors:
Console dump of z/OS Database service started task also shows user abend U4093 (LE storage allocation failure).
Other abends that may occur are S40D-11 and S878-10. This is not an exhaustive list of all possible abends or error symptoms that may occur due to this problem.
Database version 10.2.0.5 on z/OS running with patch 17906299 - Bundle patch 6 (includes CPUJan2014, 10.2.0.5.14 PSU), and OSDI 1.2.1.7.
Output from DISPLAY MEMORY command when Session Count was 98 or highest, incorrectly shows Region Memory (1356M) minus Shared Memory (740M) does NOT equal Session Memory (297430K or 290M), but Session Memory should be 616M!
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 |