Analyse Conc Request - ANALYZEREQ.SQL & BDE_REQUEST.sql

ANALYZEREQ.SQL - gives a detailed info of the request

sqlplus apps/pwd @analyzereq request_id

Get analyzereq.sql  from Note ID:134035.1

BDE_REQUEST.sql - To get the process and session info

sqlplus apps/pwd @START bde_request.sql request_id

Get bde_request.sql from Note ID : 187504.1

UR's Key Run ;-)