Re: Toad is locking table in oracle
From: Walt <walt_askier_at_SHOESyahoo.com>
Date: Mon, 10 Dec 2007 16:57:09 -0500
Message-ID: <13lrdhlmnskdpef_at_corp.supernews.com>
>> 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
Date: Mon, 10 Dec 2007 16:57:09 -0500
Message-ID: <13lrdhlmnskdpef_at_corp.supernews.com>
[Quoted] shakespeare wrote:
> "zino" <antony6670_at_gmail.com> schreef in bericht > news:337a6229-e02d-4c04-a592-c9d273d27666_at_a39g2000pre.googlegroups.com...
>> 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 Received on Mon Dec 10 2007 - 22:57:09 CET