Retention

A retention policy sets how long Scops keeps each kind of data for its databases. Open Policies › Retention.

The Production retention policy, with one row per kind of data and a bar for its days

Before you begin

  • Changes need Manage Policies.
  • Each database must be in a retention policy. A new database gets Default Retentions.

Change how long data is kept

  1. Click the policy above the table.

  2. Change the days in Keep, from 1 to 365. For Activity, you can also change Sampled.

  3. Click Save. To go back to the saved values, click Discard.

A lower value deletes data. At the next daily cleanup, Scops deletes the data that is older than the new value. The deleted data does not come back.

Faster sampling uses more space: a sample every second uses about five times the space of a sample every 5 seconds.

What each row keeps

DataRead bySampledDefault Retentions keeps
ActivityDashboard, Live ActivityEvery 1, 3, 5 or 15 s (5 s by default)15 days
PerformanceMetricsEvery minute90 days
SQLTop SQL, Insights, execution plansEvery 10 minutes15 days
ServicesServicesEvery 10 minutes90 days
Segment I/OObjects, InsightsEvery hour30 days
Segment sizesSizing, ObjectsDaily90 days
TablespacesTablespaces, Health CheckEvery 10 minutes90 days
ExadataExadata cellsEvery 10 minutes31 days

Scops also keeps hourly and 5-minute summaries for at least 32 days. A chart of the last month keeps its shape.

Radar findings are not in a retention policy. Scops keeps each finding for 30 days from when Radar raised it, then deletes it. A finding that is still open stays while it is open. See How findings end.

Create a retention policy

  1. Click the + button after the policies.

  2. Type a Name and click Create Policy.

  3. Click its database count and select the databases. Click Save.

A database that you add leaves its old retention policy. For other days on one database, put it in another retention policy.

Stop, rename or delete a policy

  • Running switch: a stopped policy deletes nothing. Scops keeps all the data of its databases until you start it again. In the Community edition, the limit of 15 days still applies.
  • Pencil: rename the policy.
  • Bin: delete the policy. Its databases go to Default Retentions.

Community keeps 15 days

The Default Retentions policy in the Community edition, with all Keep boxes at 15 and disabled

In the Community edition, Scops keeps 15 days of all data, and you cannot change Keep. When you activate a license key, the days of the policy apply again. See Editions and activation.

Updated November 5, 2026