表的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.youkuaiyun.com/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博客 ” ，链接：http://blog.itpub.net/11990065/viewspace-752975/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11990065/viewspace-752975/