Re: Toad is locking table in oracle
From: shakespeare <whatsin_at_xs4all.nl>
Date: Mon, 10 Dec 2007 21:10:02 +0100
Message-ID: <475d9d1b$0$230$e4fe514c_at_news.xs4all.nl>
Date: Mon, 10 Dec 2007 21:10:02 +0100
Message-ID: <475d9d1b$0$230$e4fe514c_at_news.xs4all.nl>
"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.
Shakespeare Received on Mon Dec 10 2007 - 21:10:02 CET