Blocking sessions related to client process
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 29 Sep 2010 08:06:16 -0400
Any help would be appreciated.
I respect and appreciate every ones time. If this is considered to
basic a question, then perhaps pointing me to the right place would be
helpful because I can't find the right docs or get to the bottom of
this. It should be more of a clarification as I have been doing this a
long time, so I figure I'm missing something.
The person asking me was using EM, and saw 4 blocking locks, (in the
blocking sessions section), and in the client section he sees OS process
1234 but cannot grep for this process on the client machine. He wants
to go from the blocking sessions in the database (jaxlawdw), and link to
the corresponding process on the client machine.
The person says that it is always client process 1234 as indicated in
enterprise manager 'blocking sessions' , 'session details', 'Client',
'OS Process ID'. The person believes it is a 'fake' or phantom
process.
How do I help, as I may not be giving the correct explanation, else we
should see the process on the client machine?
Example of first row when combining v$session and v$process, shows s.sid
486, p.pid 47, p.spid 8105, and s.process 1234.
Note when querying these two tables for s.process 1234 it returned 58
rows, (but this was done then next day and not live when the blocking
sessions where happening).
Session Process p.pid p.spid Session
SID Serial# Serial# Ora ProcID OS ProcID Process Session
Username OS Username STATUS MACHINE Process Program
------ ------- ------- ---------- ------------ ------------
-------------------- ------------ -------- ---------
----------------------
486 36738 136 47 8105 1234 GENTRAN
b2badmin INACTIVE jaxb2bprd oracleGISPROD@jaxlawdw
Joel Patterson
Database Administrator
904 727-2546
Other related posts:
