RE: "session param valu" in x$ksmlru
- From: fairlie rego <fairlie_r@xxxxxxxxx>
- To: Amir.Hameed@xxxxxxxxx
- Date: Thu, 9 Feb 2006 01:32:52 -0800 (PST)
Hi,
AFAIK "Session Param Value" chunks are allocated as freeable. But you can
easily confirm the same by taking a heapdump at level 2 using the following
command
alter system set events 'immediate trace name heapdump level 2';
Regards,
-Fairlie
"Hameed, Amir" <Amir.Hameed@xxxxxxxxx> wrote:
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 if Steve has some time to clarify this.
Amir
-----Original Message-----
From: Radoulov, Dimitre [mailto:cichomitiko@xxxxxxxxx]
Sent: Wednesday, February 08, 2006 11:37 AM
To: ORACLE-L
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
>> "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
Fairlie Rego
Senior Oracle Consultant
Optus Telecommunications
www.optus.com.au
Mobile: +61 4 02 792 405
Home: +61 2 8920 0273
When I read about the evils of drinking, I gave up reading.
---------------------------------
What are the most popular cars? Find out at Yahoo! Autos
Other related posts:
