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 see locks

How to see locks

From: <dasingh_at_my-dejanews.com>
Date: Fri, 23 Oct 1998 17:58:46 GMT
Message-ID: <70qg4m$qn4$1@nnrp1.dejanews.com> 





This might be a silly question, but I would appreciate any responses.



Is it possible to check which and if any tables are locked at the begining of
a stored procedure?



I cannot find a simple sql command to do this. There doesn't seem to be a
user_locks or all_locks table either.



-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    
Received on Fri Oct 23 1998 - 12:58:46 CDT












Original text of this message













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