Re: "session param valu" in x$ksmlru
- From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
- To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 8 Feb 2006 17:37:00 +0100
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
