Oracle supports multiple block sizes in a database. The standard block size is used for
the SYSTEM tablespace. This is set when the database is created and can be any valid
size. You specify the standard block size by setting the initialization parameter
DB_BLOCK_SIZE. Legitimate values are from 2K to 32K.
In the initialization parameter file or server parameter, you can configure subcaches
within the buffer cache for each of these block sizes. Subcaches can also be configured
while an instance is running. You can create tablespaces having any of these block
sizes. The standard block size is used for the system tablespace and most other
tablespaces.
Note: All partitions of a partitioned object must reside in tablespaces
of a single block size.
多样的块值大小
1. 有DB_BLOCK_SIZE初始参数控制标准的块大小 , 2K to 32K为合法的值
2. 分区对象只能是单一的块值
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-975629/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10599713/viewspace-975629/