# Execution in a tab blocs access to the other tabs

**URL:** <https://forums.toadworld.com/t/execution-in-a-tab-blocs-access-to-the-other-tabs/39128>\
**Category:** SQL Navigator\
**Created:** [February 26, 2017, 11:52pm UTC](https://forums.toadworld.com/t/execution-in-a-tab-blocs-access-to-the-other-tabs/39128 "2017-02-26T23:52:28Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![martin\_goblet](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/martin_goblet/32/267_2.png) [@martin\_goblet](https://forums.toadworld.com/u/martin_goblet)\
**Post date:** [February 26, 2017, 11:52pm UTC](https://forums.toadworld.com/t/execution-in-a-tab-blocs-access-to-the-other-tabs/39128/1 "2017-02-26T23:52:28Z")

</div>

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](https://global.discourse-cdn.com/quest/original/2X/6/67c3a72dec9f8864753e0d2f7f2da854ef6dc456.jpeg)

Regards

Martin

---

<div class="post-metadata">

**Author:** ![vliu](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vliu/32/72_2.png) [@vliu](https://forums.toadworld.com/u/vliu)\
**Post date:** [February 27, 2017, 12:37am UTC](https://forums.toadworld.com/t/execution-in-a-tab-blocs-access-to-the-other-tabs/39128/2 "2017-02-27T00:37:30Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![martin\_goblet](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/martin_goblet/32/267_2.png) [@martin\_goblet](https://forums.toadworld.com/u/martin_goblet)\
**Post date:** [February 27, 2017, 12:45am UTC](https://forums.toadworld.com/t/execution-in-a-tab-blocs-access-to-the-other-tabs/39128/3 "2017-02-27T00:45:19Z")

</div>

Hi Vincent

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

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

 ![tbas 2.jpeg](https://global.discourse-cdn.com/quest/original/2X/f/f21c2dcf45310aecc44ca5946904637a74e79d35.jpeg)

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

---

<div class="post-metadata">

**Author:** ![martin\_goblet](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/martin_goblet/32/267_2.png) [@martin\_goblet](https://forums.toadworld.com/u/martin_goblet)\
**Post date:** [February 27, 2017, 12:56am UTC](https://forums.toadworld.com/t/execution-in-a-tab-blocs-access-to-the-other-tabs/39128/4 "2017-02-27T00:56:01Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![vliu](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vliu/32/72_2.png) [@vliu](https://forums.toadworld.com/u/vliu)\
**Post date:** [February 27, 2017, 1:00am UTC](https://forums.toadworld.com/t/execution-in-a-tab-blocs-access-to-the-other-tabs/39128/5 "2017-02-27T01:00:39Z")

</div>

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