Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: "session param valu" in x$ksmlru

Re: "session param valu" in x$ksmlru

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Wed, 8 Feb 2006 17:30:47 +0100
Message-ID: <048301c62ccd$08ac5f70$1a03310a@IBME1D11967173>


> 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
Received on Wed Feb 08 2006 - 10:30:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US