Oracle BPM 12c SOAINFRA purge tables and query

 

Purge

Purge has become a configurable process by enterprise console. A very nice feature since we cannot query the database :). But this blog is titled “everyday usefull queries”…so you will always want to know that purge has run the previous day.

* Show job details

1 2 3 4

select log_date, status, req_start_date, actual_start_date, run_duration from user_scheduler_job_run_details --where job_name = 'DELETE_INSTANCES_AUTO_JOB1' order by log_date;

* Show the job history and status

1 2 3

select log_date, status from user_scheduler_job_log --where job_name = 'DELETE_INSTANCES_AUTO_JOB1' order by log_date;

* Show a running job

1 2 3

select session_id, running_instance, elapsed_time, cpu_used from user_scheduler_running_jobs --where job_name = 'DELETE_INSTANCES_AUTO_JOB1';

The above queries are documented. If you want more details please check on purge and how it works :
Oracle Documentation – Managing Data Growth

Another usefull link on purge is:

How to find purgable instances link

* Run Purge on Demand for a single flow id

1	exec soa.delete_instances_adhoc ('60910152,');