Bug 13250244 - Shared pool leak of "KGLHD" memory when using multiple subpools (文档 ID 13250244.8)

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 affectedVersions >= 11.1 but BELOW 12.1Versions confirmed as being affected

• 11.2.0.3
• 11.2.0.2
• 11.2.0.1
• 11.1.0.7

Platforms affectedGeneric (all / most platforms affected)

Fixed:

This issue is fixed in

• 12.1.0.1 (Base Release)
• 11.2.0.4 (Future Patch Set)
• 11.2.0.3.4 Database Patch Set Update
• 11.2.0.3 Bundle Patch 10 for Exadata Database
• 11.2.0.2.8 Database Patch Set Update
• 11.2.0.2 Bundle Patch 18 for Exadata Database
• 11.2.0.3 Patch 10 on Windows Platforms
• 11.2.0.2 Patch 21 on Windows Platforms

Symptoms:

Related To:

• Error May Occur
• Leak (Memory Leak / Growth)
• Shared Pool Affected
• ORA-4031

• _kghdsidx_count
• USE_STORED_OUTLINES

Description

Shared pool memory of type "KGLHD" may be leaker, potentiallyleading to ORA-4031 errors when multiple shared pool subpoolsare in use.  The problem is easily triggered if stored outlines are used, but the useof 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

---

---

  

相关内容

   

 

产品

   

• Oracle Database Products > Oracle Database > Oracle Database > Oracle Database - Enterprise Edition