Bug 13250244 Shared pool leak of "KGLHD" memory when using multiple subpools
This note gives a brief overview of bug 13250244.The content was last updated on: 05-JUL-2013
Click here for details of each of the sections below.
Affects:
Product (Component) Oracle Server (Rdbms) Range of versions believed to be affected Versions >= 11.1 but BELOW 12.1 Versions confirmed as being affected Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in
Symptoms: | Related To: |
|
Description
Shared pool memory of type "KGLHD" may be leaker, potentially leading to ORA-4031 errors when multiple shared pool subpools are in use. The problem is easily triggered if stored outlines are used, but the use of stored outlines is not required to hit this problem. Rediscovery Notes: This problem may be being seen of both of the following are true: (a) Hitting ORA-4031 or shared pool usage increases due to many "KGLHD" allocations (b) Multiple shared pool subpools are in use. (eg the internal parameter _kghdsidx_count set to a value greater than 1) Workaround Set "_kghdsidx_count"=1 so that only one shared pool subpool is used. Note that in highly concurrent environments this workaround may cause shared pool and library cache latch related contention issues.Getting a Fix Use one of the "Fixed" versions listed above (for Patch Sets / bundles use the latest version available as contents are cumulative - the "Fixed" version listed above is the first version where the fix is included) or You can check for existing interim patches here: Patch:13250244
Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support. |
References
Bug:13250244 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article