Path: text.usenetserver.com!out04a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!cycny01.gnilink.net!cyclone1.gnilink.net!gnilink.net!nx01.iad01.newshosting.com!newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!feeder.news-service.com!newsgate.cistron.nl!xs4all!transit1.news.xs4all.nl!post.news.xs4all.nl!not-for-mail From: "Shakespeare" Newsgroups: comp.databases.oracle.tools References: <337a6229-e02d-4c04-a592-c9d273d27666@a39g2000pre.googlegroups.com> <475d9d1b$0$230$e4fe514c@news.xs4all.nl> <13lrdhlmnskdpef@corp.supernews.com> Subject: Re: Toad is locking table in oracle Date: Tue, 11 Dec 2007 14:18:29 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-RFC2646: Format=Flowed; Response Lines: 36 Message-ID: <475e8e25$0$85795$e4fe514c@news.xs4all.nl> NNTP-Posting-Host: 82.170.114.99 X-Trace: 1197379109 news.xs4all.nl 85795 vert0098/[::ffff:82.170.114.99]:5385 X-Complaints-To: abuse@xs4all.nl Xref: usenetserver.com comp.databases.oracle.tools:181993 X-Received-Date: Tue, 11 Dec 2007 08:18:30 EST (text.usenetserver.com) "Walt" schreef in bericht news:13lrdhlmnskdpef@corp.supernews.com... > shakespeare wrote: >> "zino" schreef in bericht >> news:337a6229-e02d-4c04-a592-c9d273d27666@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 But browsing a table and clicking on an entry in the result grid will.... even if you don't edit at all. I have seen several customer sites where TOAD was absolutely forbidden for this behaviour. Sure, it's not the tool, but how you use it..... I used Toad for years without any complaints. It's the 'until this user's statement is finished' that worries me most.... Shakespeare