Re: Please, for 12.1.0.1 which are the best options to keep and recycle cache?

Thank you Andy, but setting cache in default buffer cache for tables is too enough for indexes?

The idea in the past was simple, use the recycle pool for tables you read rarely and the keep pool, for tables you use very frequently. Apparently as you say that is not necessarily, I assume Oracle improved their algorithm in that way.

El jue., 25 oct. 2018 a las 12:23, Andy Sayer (<andysayer_at_gmail.com>) escribió:

> You should really be thinking about patching, 12.1.0.1 is very old and
> full of bugs.
>
> But to answer your question, you really shouldn’t ever need to use either.
> The default buffer cache will do you just fine in almost all scenarios.
>
> Do you think you have a situation which requires fiddling?
>

--
http://www.freelists.org/webpage/oracle-l