Toad World® Forums

Schema Browser -> Scheduler Jobs -> Filtering single job with single press of F5 does two refreshes

Hi

Toad 13.3.0.181 (reproducible also with lower versions)

I will demonstrate it with this picture. Basically in "Schema Browser" tab, "Scheduler Jobs". Filter just single job or have only single job for that schema, and by doing refresh (F5), it actually does 2 refreshes. Most noticeable in "Run Log" tab, which itself loads slower, and by adding another refresh, makes it way more slower.

Raul

You can verify pretty quickly what Toad is doing when you hit F5 by turning on the SQL Spool feature just before... e.g. choose Database-> Spool SQL -> Spool SQL to Screen. Let us know if any duplicate code is run more than once.

For me, I'm not seeing this, and I'm wondering why you need to press F5 at all, since the Right-hand side tabs refresh when you select the object on the left... unless you're running a change script against the object in another thread or application, of course.

Hi Raul,

I can't reproduce this either, sorry. I have left hand side filtered down to just one job. I turn on spool SQL, then hit F5. I only see queries appearing one time. No duplicate refreshes. If you have any more info, let us know.

-John

Hi

I spooled sql to screen, this is what happens. This all sql's happen with single refresh (single press of F5 in an "Info" tab)

Left side is the first (refresh that happens) and right side is the second. Only thin that is changed is milliseconds there.

Raul

I tried info tab here, same result. Only one refresh.

Can you confirm that the double-refresh only happens when one object is showing on the left?

Actually the same thing happens if I have only wildcard "*" set for filter and I have multiple jobs there. It just isn't so obvious, so it is harder to notice this.

But when spooled to screen, it is indeed seen that double refresh happens.

----------------------------------
-- Timestamp: 17:45:04.083
SELECT u.NAME
FROM sys.USER$ u
WHERE u.TYPE# = 1
order by 1;

----------------------------------
-- Timestamp: 17:45:04.177
Select P.JOB_NAME, P.JOB_TYPE, O.OBJECT_ID, P.JOB_CLASS, P.ENABLED, P.COMMENTS, O.LAST_DDL_TIME, O.CREATED, P.STATE, CAST(P.NEXT_RUN_DATE AS DATE) next_run_date
      ,:own owner
      ,schedule_type
FROM   SYS.USER_SCHEDULER_JOBS P, sys.USER_OBJECTS O
WHERE  O.OBJECT_NAME = P.JOB_NAME
AND    O.OBJECT_TYPE = 'JOB';
:own(VARCHAR[7],IN)='XXXXXXX'

----------------------------------
-- Timestamp: 17:45:04.302
SELECT u.NAME
FROM sys.USER$ u
WHERE u.TYPE# = 1
order by 1;

----------------------------------
-- Timestamp: 17:45:04.396
Select P.JOB_NAME, P.JOB_TYPE, O.OBJECT_ID, P.JOB_CLASS, P.ENABLED, P.COMMENTS, O.LAST_DDL_TIME, O.CREATED, P.STATE, CAST(P.NEXT_RUN_DATE AS DATE) next_run_date
      ,:own owner
      ,schedule_type
FROM   SYS.USER_SCHEDULER_JOBS P, sys.USER_OBJECTS O
WHERE  O.OBJECT_NAME = P.JOB_NAME
AND    O.OBJECT_TYPE = 'JOB';
:own(VARCHAR[7],IN)='XXXXXXX'

My About page is like this, so DBA Edition. I don't know perhaps it is meaningless, just thought to point it out, since you weren't able to reproduce his.

image

Raul

Something out of the ordinary is causing that keystroke to happen twice.

Do you have another keyboard that you can try?
Have you changed any shortcut settings in Toad?
Does F5 double-process anywhere else? (try opening a describe window and closing schema browser). Then F5 in describe window and check spool SQL.

I also am using DBA edition, but you're right, that's not relevant.

Keyboard not an issue. Since when I press F5 in chrome browser for example, I only get single refresh there, with the same keyboard.

