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.



Reference:

Understanding Shared Pool Memory Structures (OOW 2005 White Paper)

Regards,
Dimitre


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


Other related posts: