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

Home -> Community -> Mailing Lists -> Oracle-L -> Multiple Buffer Pool

Multiple Buffer Pool

From: <Gautam_Reddy_at_Dell.com>
Date: Wed, 19 Jul 2000 09:26:58 -0500
Message-Id: <10563.112414@fatcity.com>


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>&nbsp;</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.&nbsp;I have been&nbsp;doing some test on pinning some of the&nbsp;system packages and I have&nbsp;not seen much of improvement. I&nbsp;even pinned my lookup(static) tables into the keep pool to&nbsp;and I have not seen any&nbsp;performance gain.&nbsp;</SPAN></FONT></DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=226341914-19072000></SPAN></FONT>&nbsp;</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>&nbsp;</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>

<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV></BODY></HTML>
Received on Wed Jul 19 2000 - 09:26:58 CDT

Original text of this message

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