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,');

Oracle MFT 12c verbose log on ftp trasnfert

Product: Oracle Managed File Transfer 12c

Set TRACE:32 for a verbose log, from EM console -> mft server

On following classes/package:

oracle.mft.ENGINE

oracle.mft.SECURITY

oracle.mft.TRANSPORT

oracle.mft.adapter (make sure all sub-levels are set to Inherited)

Go to SOA Infrastructure and set the following loggers to TRACE:32:

oracle.soa -> oracle.soa.adapter:

-> oracle.soa.adapter.file

-> oracle.soa.adapter.ftp

On restart it will return on default setup if you don't specify to make permanent the log level.

HTTP Basic authentication with SOA Suite

this post referes to Biemond post about situations where you need to add some security like HTTP basic authentication to your Composite Services or References.

Oracle BPEL integrated with WCC Services using OPSS

I have to integrate a Web Center Content (WCC) Search service on a SOA BPEL using the Oracle Platform Security Services (OPSS).