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: How to know a table is being accessed by other session?

Re: How to know a table is being accessed by other session?

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 18 Jun 2005 09:19:51 -0700
Message-ID: <1119111591.893472.159370@g47g2000cwa.googlegroups.com> 





Jack Lee wrote:


> Becasue I want lock a table,when any other session is not accessing

> this tale.




ALTER TABLE xxxx LOCK EXCLUSIVE; -- will work



Not permitted in my shop or most oracle shops.



Not recommended by people who understand oracle concurrency model.
Received on Sat Jun 18 2005 - 11:19:51 CDT












Original text of this message













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