when to use CACHE option

Hi All,

Oracle allows us to specify CACHE at the table level. I understand that it places the blocks retrieved at the most recently used end so that the data wont be swapped out.

Is there any guidelines (best practices) when to use CACHE and when not to use CACHE option ?. Likewise for IOTs.

Thanks for anhy thoughts

Vissu Received on Thu Jun 27 2002 - 05:58:21 CEST