The reason I speculated that these are freeabl is because in Steve Adams
book, the definition of freeable is that "Chunks contain objects that
are normally needed for the duration of a session call, and are freed
thereafter ...". Let's see i f Steve has some time to clarify this.
From: Radoulov, Dimitre [mailto:firstname.lastname@example.org]
Sent: Wednesday, February 08, 2006 11:37 AM
Cc: Hameed, Amir
Subject: Re: "session param valu" in x$ksmlru
>> It seems that these cause a lot of flushes. Are these chunks of type
> The session param values (memory allocated at the start of each
> are large contiguous allocations.
> Once the regular pool is chunked up into 4K or smaller pieces large
> allocations should come from reserved pool.
> So, if you get ORA-04031 for an allocation such as this, the solution
> usually to increase the size of the reserved pool.
I *think* these allocations are not freeable as long as the session is
Correct me if I'm wrong.