ORA-04030 OUT OF PROCESS MEMORY - MEMORY INCREASING - ABEND U4093 (LE STORAGE ALLOCATION FAILURE)
(Doc ID 1907959.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.5 to 10.2.0.5 [Release 10.2]
IBM z/OS on System z
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 188.8.131.52.
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!
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!