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@(protected)> 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@(protected)] 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 (See ORA-04031.ora-code.com) 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.
When I read about the evils of drinking, I gave up reading.
-- ---- ---- ---- ---- ---- -----
What are the most popular cars? Find out at Yahoo! Autos <div>Hi,</div> <div> </div> <div>AFAIK <FONT face=Helvetica><STRONG> "Session Param Value" </STRONG>chunks are allocated as freeable. But you can easily confirm the same by taking a heapdump at level 2 using the following command</FONT></div> <div><FONT face=Helvetica></FONT> </div> <div><FONT face=Helvetica>alter system set events 'immediate trace name heapdump level 2';</FONT></div> <div><FONT face=Helvetica></FONT> </div> <div> <FONT face=Helvetica>Regards,</FONT></div> <div><FONT face=Helvetica>-Fairlie< /FONT></div> <div><BR><BR><B><I>"Hameed, Amir" <Amir.Hameed@(protected)></I ></B> wrote:</div> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN -LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">The reason I speculated that these are freeabl is because in Steve Adams<BR>book, the definition of freeable is that "Chunks contain objects that<BR>are normally needed for the duration of a session call, and are freed<BR>thereafter ...". Let's see i f Steve has some time to clarify this.<BR><BR>Amir<BR>-- --Original Message-- --<BR >From: Radoulov, Dimitre [mailto:cichomitiko@(protected)] <BR>Sent: Wednesday, February 08, 2006 11:37 AM<BR>To: ORACLE-L<BR>Cc: Hameed, Amir<BR>Subject: Re: "session param valu" in x$ksmlru<BR><BR><BR><BR><BR>>> It seems that these cause a lot of flushes. Are these chunks of type <BR>>> "freeable"?<BR> ><BR>> The session param values (memory allocated at the start of each<BR >session) <BR>> are large contiguous allocations.<BR>> Once the regular pool is chunked up into 4K or smaller pieces large <BR>> allocations should come from reserved pool.<BR>> So, if you get ORA-04031 (See ORA-04031.ora-code.com) for an allocation such as this, the solution<BR>is <BR>> usually to increase the size of the reserved pool.<BR><BR>I *think* these allocations are not freeable as long as the session is <BR>"alive".<BR>Correct me if I'm wrong.<BR><BR><BR>Regards,<BR>Dimitre<BR><BR><BR><BR><BR>--<BR>http://www .freelists.org/webpage/oracle-l<BR><BR><BR></BLOCKQUOTE><BR><BR><BR><DIV> <DIV> <DIV> <DIV> <DIV> <DIV><STRONG>Fairlie Rego<BR></STRONG>Senior Oracle Consultant</DIV> <DIV>Optus Telecommunications</DIV> <DIV><A href="http://www.optus.com.au/">www.optus.com.au</A></DIV> <DIV>Mobile: +61 4 02 792 405</DIV> <DIV>Home: +61 2 8920 0273</DIV> <DIV><BR> </DIV> <DIV><FONT face="comic sans ms">When I read about the evils of drinking, I gave up reading</FONT>.</DIV></DIV></DIV></DIV></DIV></DIV><p> <hr size=1> <BR> What are the most popular cars? Find out at <a href="http://us.rd.yahoo.com/evt =38382/_ylc=X3oDMTEzNWFva2Y2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDMmF1dG9z/ *http://autos.yahoo.com/newcars/popular/thisweek.html ">Yahoo! Autos</a>
