Oracle 表缓存

表装入内存

alter table sys_datastore storage(buffer_pool keep);
alter table sys_datastore cache;
--检查
select table_name from dba_tables where ltrim(cache)='Y'

表卸出内存

alter table sys_datastore nocache;
--检查
select table_name from dba_tables where ltrim(cache)='Y'
--select cache from dba_tables group by cache;