Oracle creates table spaces for different blocks of data ____oracle

The data block db_block_size size of the Oracle database determines the size of the smallest block of data in the database, and you can set your own block size if you do not want to use the default block size when creating the table space.

Specific examples are as follows:

Create Tablespace test_16k
BlockSize 16K
DataFile ' d:/oradata/test_16k.dbf ' size 100m reuse
Extent Management Local
Uniform size 1M
Segment Space management manual;

In addition, you must set up a data buffer area for this type of tablespace, the default db_cache_size size is only the default block size of the data buffer area, you can set the other block size data cache by parameter db_nk_cache_size, This parameter is 0 because the database was built.

Can be modified by:

Alter system set db_16k_cache_size= 10M scope=spfile;

Sets the data buffer for the data in the table space.