schema_history_archive_expire_time

Description

The schema_history_archive_expire_time parameter specifies the retention period of schema history archive data.

To avoid unbounded growth of archive tables, OceanBase Database introduces controllable garbage collection (GC). During GC, the system calculates the cutoff schema version based on the retention period and the recycle point, and then deletes archive history data in batches.

Privilege requirements

• Query the parameter

  The sys tenant and all user tenants can query this parameter by using the SHOW PARAMETERS statement or the GV$OB_PARAMETERS view.

• Modify the parameter

  The sys tenant and user tenants can modify this parameter.

Attributes

Examples

• System tenant

  • Disable GC for schema history archive data in the tenant1 tenant.

    obclient(root@sys)[(none)]> ALTER SYSTEM SET schema_history_archive_expire_time = '0' TENANT = tenant1;
    

  • Set the retention period of schema history archive data in the tenant1 tenant to 90 days.

    obclient(root@sys)[(none)]> ALTER SYSTEM SET schema_history_archive_expire_time = '90d' TENANT = tenant1;
    

• User tenant

  • Disable GC for schema history archive data in the current tenant.

    obclient> ALTER SYSTEM SET schema_history_archive_expire_time = '0';
    

  • Set the retention period of schema history archive data in the current tenant to 90 days.

    obclient> ALTER SYSTEM SET schema_history_archive_expire_time = '90d';