For more information about what the Oracle high-speed cache is and how it works, see:
Http://www.php100.com/html/webkaifa/database/oracle/2008/0709/1348.html
The db_buffer_pool of Oracle consists of three parts:
Buffer_pool_defualt
Buffer_pool_keep
Buffer_pool_recycle
show parameter DB_CACHE_SIZE;show parameter keep;
First, you need to change the cache size:
Alter system set db_keep_cache_size = 10 m; -- 10 m or 512 K
If you want to pin the table to the memory, that is, pin the table to the keep area. Related commands:
alter table ..... storage(buffer_pool keep);
This command caches the table in the keep area if it is cached.
You can use the following statement:
select table_name from dba_tables where buffer_pool='KEEP';
The changed table is saved in the keep area. But it does not mean that the table has been cached.
The following statement caches the table:
alter table .... cache;
You can use
select table_name from dba_ tables where trim(cache)='Y';
The table has been cached.
The table added to the keep area does not mean that it cannot be removed from the memory, but is not easy to remove from the memory.
You can also manually remove the memory. The command is as follows:
alter table ... nocache;
Remarks: This article Reprinted from: http://blog.itpub.net/post/42422/501800