 | |
Toad is locking table in oracle
comp.databases.oracle.tools comp.databases.oracle.tools
 |
| | Thread Tools | Search this Thread | Display Modes |
#1
 
| |||
| |||
|
Toad is locking table in oracle -
12-07-2007
, 03:16 PM
#2
| |||
| |||
|
|
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 |
famous for locking tables.
Shakespeare
#3
| |||
| |||
|
|
shakespeare wrote: "zino" <antony6670 (AT) gmail (DOT) com> schreef in bericht news:337a6229-e02d-4c04-a592-c9d273d27666 (AT) a39g2000pre (DOT) 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.... |
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
#4
| |||
| |||
|
|
"Walt" <walt_askier (AT) SHOESyahoo (DOT) com> schreef in bericht news:13lrdhlmnskdpef (AT) corp (DOT) supernews.com... shakespeare wrote: "zino" <antony6670 (AT) gmail (DOT) com> schreef in bericht news:337a6229-e02d-4c04-a592-c9d273d27666 (AT) a39g2000pre (DOT) 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 Somewhere there's an option to use it read-only, |
to indicate there's more than one option to look at)
Take a look at PL/SQL Developer of AllroundAutomations.
Better tool for developers (less obvious DBA stuff
),better support for new Oracle versions, supports unicode
(ever seen russian job descriptions in the famous EMP table,
or chinese column names?!?).
And... it's a hell of a lot cheaper than TOAD! Current
prices: US$6k for an *unlimited* licence - TOAD will give
you about a single user license with no plugins for that!
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
#5
| |||
| |||
|
|
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 |
database telling who can do what withToad on that database.
Shakespeare
#6
| |||
| |||
|
|
Take a look at PL/SQL Developer of AllroundAutomations. |
Shakespeare
#7
| |||
| |||
|
|
I've used TOAD for years, and never had a problem with locking tables. |
or importing schemas .. just cause I looked for DLL statements or grid data
it doesn't happen systematically but it's serious problem
|
« Previous Thread
|
Next Thread »
| Thread Tools | Search this Thread |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.