How to get sessions and process details for Concurrent Request having hold in oracle apps

Oracle Apps DBA SQL Query To get On Hold Concurrent Request in Oracle Apps R12

Hi All, Please find below the query to identify the HOLD Requests by mapping with the below given tables to get the session and process specific details for the Running Concurrent Requests having Hold. APPS.FND_CONCURRENT_REQUESTS GV$PROCESS GV$SESSION GV$LOCKED_OBJECT GV$LOCK DBA_OBJECTS QUERY TO GET THE HOLDS ON THE CONCURRENT REQUESTS: SELECT FCR.REQUEST_ID, FCR.HOLD_FLAG, GV_SESSION.SERVICE_NAME, GV_SESSION.SQL_TRACE, GV_PROCESS.PROGRAM, […]

Scroll to top
Copy Protected by Chetan's WP-Copyprotect.