Re: Keep and Recycle Pool

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