Steps to monitor the Concurrent Request

1. Take the Request Id of the Concurrent Program which needs to be monitored.

2. Get the sid for the request id with the help of below query

SELECT ses.sid,ses.sql_hash_value
ses.serial#
FROM v$session ses,
v$process pro
WHERE ses.paddr = pro.addr
AND pro.spid IN (SELECT oracle_process_id
FROM fnd_concurrent_requests
WHERE request_id = &request_id);

v$ for non-rac and gv$ for rac

3. After getting the sid,sql_hash_value please use this value in the below query to get the disk reads,buffergets values.

Select Inst_Id,
       Hash_Value,
       Sql_Id,
       Module,
       Buffer_Gets,
       Disk_Reads,
       Executions,
       Rows_Processed
  From Gv$sql
 Where Hash_Value = value;

4. The buffer_gets and disk_reads values should keep changing for every execution of the above query. If the values are constant for more time then you need to notify the Application People.