Analysis on small table cache to memory

Analysis of small table cache to memory the db_buffer_pool of oracle consists of three parts:
Buffer_pool_defualtbuffer_pool_keepbuffer_pool_recycle
If you want to pin the table to the memory, that is, pin the table to the keep area. -- If the table is cached, It is cached in the keep area SQL> alter table t1 storage (buffer_pool keep); the table has been changed. -- Query the table in the keep area, but it does not mean that the table has been cached. SQL> select table_name from dba_tables where buffer_pool = 'keep '; TABLE_NAME www.2cto.com -------------------------------- T1 -- cache SQL> alter table T1 cache for table t1; the table has been changed. -- Check whether the table has been cached SQL> select table_name from dba_tables where trim (cache) = 'y'; the table added to the keep area cannot be removed from the memory, however, it is not easy to remove memory. -- manually remove the specified table from the memory SQL> alter table t1 nocache; the table has been changed. Author: Chen yuchen