Below query can be used to purge the data manually from CCC database:
begin
DATAMART_LIB.ROUTINE_PURGE;
end;
/
Note : It will purge the data on the bases of the global parameters setting.
Once execution is completed, you can use below query to track the number of rows deleted.
SELECT * FROM purge_log_config ORDER BY insert_date DESC;
Below are the table from which data is being deleted using above package.
1. Prestaging Tables: (Pugred based on "NUMBER_DAYS_PRESTAGE_DATA_RETAINED" parameter)
PRE_STAGING_ENTITY_CONFIG,PRE_STAGING_ENTITY_METRICS
2. Staging Tables: (Purged based on "TRUNCATE_STAGING_TABLES" parameter)
APPLICATION_METRICS_STAGING,CPU_METRICS_STAGING,GENERIC_DEVICE_METRICS_STAGING,PROCESS_METRICS_STAGING,SERVER_METRICS_STAGING,SERVER_STAGING,
SUBSYSTEM_METRICS_STAGING,WORKLOAD_LOG_STAGING,WORK_TRANS_METRICS_STAGING,SERVER_VIRTUAL_STAGING,DIVERSE_DATA_STAGING,DIVERSE_METRIC_STAGING,
SAP_CONFIG_STAGING,SAP_DAILY_MEMORY_STAGING,SAP_DAILY_STAGING,SAP_DAILY_SUMMARY_STAGING,SAP_HOURLY_TASK_STAGING,SAP_HOURLY_TIME_STAGING,
SAP_RFC_METRICS_STAGING,CLUSTER_METRICS_STAGING,RESOURCE_POOL_METRICS_STAGING,RESOURCE_POOL_STAGING,CLUSTER_STAGING,GROUP_CONFIG_STAGING,ENTITY_METRICS_STAGING
3. Migration Tables:(Purged based on " NUMBER_DAYS_DATA_RETAINED" parameter )
APPLICATION_FACT,CLUSTER_FACT,CPU_FACT,DISK_FACT,DIVERSE_DATA_FACT,DIVERSE_METRIC_FACT,ENTITY_FACT,GENERIC_DEVICE_FACT,NETWORK_FACT,PROCESS_FACT,RESOURCE_POOL_FACT,SAP_DAILY_FACT,SAP_DAILY_MEMORY_FACT,SAP_DAILY_SUMMARY_FACT,SAP_HOURLY_TASKTYPE_FACT,SAP_HOURLY_TIME_FACT,SAP_RFC_FACT,SERVER_FACT,SERVER_TPP_FACT,SUBSYSTEM_FACT,WORKLOAD_LOG_FACT,WORKLOAD_TRANSACTION_FACT
4. Rollup Tables:(Purged based on "NUMBER_DAYS_HOURLY_DATA_RETAINED" parameter ) - ENTITY_HOUR_FACT
(Purged based on "NUMBER_DAYS_DAILY_DATA_RETAINED" parameter ) - ENTITY_DAY_FACT
5. Log Tables: ( Purged based on "NUMBER_DAYS_LOGS_RETAINED" parameter )
JOB_ACTIVITY_ERROR,JOB_ACTIVITY_MIGRATE,JOB_ACTIVITY_RESULTS,LOGGING_INFO_CONFIG,REFRESH_LOG_CONFIG,TRANSACTIONS_CONFIG,PURGE_LOG_CONFIG,PROCESS_LOG_CONFIG
Written By :
Pradeep Rai