User is running a procedure that takes a while to process, but Toad will not allow the user to switch to other applications or even minimize the Toad window. Even pressing ATL + Tab to switch over to other applications keeps the editor in front of the window.
The procedure and\or query is still processing through Toad's Editor.
RESOLUTION#1:
Run Procedure through the Quest Script Runner (QSR)
1. In Toad go to Editor | Execute SQL via QSR.
2. In the new window execute the procedure there using the syntax:
EXECUTE <procname>
OR
EXECUTE <procname> (<parameter>) - {If using a parameter in your procedure}
3. Then this will free up Toad and other applications for you to continue working.
RESOLUTION#2:
Go to VIEW | OPTIONS | Oracle | Transactions - check on Execute queries in threads (Creates separate session).
