Create Tablespace: Storage Page

Extent Management

An "Extent" controls how space is allocated to an object. When you specify the size for an extent, a number of contiguous Oracle blocks are assigned. For example, when you specify an extent size of 10K, and the block size is 2K, then 5 Oracle blocks make up the extent.

Locally Managed

Managed in the dictionary

InitialSize (KB)

Size of the first extent when an object is created. Enter the size of the initial extent. Use the unit button to specify either kilobytes, or megabytes. If you do not specify a size, the default value will be the size of 5 Oracle database blocks.

Next Size (KB)

Size of the next allocated extent when the object needs more space to store data. Enter the size of the next extent. Use the unit button to specify either kilobytes or megabytes. If you do not specify a size, the default will be the size of 5 Oracle database blocks.

Minimum Size (KB)

When an object is created, all extents will be sized using a multiple of this value.

To minimize fragmentation in the tablespace, you can set this value. Enter a value for the minimum size. If you do not specify a value, the default is 0 (zero).

Increment Size by %

Percent by which each extent after the second grows, over the previous extent. Enter a value for the percent increase. If you do not specify a value, the default will be 50%.

Minimum Number

Total number of extents to be allocated when an object is created in the tablespace. Enter the minimum number of extents. If you do not specify a number, the default value will be 1.

Maximum Number

Maximum number of extents that can be allocated to an object created in the tablespace.

Unlimited : When selected, allows you to create a number of extents that is only limited by the amount of contiguous free space in a tablespace.

Value : When selected, allows you to specify the maximum number of extents. If you do not specify a value, the default value applies. The default and maximum values depend on the data block size.

Enable Logging

Yes : If you enable logging, redo logs are created. The operation takes longer than if you did not enable logging, but you can recover updates in the event of an unexpected failure.

No: If you do not enable logging, operation time is shorter because no redo logs are created. Since no redo logs are created, you cannot recover your updates in the case of an unexpected failure.

Block Size

The default value is the one that you had selected while specifying the Initialization Parameters for Database Sizing. You can also choose to override this default value, by selecting the required value from the drop-down list.