shakespeare wrote:
> "zino" <antony6670@[EMAIL PROTECTED]
> schreef in bericht
>
news:337a6229-e02d-4c04-a592-c9d273d27666@[EMAIL PROTECTED]
>> We just got Toad 9.xxx.
>> we noticed that every time an end user is working on a table (sinple
>> select statement) from his end, the table will get locked and stay as,
>> until this user's statement is finished or he close his session. Is
>> that normal with oracle or is there something can be done on Toad
>> side.
>>
>> thanks for help
>
> Put Toad in read only query mode, or better: don't use Toad at all. It's
> famous for locking tables.
I've used TOAD for years, and never had a problem with locking tables.
(Yeah, it'll lock tables if you issue a select for update, or update
without committing, or do DDL, but that's all expected.)
Something weird is going on. Not sure what, but out of the box there's
no locking for a simple select.
//Walt


|