enable_auto_split

Description

The enable_auto_split parameter specifies whether to enable automatic partition splitting for a tenant.

Privilege requirements

• Query the parameter

  The sys tenant and all user tenants can execute the SHOW PARAMETERS statement or query the GV$OB_PARAMETERS view to obtain the value of this parameter.

• Modify the parameter

  The sys tenant and user tenants can execute the ALTER SYSTEM SET statement to modify the value of this parameter.

Attributes

Considerations

You can execute the ALTER SYSTEM SET statement to set the value of this parameter.

The enable_auto_split parameter determines whether to create an auto-partitioned table when the table is created without explicitly specifying the auto-partition clause. If the auto-partition property is explicitly set for the table, this configuration does not take effect.

• If the value of the enable_auto_split parameter is true, an automatically partitioned table is created only when the table meets the automatic partitioning requirements.
• If the value of the enable_auto_split parameter is false, the value is modified to true later, existing tables that meet the automatic partitioning requirements are not affected, and only new tables are automatically partitioned.

For more information about automatic partition splitting, see Automatic partition splitting (MySQL mode) or Automatic partition splitting (Oracle mode).

Examples

The following example shows how to enable automatic partition splitting.

ALTER SYSTEM SET enable_auto_split = TRUE;

References

auto_split_tablet_size