创建块大小为16K的表空间语法

本文链接：https://blog.csdn.net/badyflf/article/details/51160849

本文展示了如何通过SQL命令调整Oracle数据库中的缓存大小，并创建了一个使用16KB块大小的表空间来验证缓存设置的效果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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>