Print Thread
long-time queries stop button to enable
#63895 05/03/22 07:18 PM
Joined: Dec 2012
Posts: 46
G
Member
OP Offline
Member
G
Joined: Dec 2012
Posts: 46
long time query stop button to enable, sometimes it doesn't even enable and I have to wait for the grid buffer to fill for the query to stop executing.

Version 15 trial

Re: long-time queries stop button to enable
gremonesi #63896 05/04/22 08:30 AM
Joined: Aug 1999
Posts: 22,176
Member
Offline
Member
Joined: Aug 1999
Posts: 22,176
Can you go to Preferences > Oracle > Connection and let me know your "Session Mode" setting?


Marco Kalter
Allround Automations
Re: long-time queries stop button to enable
Marco Kalter #63899 05/04/22 03:05 PM
Joined: Dec 2012
Posts: 46
G
Member
OP Offline
Member
G
Joined: Dec 2012
Posts: 46
Multsession

Attached Files
plsql.JPG (42.02 KB, 116 downloads)
Re: long-time queries stop button to enable
gremonesi #63900 05/05/22 09:00 AM
Joined: Aug 1999
Posts: 22,176
Member
Offline
Member
Joined: Aug 1999
Posts: 22,176
Thanks. The "Break execution" button is enabled immediately when I execute a query in the SQL Window with these settings. Note however that the first time you execute something in the SQL Window, it will first need to connect to the database. If logon performance is slow, this can cause a delay during which the break button is indeed not yet enabled.

Also note that the break button will not immediately have effect for some database operations, for example when waiting for a lock or when performing an internal sort.


Marco Kalter
Allround Automations
Re: long-time queries stop button to enable
gremonesi #63901 05/05/22 12:00 PM
Joined: Dec 2012
Posts: 46
G
Member
OP Offline
Member
G
Joined: Dec 2012
Posts: 46
Marco, when you executed a sql and it has one or several tables that will return 500 thousand rows, the execution break button does not enable, it stays 1, 2, 3 minutes without enabling it, it is only enabled when it returns all the sql data or when fill the grid buffer.

obs.: I'm noticing if I use the keyboard command shift + ESC, the execution break occurs even with the button disabled

Re: long-time queries stop button to enable
gremonesi #63917 05/10/22 07:45 PM
Joined: Oct 2009
Posts: 23
T
Member
Offline
Member
T
Joined: Oct 2009
Posts: 23
I am also experiencing this issue where the stop button will not light up for a long period of time. This is new behavior that did not exist in 14.

Re: long-time queries stop button to enable
gremonesi #63921 05/11/22 02:04 PM
Joined: Oct 2009
Posts: 23
T
Member
Offline
Member
T
Joined: Oct 2009
Posts: 23
I'm currently watching my query select from a table with a million rows in it and I can't stop it! The little hand icon is red but it will not respond to clicks. I have my buffer set high because sometimes it is useful and I used to be able to stop a query from returning rows but I'm on row 30,000 now and it keeps selecting and not letting me stop it!
Uhg!

Re: long-time queries stop button to enable
gremonesi #63925 05/12/22 08:01 PM
Joined: Aug 2008
Posts: 29
Moravia
M
Member
Offline
Member
M
Joined: Aug 2008
Posts: 29
Moravia
I also have this problem.

Re: long-time queries stop button to enable
gremonesi #63955 05/27/22 12:22 PM
Joined: Dec 2012
Posts: 46
G
Member
OP Offline
Member
G
Joined: Dec 2012
Posts: 46
I have 2 clients install in my computer

Re: long-time queries stop button to enable
gremonesi #64010 06/17/22 02:53 PM
Joined: Oct 2002
Posts: 59
Quebec,Canada
D
Member
Offline
Member
D
Joined: Oct 2002
Posts: 59
Quebec,Canada
Same here, when data is fetching on large tables, the stop is enabled, but I can't use it, unable to click anywhere in the application. I am using this very often, please have it fixed :-)


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.027s Queries: 16 (0.006s) Memory: 2.5344 MB (Peak: 3.0377 MB) Data Comp: Off Server Time: 2024-03-29 13:19:06 UTC
Valid HTML 5 and Valid CSS