Translate

Tuesday, 3 April 2012

Find SID from Concurrent Program request ID

SELECT sid
FROM v$session
WHERE paddr LIKE
(SELECT addr
FROM v$process
WHERE spid =
(SELECT oracle_process_id
FROM fnd_concurrent_requests
WHERE request_id = TO_NUMBER()
)
);

No comments:

Post a Comment