Slow response in the Session Browser using Toad for Oracle version 12.7 (RAC)

Toad for Oracle & DevOps Toolkit
1

I am getting an extremely slow response in the Session Browser using Toad for Oracle version 12.7.

Connected to an oracle version 12c RAC instance. i have the ‘Use RAC views’ box checked. it takes a minute or more just to open the window. Refreshing takes just as long.

When i select a particular session, another serious delay showing the information in the right pane (ie. Current Statement).

i understand this is a known issue in this version, and the workaround posted is to uncheck the ‘Use RAC Views’ button, logging in to the proper instance, if necessary.
Unfortunately, i dont see how to connect to a particular instance in the login window.

Any help would be greatly appreciated.

2

You’ll either need to create a new tnsnames entry that connects to the desired instance, or you can use the “Direct” tab on the login window (click “more” to be able to specify Instance name).

3

Thanks, John. That helps. Any word on when the fix will be put in place?

4

As I understand it, the slowness is not Toad, but in the queries against the GV$ views. They aren’t always slow but I have heard that they can be.

You can test that by turning on spool SQL to capture the queries from Session Browser and trying them in the Editor.