Managing the growth of data on your instance

Manage the growth and storage of data on your instance using data management policies.

Overview of managing data growth

Data management policies streamline administration by allowing you to define multiple archive and table cleaner rules for a table within a single policy record. Additionally, you can easily activate or deactivate all rules simultaneously from the data management policy record.

• Create a data management policy

  Create a data management policy for any table that accumulates data that you want to archive or delete periodically.

• Create an archive rule

  Move records in a primary table to an archive table, including any records in other tables that reference those records.

• Create a table cleanup rule

  Prevent data from growing exponentially by implementing table cleanup rules.

• Activate database rotation

  Preserve instance performance and mitigate risks associated with querying growing data sets.

• Create a data management policy
  Define a set of rules for managing table data on your instance.
• Archiving records
  Manage table size growth and improve query performance by archiving records.
• Deleting older or unwanted records
  Delete older, expired, or unwanted records from tables automatically.
• Applying database rotation techniques
  Manage table size growth, archive data, and boost query performance by configuring database rotation.