SQL> show parameter cache_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_16k_cache_size big integer 0
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_cache_size big integer 0
db_keep_cache_size big integer 0
db_recycle_cache_size big integer 0
SQL> alter system set db_16k_cache_size = 100M;
System altered
SQL> show parameter cache_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_16k_cache_size big integer 100M
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_cache_size big integer 0
db_keep_cache_size big integer 0
db_recycle_cache_size big integer 0
SQL> create tablespace TBS_LJB_16K
2 blocksize 16k
3 datafile 'D:\oracle\product\10.2.0\oradata\orcl\TBS_LJB_16K_01.DBF' size 100M
4 autoextend on
5 extent management local
6 segment space management auto;
Tablespace created
SQL> drop table t_16K purge;
Table dropped
SQL> create table t_16K tablespace TBS_LJB_16K as select * from dba_objects ;
Table created
SQL> select count(*) from t_16K;
COUNT(*)
----------
50622
SQL>
创建 块大小为16K的表空间 语法
最新推荐文章于 2024-01-17 23:25:56 发布