How to cache tables in memory in Oracle

Oracle quickly caches tables in memory, making access faster. There are 2 ways to do this: 1） alter table fisher cache; 2） alter table fisher storage(buffer_pool keep); --取消缓存 1） alter table fisher nocache; 2） alter table fisher storage(buffer_pool default ); select table_name,OWNER,cache,buffer_pool from dba_tables where table_name= ‘FISHER‘ ;  --查看是否缓存 select * from dba_segments where segment_name= ‘FISHER‘ ;          --查看表大小The difference between the two:

1) The cache caches the table into the share pool, which directly controls the hot end of the table cache, which is controlled by the LRU algorithm.

2) cache The table in a fixed memory space, by default, Buffer_pool space is 0. You need to set the space size manually.

alter system setdb_keep_cache_size=50M scope=both sid=‘*‘;

The first method has been used.

How to cache tables in memory in Oracle