| How to Relate OS Process_id with Concurrent Requests |
| Monday, June 16, 2008 |
How to relate OS Process_id with concurrent request
----------------------------------------------------
or application user
-------------------
This is helpful in two situations:
==================================
1. When the apps user wants to know the OS process_id associated with
a particular request_id
2. When DBA/SYSADMIN wants to identify the request_id, concurrent program
or the apps user associated with a OS process that is consuming large
process resources.
1. If you have request_id and want to find out the OS process_id use
the following query:
SELECT r.request_id, p.os_process_id
FROM FND_CONCURRENT_REQUESTS r, FND_CONCURRENT_PROCESSES p
where r.controlling_manager = p.concurrent_process_id;
2. If you have OS process_id and want to find out the request_id and user
submitting the request use the following query:
SELECT u.user_id, u.user_name
FROM FND_USER u
where u.user_id in (
SELECT l.user_id
FROM FND_LOGINS l, FND_CONCURRENT_PROCESSES p
WHERE p.os_process_id = AND
l.spid = p.os_process_id); |
posted by Senthil Kumaran @ 3:37 AM   |
|
|
|
