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 -> How to drill down on a TX lock

How to drill down on a TX lock

From: Doug C <dcowles_at_i84.net>
Date: Thu, 26 Jul 2001 10:40:01 -0700
Message-ID: <icl0mtk29h4lvmqodhrj2jnrtv04brlkvo@4ax.com> 






I have a feeling this might be somewhat complicated and involve doing block
dumps.  Irregardless.. can anyone provide an example?  Let's say I've got 4 rows
in a table locked exclusively with a TX lock.  What must I do to ascertain which
rows are locked.  Dumping every block in the table is acceptable in this
situation because the table is pretty small.  Any suggestions, examples?



Thanks,


D
Received on Thu Jul 26 2001 - 12:40:01 CDT












Original text of this message













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