Data File Size Limit

-- According to the previous documents of guobiao, the size of a single data file is restricted by the main parameter. db_block_size is mainly calculated as db_block_size8K, and the maximum size of a single data file is 32 GB. When db_block_size16k, maximum 64 GB for a single data file when db_block_size32k, maximum 128 GB for a single data file, remarks

-- According to the previous documents of guobiao, the size of a single data file is restricted by the main parameters. The main calculation result of db_block_size is db_block_size = 8 K, maximum 32 GB for a single data file when db_block_size = 16 k, maximum 64 GB for a single data file when db_block_size = 32 k, maximum 128 GB for a single data file, remarks

-- According to the previous documents summarized by instructor guoguo --

How can I limit the size of a single data file?

Restrict the main parameter, db_block_size

Main calculation results

When db_block_size = 8 K, the maximum size of a single data file is 32 GB.

When db_block_size = 16 k, the maximum size of a single data file is 64 GB.

When db_block_size = 32 k, a single data file can be up to 128 GB,

Note:

1. This Parameter Restriction mainly applies to normal tablespaces. Large tablespaces are not in the restriction policy;

2. Set the size of a single data file according to the actual situation, and be careful about the database disaster caused by a tablespace damage;