ORA-4031 After Upgrade To 220.127.116.11 With Leak in 'KTC latch subh' Subheaps
(Doc ID 1398984.1)
Last updated on FEBRUARY 19, 2019
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 11.2]
Information in this document applies to any platform.
This issue was observed in 126.96.36.199 shortly after upgrading to 188.8.131.52.
The symptoms are:
- ORA-4031 errors after the database has been running for some time.
- The ORA-4031 can show messages for Shared Pool, Streams Pool, or any other pool in the SGA, but most commonly for the Shared Pool.
- The heapdump will show the largest memory area is 'KTC latch subh'.
- Even without a ORA-4031, heapdumps taken at intervals will show this subheap continually growing in size.
At 2011-11-28 18:33:27, 'KTC latch subh' size was 425320296 bytes.
At 2011-11-29 11:52:20, 'KTC latch subh' size was 438683272 bytes.
At 2011-11-29 11:57:29, 'KTC latch subh' size was 458469272 bytes.
At 2011-12-02 16:16:02, 'KTC latch subh' size was 630790264 bytes.
At 2011-12-05 21:00:14, 'KTC latch subh' size was 1040848080 bytes.
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