App engine like SQL trace for SQR
RahulAgrawal 05 Dec 2019 12:13
Below query may help to get the sql executed by SQR, it works best only when single process running on the process scheduler
select
v.SQL_FULLTEXT,
bc.position,
bc.value_string
from v$sql v , v$sql_bind_capture bc
,PSPRCSRQST p
where v.sql_id = bc.sql_id(+)
and v.child_number = bc.child_number(+)
and to_date(last_LOAD_TIME,'YYYY-MM-DD hh24:mi:ss') BETWEEN p.BEGINDTTM AND p.ENDDTTM
AND module LIKE '%sqrw%'
AND p.PRCSINSTANCE=16307237
order by last_LOAD_TIME ASC ,v.sql_id, bc.position;