流池不断无限增大的导致paused for flow control

流池不断无限增大的导致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