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;