Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Multiple Buffer Pool
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFF18D.6764A4B8
Content-Type: text/plain;
charset="iso-8859-1"
Hi
Just want to how many of you pin system packages in the keep pool. If so what kind of performance improvement have you seen. I have been doing some test on pinning some of the system packages and I have not seen much of improvement. I even pinned my lookup(static) tables into the keep pool to and I have not seen any performance gain.
Any other suggestions on how to optimal set keep,recycle pool are also welcomed.
Thx
Gautam Reddy
728-3656(512)
gautam_reddy_at_dell.com <mailto:gautam_reddy_at_dell.com>
www.dell.com <http://www.dell.com/>
------_=_NextPart_001_01BFF18D.6764A4B8
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.2919.6307" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=226341914-19072000>Hi</SPAN></FONT></DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=226341914-19072000></SPAN></FONT> </DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=226341914-19072000>Just want to how many of you pin system packages in the
keep pool. If so what kind of performance improvement have you seen. I have
been doing some test on pinning some of the system packages and I
have not seen much of improvement. I even pinned my lookup(static)
tables into the keep pool to and I have not seen any performance
gain. </SPAN></FONT></DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=226341914-19072000></SPAN></FONT> </DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=226341914-19072000>Any other suggestions on how to optimal set
keep,recycle pool are also welcomed. </SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2>Thx</FONT></DIV>
<DIV><FONT face="Comic Sans MS" size=2><STRONG>Gautam
Reddy</STRONG></FONT></DIV>
<DIV><FONT face="Comic Sans MS"
size=2><STRONG>728-3656(512)</STRONG></FONT></DIV>
<DIV><FONT face="Comic Sans MS" size=2><STRONG><A
href="mailto:gautam_reddy_at_dell.com">gautam_reddy_at_dell.com</A></STRONG></FONT></DIV>
<DIV><FONT face=Arial size=2><A
href="http://www.dell.com/">www.dell.com</A></FONT></DIV>