Re: "session param valu" in x$ksmlru

>> It seems that these cause a lot of flushes. Are these chunks of type
>> "freeable"?
>
> The session param values (memory allocated at the start of each session)
> 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 is
> usually to increase the size of the reserved pool.

I *think* these allocations are not freeable as long as the session is "alive".
Correct me if I'm wrong.

Regards,
Dimitre  

--
http://www.freelists.org/webpage/oracle-l