Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle session hangs

Re: Oracle session hangs

From: srivenu <srivenu_at_hotmail.com>
Date: 13 Jan 2004 23:18:26 -0800
Message-ID: <1a68177.0401132318.5e256b89@posting.google.com> 





    
  
  1.   Even though you may not have an entry in V$TRANSACTION, you can
look at V$LOCK to see if the session has taken a DML ENQUEUE lock on
the table.
  
  2.   It also helps in looking at the P1 and P2 values for the DB FILE
SEQUENTIAL READ waits for the hanging session to find out what object
it is trying to access.
regards
Srivenu



Received on Wed Jan 14 2004 - 01:18:26 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US