Tuesday, July 31, 2018

R12 Finding SID of a Concurrent Request



Finding SID of a Concurrent Request



select b.sid, oracle_session_id, oracle_process_id, os_process_id
from fnd_concurrent_requests a ,
v$session b
 where a.request_id=&request_id and
        a.ORACLE_SESSION_ID = b.AUDSID
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

  • Reclaim Oracle Database free space
      Reclaim Oracle Database free space set verify off  column file_name format a50 word_wrapped  column smallest format 999,990 heading "...
  • List of pending Jobs waiting for managers
    List of pending Jobs waiting for managers set lines 130 col USER_CONCURRENT_QUEUE_NAME format a39 SELECT b.USER_CONCURRENT_QUEUE_N...
  • List of Running Requests
    List of Running Requests set lines 130 set pages 200 col os form A7 head AppProc col spid form a6 head SPID col program fo...