Execution in a tab blocs access to the other tabs

SQL Navigator
1

Hi

I often execute scripts, and during the execution time I work an other one. With the last versions it's nearly impossible. SQL Nav only opens the other tabs when the execution is finished.

Example : I ran the forth tab and wanted to work on the first one : that's what I get. The first tab will open when the execution of the fourth tab is finished (in this case in 2 hours !)

tabs.jpeg
tabs.jpeg1031×512 108 KB

Regards

Martin

2

Hi Martin, does this happen to you with any type of long running script? I tried running dbms_lock.sleep(20); in the one of the tabs, I could switch to any other tabs and create new tab without waiting.

Thanks,

Vincent

3

Hi Vincent

They are "consuming" ones, but normally this doesn't affect SQL nav, only on our database :wink:

When you try to click again in the window, you get a "blank" screen like this :

tbas 2.jpeg
tbas 2.jpeg1113×420 74.9 KB

I think it's related to the other problem where I can't stop a treatment. It's just as if I lose the contact as soon as a big statement/procedure is launched.

PS : I use the 32 bit version.

Regards

Martin

4

Hi Vincent

I just opened a new session :

Tried the dbms_lock.sleep : no problem

Tried a similar (big) statement : no problem !

It’ll be very difficult to find this one !!!

Regards

Martin

5

Thanks Martin for the confirmation. We will keep eyes on this.