11gR2/Aix - Dedicated Server Processes Have Large Usla Heap Segment Compared To Older Versions
(Doc ID 1260095.1)
Last updated on FEBRUARY 20, 2019
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 11.2]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
IBM AIX on POWER Systems (64-bit)
Dedicated server processes using significantly more memory on 11gR2 compared to previous versions (9i, 10g, 11g).
Using svmon to monitor process memory segment after initial DB connection, You can observe that typical USLA heap size jumped from ~0.4M in 10g to 7.0M in 11gR2.
svmon -P PID - where PID is an Oracle process id
Oracle Release -> (work USLA heap times 4k pages size)
18.104.22.168.0 -> 7M bytes
22.214.171.124.0 -> 60KB
10.2.0.4.0 -> 420KB
Slow system performance for larger footprint of all oracle server process. If physical memory is fully used, the could terminate an Oracle instance via terminating a PMON process.
Upgraded to 11gR2
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