First you need to identify there SID and Serial#. Here is v$session comes handy. Look for the criteria that suits you (machine etc).
Here is an excerpt from 10.2 Database SQL Reference Guide:
Terminating a Session: Example You might want to terminate the session of a user that is holding resources needed by other users. The user receives an error message indicating that the session has been terminated. That user can no longer make calls to the database without beginning a new session. Consider this data from the V$SESSION dynamic performance table, when the users SYS and oe both have open sessions:
SELECT sid, serial#, username
SID SERIAL# USERNAME
---------- ---------- ------------------------------
29 85 SYS
39 23 OE
. . .
The following statement terminates the session of the user scott (actually it should be OE here) using the SID and SERIAL# values from V$SESSION:
ALTER SYSTEM KILL SESSION '39, 23';
Hope this helps! cheers, Neeraj
Could anyone post queries which should we use to terminate concurrent requests from back end
You will need to update the FND_CONCURRENT_REQUESTS table to cancel the request from the backend.
Please refer the following links, as it has detailed explanation:
In addition to the above, for further readings also Let me google that for you
And also could you post the queries which oracle apps dba's mostly use
There are so many queries available on google; Let me google that for you
Hope this helps,