1. Administering Oracle Advanced Authentication and Oracle Adaptive Risk Management
  2. Administering Oracle Advanced Authentication
  3. Understanding Partitioned Schemas
  4. Archiving and Purging
  5. Minimum Data Retention Policy for OLTP (Online Transaction Processing) Tables

14.3.4 Minimum Data Retention Policy for OLTP (Online Transaction Processing) Tables

Minimum Data Retention Policies

Based on the OAA system requirement, the minimum data retention policy for various OLTP (online transaction processing) tables are shown below. Users should determine the data retention period based on their business requirements.

Data Retention Policy
User Authentication related data, User Authentication Profile Data Minimum of 6 months or 180 days
Data generated from Monitor data points Minimum of 6 months or 180 days
Custom Activities related Data Data that has not been updated in the last 180 days is purged by default.
Behavior pattern related Pattern Data Retention for hours, days, months, and years is listed below:
  • HOURS based pattern-workflow tables will retain 3 days worth of data.
  • DAYS based pattern-workflow tables will retain 32 days worth of data.
  • MONTHS based pattern-workflow tables will retain 1 years worth of data.
  • YEARS based pattern-workflow tables will retain 5 years worth of data.
Rule Log Data The archive and purge script will archive and purge all rule log data that is 30 days older (This value should be set based on the customer care requirement. If the reporting database is used, then, rule logging data retention should be less than 30 days.