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: Keep and Recycle Pool

Re: Keep and Recycle Pool

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Fri, 13 Oct 2006 20:18:31 -0400
Message-ID: <c2213f680610131718q25588a6bkb245c3cc33c7cea5@mail.gmail.com>


You probably read something wrong. You can find a some of answers in standard Oracle documentations and others you might infer from what you know about your application and what you read from docs. Consider those:
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14220/memory.htm#sthref1304 http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14211/memory.htm#sthref540

Now, from practical point of view Oracle is really good managing it's cache and usually it's effective enough keeping hot blocks in memory without configuring keep and recycle pools.

On 10/13/06, Wojciech Skrzynecki <wojciech.skrzynecki_at_gmail.com> wrote:
> Hello
>
>
> I would like to ask you about KEEP_POOL and RECYCLE_POOL. I read about
> this subjects, but maybe you have experience with that. What is better
> to put into KEEP or RECYCLE - big tables or small tables with index or
> without index. How can I find the best candidates to keep pool or
> recycle_pool?
> How does keep behaves when client inserts or updates data.
> Any suggestion are very welcome.
>
> Rgds.
>
> Wojtek
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Best regards,
Alex Gorbachev

The Pythian Group
Sr. Oracle DBA

http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 13 2006 - 19:18:31 CDT

Original text of this message

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