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

From: HansF <News.Hans_at_telus.net>
Date: Sat, 18 Jun 2005 02:27:26 GMT
Message-Id: <pan.2005.06.18.02.30.30.67382@telus.net>

On Fri, 17 Jun 2005 19:00:51 -0700, Jack Lee interested us by writing:

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

Could you expand on the reason for this.

In general that is considered a very bad idea in Oracle and I am truly curious to understand what's special about your app to require this.

<side note>
Hopefully you understand - what works well in one database engine may totally suck in another due to the differences in internal implementation of the engines. (Explained very well, with demos and examples, in the book 'Effective Oracle by Design' by Thomas Kyte) </side note>

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***

Received on Fri Jun 17 2005 - 21:27:26 CDT