表的buffer_pool
Oracle的buffer cache 由三个部分组成： default pool，keep pool 和Recycle pool. 每个Pool 都有自己的LRU来管理.
（1）The default pool is for everything else.
（2）The recycle pool is for larger objects.
（3）The keep pool's purpose is to take small objects that shouldalways be cached, for example Look Up Tables.
http://blog.csdn.net/tianlesoftware/article/details/6581159
可以整表，也可以分区表
ALTER TABLE tg STORAGE(BUFFER_POOL KEEP);
-- Create table
create table TG
(
id INTEGER not null,
city varchar2(10)
)
partition by list (city)
(
partition PARTYARD values ('SZ')
tablespace DBOKEEP
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents UNLIMITED
BUFFER_POOL KEEP
),
partition PARTSHIP values ('GZ')
tablespace DBOKEEP
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
)
);
可以通过以下视图查看：
SELECT * FROM USER_TABLES A WHERE A.BUFFER_POOL='KEEP';
SELECT A.BUFFER_POOL,A.* FROM USER_TAB_PARTITIONS A WHERE /*A.BUFFER_POOL='KEEP' AND*/ A.TABLE_NAME='TG';
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11990065/viewspace-752975/ ，如需转载，请注明出处，否则将追究法律责任。
