Re: "session param valu" in x$ksmlru
- From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
- To: <Amir.Hameed@xxxxxxxxx>
- Date: Wed, 8 Feb 2006 17:30:47 +0100
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 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.
Understanding Shared Pool Memory Structures (OOW 2005 White Paper)
Other related posts: