Keep and Recycle Pool

From: Wojciech Skrzynecki <wojciech.skrzynecki_at_gmail.com>
Date: Sat, 14 Oct 2006 00:59:44 +0200
Message-ID: <e44afebe0610131559q12e7845x12443140f69afe7e@mail.gmail.com>

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

Received on Fri Oct 13 2006 - 17:59:44 CDT