Pages
(Move to ...)
Home
▼
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
‹
›
Home
View web version
No comments:
Post a Comment