Print Thread
Feature request: manual control for locking/unlocking compilation
#50544 02/02/15 04:38 PM
Joined: Aug 2003
Posts: 101
Chesapeake Bay
Member
OP Offline
Member
Joined: Aug 2003
Posts: 101
Chesapeake Bay
while running a program in 1 window (long running ops) ,not able to compile program unit in other.
it is understandably that feature remains from the "days" of PLSQL Dev being connected to one DB instance and one DB instance only, but since IDE can have multiple connections, that feature becomes annoyance.
Of course, another instance of IDE can be instantiated, but was not the intent of multi-connections feature to be able to use 1 instance of IDE being connected to multiple DB's?
So, can you please make such feature configurable.

Re: Feature request: manual control for locking/unlocking compilation
null0000 #50547 02/03/15 01:28 AM
Joined: Feb 2013
Posts: 251
UTC+10
I
Member
Offline
Member
I
Joined: Feb 2013
Posts: 251
UTC+10
It is.
Check Preferences.

Re: Feature request: manual control for locking/unlocking compilation
null0000 #50550 02/03/15 09:57 AM
Joined: Sep 2009
Posts: 197
Krakow, Poland
Member
Offline
Member
Joined: Sep 2009
Posts: 197
Krakow, Poland
As IvanZ wrote, you can unlock the ability to compile code when other window is executing.
It's not locked by default because of historical reasons (having only one connection/session). It's locked by default because the code you have executing may block the compilation or even (in some cases) cause deadlock between those two operations if they are executed on the same DB.

I agree that this lock could be more intelligent and do not block the compilation if the execution is done on different DB but determining if it is a different DB is not trivial (as you can have many TNS names for the very same DB).

Re: Feature request: manual control for locking/unlocking compilation
Hilarion #50557 02/03/15 11:29 AM
Joined: Aug 2011
Posts: 339
T
Member
Offline
Member
T
Joined: Aug 2011
Posts: 339
[quote=Hilarion]I agree that this lock could be more intelligent and do not block the compilation if the execution is done on different DB but determining if it is a different DB is not trivial (as you can have many TNS names for the very same DB). [/quote]

And don't forget distributed transactions.

Re: Feature request: manual control for locking/unlocking compilation
T-Gergely #50560 02/03/15 12:02 PM
Joined: Sep 2009
Posts: 197
Krakow, Poland
Member
Offline
Member
Joined: Sep 2009
Posts: 197
Krakow, Poland
Yes, that's much more important and complex case.
There's also Oracle RAC and probably many other cases where it can bite you.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.085s Queries: 14 (0.028s) Memory: 2.5128 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-04-30 11:03:36 UTC
Valid HTML 5 and Valid CSS