Toad World® Forums

Execution in a tab blocs access to the other tabs

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 !)

Regards

Martin

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

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 :

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

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

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