Mapping Concurrent request Id to Sid and serai#

1  select v.request_id,
2  s.sid,
3  s.serial#,
4  s.event,
5  p.spid
6  from apps.fnd_conc_requests_form_v v,
7  v$process p,
8  v$session s
9  where v.request_id = ‘5029302′
10  and v.oracle_process_id = p.spid(+)
11* and p.addr = s.paddr(+)
SQL> /
REQUEST_ID        SID    SERIAL#
———- ———- ———-
EVENT                                                            SPID
—————————————————————- ————
5029302       1589       5144
db file sequential read                                          7882