Hi, In 10.1.0.3 there is a parameter _kglsim_maxmem_percent which specifies the max percentage of shared pool the library cache advisor may use and also there's a _library_cache_advice parameter which can be used for turning lib cache advisor off. In benchmarks at least, this parameter is turned off. I haven't tested those parameters, thus I don't know whether/how these actually work... Tanel. ----- Original Message ----- From: "rjamya" <rjamya@xxxxxxxxx> To: "K Gopalakrishnan" <kaygopal@xxxxxxxxx>; "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx> Sent: Friday, May 06, 2005 4:09 PM Subject: Re: kglsim heap allocation > Thanks Gopal, > > I am home today, but I can send you one on Sunday if you'd like. Also > if you can, check TAR 4307695.994 will all information. > > Can we turn off shared pool/lib cache advisor without loosing any > other functionality? > > On 5/6/05, K Gopalakrishnan <kaygopal@xxxxxxxxx> wrote: >> Raj: >>=20 >> You are quite correct. KGLSIM is Library Cache SIMulator. It is used >> for Shared Pool/Library Cache advisor. I am not sure any event or >> underscores to turn that off. Do you have the errors quite often? I >> would like to see the errorstack if that is the case. >>=20 >> Thanks > -- > //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l