Deployment Guide › iConsole Standard Searches, Reports and Policies › Dashboard Data Aggregation › Configure the Aggregation › Aggregation Jobs on Oracle CMSs

Aggregation Jobs on Oracle CMSs

To configure aggregation jobs for Oracle CMSs, you need to run a database command to set the required parameters to their new values. Using a utility such as Oracle's SQL Plus, run this command:

begin dlp_agg.
rut_dlp_set_aggregation_values (<parameter>[,<parameter>]); 
commit; end;

Where <parameter> defines the new value for an aggregation parameter. Each query can include multiple parameter definitions, separated by commas. If a parameter is not explicitly specified, it retains its current value. The exception is the purge parameter, which is implicitly set if you change the aggregation start date or timeslot length.

The available aggregation parameters and their associated syntax are described in the following section. The example below resets the aggregation start date to 1 July and the timeslot length to 24 hours:

begin dlp_agg.
rut_dlp_set_aggregation_values (granularity=>1440,
start_ts=>to_date('20080701','yyyymmdd'),
purge_data=>1); commit; end;