Re: PL/SQL Tables - Memory Allocation Puzzle

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 5 Dec 1999 10:26:11 -0000
Message-ID: <944389727.8164.0.nnrp-10.9e984b29@news.demon.co.uk>

Slight timing problem there - by the time I got the dump to run, the relevant call heap had already been freed.

I have now managed to do the heapdump
whilst the memory is still in use, and find that most of the 4Mb+ breaks down to

        1,000  chunks of 32 bytes labelled
            freeable  "pl/sql vc2"
and
        1,006 chunks of 4120 bytes labelled
            freeable "kolcalm coll"

In comparison, the loop dump using evey 10th slot in the array generated only 43 chunks of "kolcalm coll"

The corresponding dumps from 7.3.4 are completely different - showing a few chunks of 3,296 bytes labelled "plbtn: keys and d" and a few of 32 bytes labelled "plbtn" - presumaly the metods changed completely between 7 and 8.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Jonathan Lewis wrote in message
<944322668.3152.1.nnrp-02.9e984b29_at_news.demon.co.uk>...
>
>Interesting detail - when I did a heapdump on
>the process, it showed 4M as FREE (not
>freeable or recreatable, actually free). I
>suggest you raise this as a bug with tech
>support.
>
Received on Sun Dec 05 1999 - 04:26:11 CST