Unable to break long queries

[X3mE]

Hello,

Since I switched to PLSQL Developer 9, I cannot seem to find a way to terminate long queries.

While I was using version 8, I could hit the break button, but now the entire program process seems to freeze (I get the "Not responding" in the title bar until the query completes) and the break button is not available, so I just have to either wait or kill the process in the task manager.

I am using PLSQL Developer in single connection mode, if it makes any difference.

 

[Marco Kalter]

Perhaps you have set the Session Mode preference to "Single Session" (Tools > Preferences > Oracle / Connection)?

 

[X3mE]

Yes, that was the problem. Thank you.

 

[suess]

It is precisely this reason that I'm rolling back. It is dangerous to run a multi connection environment in this tool. I want to run single session and still break long running queries. So back to version 8.x for me.

 

[Marco Kalter]

Note that this is not related to multiple connections. In Dual Session and Multi Session mode, all sessions will be for the same connection. These options exist in 8.0 as well.