Query to kill database session for a concurrent request
•By Amol Jadhav
Query to kill database session for a concurrent request
Oracle apps backend sql to end database session for a concurrent request
Oracle apps how to terminate concurrent request from backend
Step 1:
SQL Querysql
1SELECT ORACLE_SESSION_ID
2 FROM fnd_concurrent_requests
3 WHERE request_id IN (84780821)Step 2:
SQL Querysql
1SELECT SID, SERIAL#
2 FROM v$session
3 WHERE AUDSID = '175915309' --ORACLE_SESSION_ID from above queryStep 3:
SQL Querysql
1--
2ALTER SYSTEM KILL SESSION '1398,21328' --SID and SERIAL# from above query
3--Related posts:
- Register a test concurrent program from backend in Oracle EBS
- Supervisor Hierarchy and Approval Limits in Oracle EBS R12
- Query to find vacation rules in Oracle R12
- View java class source in oracle database
- Load Java source code in oracle database
- Query to find all APIs of Oracle Apps modules
- OAF customizations queries
- Oracle apps list of concurrent programs in a Request Set
- Query to get Organization Hierarchy in Oracle apps
- Oracle apps query to find incompatible programs blocking a concurrent request
- Form function attached to which responsibility and user
- Query to find the responsibility attached to user in oracle apps