1 person found this helpful
Can you provide a demonstrating scenario?
Click over to main connection:
select 1 from dual;
Runs with no problems.
This was in v18.1
Thank you for a quick answer, it actually helped me to realize that there was an extra condition for this problem I just missed. The primary connection was dead because the computer just came back from sleep or moved between WiFi and ethernet,
So the way to reproduce is like this:
- Open a connection.
- Sabotage network connection somehow, without resetting it in SQL developer
- Open a Unshared Worksheet
- Execute some long running PL/SQL block
- In primary connection do a simple query, it will tell you it needs to reset the connection. ( I don't remember it informing me before but I might have forgotten about it)
Now the primary connection waits for the unshared connection to finish.
Now when I know the precondition to this problem I should be able to avoid it in the future, so you might not want to spend to much time on it.