{パフォーマンスの管理その他}KEEPプールとRECYCLEプールを構成し、それぞれのプールを使用するテーブルB,Cを作成

 

https://docs.oracle.com/cd/F19136_01/tgdba/tuning-database-buffer-cache.html#GUID-DE6B6C6E-D947-45FF-B189-F0271B86DB10
https://docs.oracle.com/cd/F19136_01/tgdba/tuning-database-buffer-cache.html#GUID-30C8D6DD-C903-4484-B435-D51DF601D8B1

show parameter cache

alter system set DB_RECYCLE_CACHE_SIZE=50M;
alter system set DB_KEEP_CACHE_SIZE=50M;

create table sh.recycle(
 col1 number,
 col2 date
)
storage( BUFFER_POOL recycle);

create table sh.keep(
 col1 number,
 col2 date
)
storage( BUFFER_POOL keep);

select table_name,BUFFER_POOL from dba_tables where table_name in ('RECYCLE','KEEP');