(1)查看表的存放地点,默认存放到default中
SQL> select
table_name,tablespace_name,blocks,buffer_pool from dba_tables where
owner='SCOTT';
TABLE_NAME TABLESPACE BLOCKS BUFFER_
---------- ----------
---------- -------
DEPT SYSTEM 1 DEFAULT
EMP SYSTEM 1 DEFAULT
BONUS SYSTEM 0 DEFAULT
SALGRADE SYSTEM 1 DEFAULT
(2)SQL>
show parameter cache;
db_keep_cache_size big integer 0--查看keep的大小,目前为O
(3)SQL>
alter system set db_keep_cache_size=10m; --给keep分配固定空间
(4)SQL>
show parameter cache;
NAME TYPE VALUE
------------------------------------
----------- ------------------------------
db_16k_cache_size