Shortcut settings, I do not recall of.
Isn't there the dedicated button for F5 somewhere inside the menus..?

E: What is describe window..?

Raul

To open a describe window:

Go to schema browser. Select an object on the left. Hit F4. You can also do this on object names in the Editor or just about anywhere you see an object name in Toad.

Isn't there the dedicated button for F5 somewhere inside the menus..?

The only one I see is in the Editor for "Run as script". But that shouldn't interfere with this.

Oh yeah, that F4, I am familiar with it. I only knew keyboard shortcut F4. Thought I need to find the windows somewhere in the menus.

But tried it, before closed schema browser altogether.
Same issue there.

Raul

Just pointing out. Whenever I install a new version of toad, these are the settings that I change from default.

  1. Never split files when opening
    View -> Toad Options -> Editor -> Open/Save -> File splitting -> "Never split files"

  2. Date format
    View -> Toad Options -> Data Grids -> Data -> Display -> dd.mm.yyyy hh:mm:ss

  3. Show editor and schema browser only for specific connection
    From the background of Editori/Schema browser I right click and: Show Buttons for Current Connection

  4. My toad does not get access to internet, this is placed in company intranet. So I did copy this single file to toad user files location, so that when I try to log in with wrong username/password, I get the error instantly, otherwise, I had to wait a minute before timeout occurrs and then I got an error.
    This is the file: http://community-downloads.quest.com/toadsoft/ORACLE/VERSION/online_resources.xml

  5. Options -> Toolbars/Menus -> Toolbars -> Connection Bar:Connection Info: User@Database

  6. Uncheck "Default to "Compile with Debug" from toad options under "Execute/Compile"

Raul

It sounds like something is causing your F5 keystrokes to be doubled.

You can try resetting Toad user files as a test but I don't know if it will help. You can always set them back if you want.

  • Open Copy User Settings from the Utilities menu
  • Choose the option to Reset to a clean set
  • Click OK
  • Choose Yes and then OK on the next two dialogs
  • This will restore Toad to a clean state as if it were freshly installed. Your existing user files will be backed up to %APPDATA%\Quest Software\Toad for Oracle\13.3_bak.
  • If you later want to revert to your old settings, just rename the "13.3" folders (with Toad not running)

Ok, yeah I can try that.

By the way, it happens basically from every Schema Browser page.
One thing to note, in Editor, and I write an sql statement, for example "select 1 from dual" and I hit F5. This does not get executed twice.

Raul

I just tried it, reset it to clean state, toad restarted and then I tried it, and still the double refresh happens.
By the way I am connecting to database through direct connection: host:port/service_name

E: Same with tnsname connection.

Raul

It doesn't happen for me in Schema Browser or Describe Windows, so I don't think there is a bug with doubled F5 in both.

I could add some code in Schema Browser to be sure to F5 block processing while a refresh is already happening, but this shouldn't be necessary. I think the "Processing Script" dialog in the Editor may be preventing it. I tried running a script hitting F5 multiple times and it only processed once.

Do you have 2 schema browsers open? I can reproduce it if I have 2 schema browsers open. The same one is refreshing twice. I'll investigate.

Oh, that was a nice find.. :+1:. Yeah sometimes I have about 10 opened up there.

But you know what. At the moment I did not have 2 Schema Browsers open.

I had Editor and Schema Browser open. --> This can be reproduced like this also.

So it does not have to be just 2 Schema Browsers.

For me, when I open up a new connection, there is always going to be opened a new Editor window by default. So I forgot to mention that. I just opened up a Schema Browser, then it is reproduced.

E: When I close Editor and leave only Schema Browser opened up, then it is just single refresh.

Raul

Hm. For me, an Editor and Schema Browser won't do it. It has to be 2 Schema Browsers. But I think this is enough for me to go on.

Just make sure, that Editor was opened up first and then open Schema Browser. Then it will reproduce.

If you open Schema Browser first and then Editor, then it will not reproduce.
(then you just close Schema Browser and open a new Schema Browser, then it will reproduce)

Raul