Space Usage

Space usage oracle parameters can be used to define free space and setting limit for the capacity of database blocks.

Pctfree:

This parameter is used to define the free space (as a percentage) in each database block of an object reserved for future updates. You can enter a value between "0" and "99". The default value for this parameter is "10".

Pctused:

This parameter is used to set a limit for the capacity of the database blocks, allowing the block to be further filled if the capacity is not used up. You can enter a value between "0" and "99". The default value is "40" (%). This parameter cannot be used for indices.