流池不断无限增大的导致paused for flow control
关于流池大小的问题?高手们进啊
select * from v$sgastat where pool='streams pool' order by bytes desc;
1 streams pool kolccst obj 558854216
2 streams pool koicnfadt adt attr 152806536
3 streams pool kolcalm coll 138289536
4 streams pool kol raw 105551536
5 streams pool kol vstring 90860352
6 streams pool free memory 75495336
能不能解释下kolccst obj这个是什么意思?我流池的free memory不断减小,导致捕获进程无法捕获,增加了流池后可以继续捕获,
但是一天后kolccst obj增大,free memory减少 ,捕获又中断了
==================================
bug
Subject: Bug 5058318 - Memory leak (in "koh-kghu" heap of type "kolccst obj")
Doc ID: Note:5058318.8 Type: PATCH
Last Revision Date: 24-SEP-2008 Status: PUBLISHED
Bug 5058318 Memory leak (in "koh-kghu" heap of type "kolccst obj")
This note gives a brief overview of bug 5058318.
The content was last updated on: 03-APR-2008
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
Versions confirmed as being affected 10.2.0.3
Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in 10.2.0.4 (Server Patch Set)
11.1.0.6 (Base Release)
Symptoms: Related To:
Leak (Memory Leak / Growth)
Streams / Logical Standby
Description
A memory leak can occur in the "koh-kghu" heap of type "kolccst obj".
This can affect Streams.
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. Always consult with Oracle Support for advice.
References
Bug 5058318 (This link will only work for PUBLISHED bugs)
Note 245840.1 Information on the sections in this article
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
.
My Oracle Support (the new MetaLink) Bookmarks Admin Profile Feedback Sign Out Help
Copyright © 2006, Oracle. All rights reserved. Legal Notices and Terms of Use | Privacy Statement