caching large tables -- 8GB Memory

[tamilselvan]

It is a good idea to cache I/O intensive table/Index data in to SGA.
There are 3 different cache areas: 1 KEEP, 2 RECYCLE 3 DEFAULT CACHE.

The DEFAULT is default for all tables and indexes.
Use KEEP for look up tables (master).
Use RECYCLE for rarely updated tables
Use CACHE for all other tables.
Example:
alter table customer storage ( buffer_pool keep );