Re: 1.7GB SHARABLE_MEM used by single SQL

From: Grzegorz Goryszewski <>
Date: Wed, 15 Jun 2011 20:48:15 +0200
Message-ID: <>

On 2011-06-15 17:39, Eagle Fan wrote:
> hi:
> Is there any way to dump a cursor's sharable memory?
> When the SQL's version was not increasing, the sharable memory was
> increasing slowly. I'm curious what caused the increasing of sharable
> memory.

 I think You can try with Tanel's curheaps.sql script.

File name: curheaps.sql

-- Purpose:     Show main cursor data block heap sizes and their contents
--              (heap0 and heap6)

You can obtain source from

take few snapshots and check which heap is growing .

btw what is the reason behind high version count ? Regards

Dzwonki MP3 na telefon. To sa prawdziwe hity! Pobierz >>
Received on Wed Jun 15 2011 - 13:48:15 CDT

Original text of this message