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

[Juan Carlos Reyes Pacheco]

Hello, please
So, the questions are.
Is necessary to manage a pool for keep and recycle for tables and indexes
in oracle databases?
If it is necessary, then how should be done in 12c?
Thank you :)

I don't have the idea clear, which is the best method to keep and recycle
different data blocks in Oracle 12.1.0.1;
because they deprecated both parameters in 12c, is like Oracle is saying
don't do it:

buffer_pool_keep
buffer_pool_recycle

But in theory both of them are still in use, and you should do it,

but there is no another proposal, the table cache property,

could be used inside the same cache,

but I understand they don't cache indexes.

:)

[Andy Sayer]

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?

[Juan Carlos Reyes Pacheco]

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.

Post by Andy Sayer
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?

[Mladen Gogala]

That is one of the few beetlejuice versions.

Post by Andy Sayer
You should really be thinking about patching, 12.1.0.1 is very old and
full of bugs.