Find the sql triggered by peoplesoft process

Summary:

Find the sql triggered by peoplesoft process associated with Process instance, useful in debugging and trouble shooting,

Find the sql triggered by peoplesoft process

RahulAgrawal 30 Jan 2023 03:10

SELECT q.prcsinstance, h.module, h.action, sample_time,sql.sql_text
FROM v$active_Session_history h ,dba_hist_sqltext sql
, psprcsrqst q
WHERE
h.sample_time BETWEEN q.begindttm AND NVL(q.enddttm,SYSDATE)
and
q.prcsinstance = 20346066
and h.sql_id = sql.sql_id
and action=prcsname
and oprid=client_id
and action=prcsname
order by h.sample_time,sample_id
;