Query to get current executing statement in Oracle concurrent program

Use below query to get the current executing statement in Oracle Apps concurrent programs.

SELECT va.sql_text
,va.module
FROM APPS.fnd_concurrent_requests fcr
,V$SESSION vs
,V$SQLAREA va
WHERE fcr.oracle_session_id = vs.audsid
AND vs.sql_hash_value = va.hash_value
AND fcr.request_id = <request_id>;

Table Information

  • fnd_concurrent_requests:- This table holds the history of all submitted program in Oracle Apps like request id, request start, request completion time, parameter, etc.
  • V$SESSION :- This is V$ views in Oracle which holds session information.
  • V$SQLAREA:- This V$ view in Oracle hold SQL informationĀ in the database.

Advertisement

Related Post

Leave a Reply

Your email address will not be published. Required fields are marked *