Bug 6739842: Oracle Processes Consume A Lot Of Memory May encounter ora-4030
Last updated on MARCH 11, 2010
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 22.214.171.124 - Release: 10.2 to 11.1
A subheap dump will show allocations of "koh-kghu sessi" and comment "rowid resize heap".
This apparently can leak memory over time and since this is allocated at the 'session' duration it will hang around longer than the PL/SQL block is used.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms