keep 与catch 是独立的,应该是一个是池,一个是lru冷热端
SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 11月 7 10:14:17 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
sys@ORCL> conn anbob/anbob
Connected.
anbob@ORCL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
TESTINDEX
TESTA
anbob@ORCL> select table_name,cache,buffer_pool from user_tables;
TABLE_NAME CACHE BUFFER_
------------------------------ ------
TESTINDEX N DEFAULT
TESTA N DEFAULT
anbob@ORCL> alter table testa cache;
Table altered.
anbob@ORCL> select table_name,cache,buffer_pool from user_tables;
TABLE_NAME CACHE BUFFER_
------------------------------ ---------- -------
TESTINDEX N DEFAULT
TESTA Y DEFAULT
nbob@ORCL> alter table testindex storage (buffer_pool keep);
Table alte
red.
anbob@ORCL> select table_name,cache,buffer_pool from user_tables;
TABLE_NAME CACHE BUFFER_
------------------------------ ---------- -------
TESTINDEX N KEEP
TESTA Y DEFAULT
anbob@ORCL> alter table testindex cache;
Table altered.
anbob@ORCL> select table_name,cache,buffer_pool from user_tables;
TABLE_NAME CACHE BUFFER_
------------------------------ ---------- -------
TESTINDEX Y KEEP
TESTA Y DEFAULT