Oracle Database Discussions

The keep buffer pool retains the schema objects in the memory. and the recycle buffer pool eliminates the data blocks from the memory as soon as they are no longer needed.

Now i have a table shares with 230Mb of dataa (approx 34M rows).

i use the alter table shares cache; statement to indicate that the blocks of the segment shares have to be kept in the memory.

i use the alter table shares nocache; statement to indicate the blocks should be removed once the work is done.


1. am i correct for the above statements regarding using the cache and nocache option.
2. can any one tell me how to specify htat the blocks of a particular segment have to be in keep cache. if the above statement is false.
3. please guys, can any one explain me the details regarding how to cache. and how to use recycle cache size for segments.