Examples

  • To delete the audit or statistics entries of process instances for template IDs 1, 3, 5 and 7 (= ec_proc_template.id), have completed, cancelled or failed before the specified date, and that do not have any active, detached sub-process instances: 
    exec ec_delete_audit_stats_data('1, 3, 5, 7', '08-OCT-10 13:35:37’);
  • To delete audit entries of process instances for all templates that completed, cancelled or failed before the specified date, including data for any detached sub-process instances that are still active: 
    exec ec_delete_audit_stats_data(end_time => '08-OCT-10 13:35:37’, delete_active_subprocs = 'TRUE');
  • To delete all audit entries of process instances for template ids 1, 3, 5 and 7 (= ec_proc_template.id): 
    exec ec_delete_audit_stats_data('1, 3, 5, 7');
  • To delete audit entries for all completed, cancelled and failed process instances: 
    exec ec_delete_audit_stats_data;
  • To delete audit entries of process instances for all templates completed, cancelled or failed before the specified date, with debug switched on 
    exec ec_delete_audit_stats_data(end_time => '08-OCT-10 13:35:37’, dbg = 'TRUE');
  • To delete audit entries for all completed, cancelled and failed process instances with a different commit batch size (for example, 150) 
    exec ec_delete_audit_stats_data(batch_size => 150);
  • To delete audit entries for all completed, cancelled and failed process instances with a different cursor refresh size (2000): 
    exec ec_delete_audit_stats_data(cursor_refresh => 2000);