In this post we will learn how to find SID from Concurrent Request to identify the slowness issue.
What is SID in Oracle Database session:-
SID is session identifier. Used to identify uniquely for session, after the session is over, this sid can be used for other session. Sid is analogy of pid in OS.
Use below Query to find SID from Concurrent Request:-
SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID FROM apps.fnd_concurrent_requests a,apps.fnd_concurrent_processes b,v$process c,v$session d WHERE a.controlling_manager = b.concurrent_process_id AND c.pid = b.oracle_process_id AND b.session_id=d.audsid AND a.request_id = &Request_Id AND a.phase_code = 'R';
How to find PID by SID in oracle
In this article, we will know how to find PID by SID in oracle….READ MORE
- Increase Open Files Limit to resolve Too Many Open files error and native OutOfMemory due to failed to create thread
- Steps to create physical standby database using rman backup