Monitoring OWB mappings / jobs

Hi all,

Its been a long time since i entered into this arena of OWB and oracle. Now i am back again with some quiver full of informations to share. I will share it one by one. Previously i heard about the OWB Monitoring thru Repository Audit Browser - for which we have to start the browser listner.

I have come across the following link. which is used to check the status of the running mappings.

http://kleinoracledenkraam.wordpress.com/2007/05/24/owb-monitoring/
SELECT
e.execution_name,
e.return_result,
e.creation_date,
e.last_update_date,
e.elapse,
TO_CHAR (TRUNC (SYSDATE, ‘DD’) + e.elapse / (24 * 3600), ‘HH24:MI:SS’) AS elapse_format,
wb_rt_constants.to_string (e.audit_status) AS audit_status_symbol, e.audit_status,
DECODE (x.err, NULL, 0, x.err) AS error#,
DECODE (x.sel, NULL, 0, x.sel) AS selected,
DECODE (x.ins, NULL, 0, x.ins) AS inserted,
DECODE (x.upd, NULL, 0, x.upd) AS updated,
DECODE (x.del, NULL, 0, x.del) AS deleted,
DECODE (x.dis, NULL, 0, x.dis) AS discarded,
DECODE (x.mer, NULL, 0, x.mer) AS merged,
DECODE (x.cor, NULL, 0, x.cor) AS corrected,
wb_rt_constants.to_string (m.severity) AS severity_symbol,
m.severity,
l.plain_text,
p.parameter_name,
p.value,
m.creation_date,
e.task_object_name,
e.task_object_store_name,
e.task_name,
e.audit_status,
e.top_level_audit_execution_id,
e.audit_execution_id,
e.parent_audit_execution_id
FROM
wb_rtv_audit_executions e
LEFT JOIN wb_rtv_audit_messages m
ON e.audit_execution_id = m.audit_execution_id
LEFT JOIN wb_rtv_audit_message_lines l
ON l.audit_message_id = m.audit_message_id
LEFT JOIN
(SELECT e.audit_execution_id, SUM (a.rta_errors) AS err,
SUM (a.rta_select) AS sel, SUM (a.rta_insert) AS ins,
SUM (a.rta_update) AS upd, SUM (a.rta_delete) AS del,
SUM (a.rta_discarded) AS dis, SUM (a.rta_merge) AS mer,
SUM (a.rta_corrections) AS cor
FROM wb_rt_audit_executions e
LEFT JOIN wb_rt_audit a
ON e.audit_execution_id = a.rte_id(+)
GROUP BY e.audit_execution_id) x
ON e.audit_execution_id = x.audit_execution_id
ORDER BY last_update_date DESC;


Thanks,
Soma