Oracle.exe Leaks Mutex Handles And Memory Size Increases In Windows 11.2.0.4.9 And Above
(Doc ID 2251486.1)
Last updated on FEBRUARY 15, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Microsoft Windows x64 (64-bit)
Symptoms
Oracle.exe process on Windows platform increases its memory usage if Windows bundle patch 11.2.0.4.9 and above is installed.
Using an utility like handle.exe, oracle.exe process leaks Mutex (Mutant) handles and memory usage increases due to these handles.
Output of handle.exe program
----------------------------
Handle type summary:
ALPC Port : 5
Desktop : 1
Directory : 2
EtwRegistration : 28
Event : 116
File : 222
IoCompletion : 3
Key : 10
KeyedEvent : 1
Mutant : 80035 <==
Section : 32
Semaphore : 29
Thread : 76
Timer : 3
TpWorkerFactory : 2
WindowStation : 2
Total handles: 80567
This is related to the number of dblink connections made in this instance. Each time dblink operation like the following is executed, Mutex handle count in oracle.exe process increases.
SQL> sqlplus <LOGIN>/<PASSWORD>
SQL> select * from <TABLE_NAME>@<DB_LINK_NAME>;
SQL> exit
Changes
Reproduce with Windows bundle patch between 11.2.0.4.9 and 11.2.0.4.161118
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 |
| Changes |
| Cause |
| Solution |
| References |