datafile_next

datafile_next specifies the step size of automatic scaling for disk files.

The default value of the datafile_next parameter is 0, which indicates that automatic scaling is disabled. To enable automatic scaling, you need to set the parameter to another value based on the following rules:

• If you set the datafile_next parameter to a value less than 1 GB, the following value is used: min(1G,datafile_maxsize×10%).
• If you set the datafile_next parameter to a value greater than 1 GB, the following value is used: min(datafile_next,Remaining disk space).

Example

alter system set datafile_next = '10G';