Hi, I am using Toad for Oracle 2026 R1 DBA Suite. Session browser window is painful while opening it or refreshing Sessions tab when it is opened already. When I spool SQL while refreshing the Sessions tab, I saw it trying to get all objects from dba_objects with object_id in clause for thousands o…

That is something that I added recently. When the main sessions grid is loading, Toad gets the Object ID's from the ROW_WAIT_OBJ# field. These represent objects with Locks. Immediately after that, we put them in the SQL that you are seeing to determine the names of those objects. I didn't expect…

Hi John, Yes, they are duplicated. There are 15K object ids but 621 distinct object id there are. Until it is fixed, I think I will use previous version. Thank you.

[image] samet.akalan: select object_id, owner, object_name, object_type from sys.dba_objects where object_id in (1073072,1089455,1053303, Next beta, that SQL won't run at all unless you make the "Lock Info" column visible, or hover your mouse over a lock or circle/slash icon. And even the…

That sounds good. By the way, is it possible to set a custom filter for Session Browser at opening? Until it is fixed, may be this kind of custom filter or “STATUS - ACTIVE“ filter can be set while opening Session Browser. Is there any option to make this happen?

Yes, look at my screen shot - whichever filter you choose there will be used by default until you choose something different.

Hi John, I meant choosing custom filter but I have just tested newly release beta, same problem seems to continue.

I just tested this in the beta and confirmed that we aren't running that SQL at all anymore, unless one of these happens a) you hover your mouse over a lock or circle/slash icon b) The 'lock details' column is visible in the main grid, and it contains data But...even if we run the SQL now, it wil…

Incase anyone else is following this, Samet had over 20,000 sessions in his database. The query to dba_objects was one problem, and another was that the Session Browser took several minutes to load or refresh if one of the columns in the Session Browser was sorted. You can CTRL+Click on a column …

Toad for Oracle 2026 R1 Session Browser windows opening or refreshing Sessions tab takes too long

Toad for Oracle & DevOps Toolkit

JohnDorlon March 31, 2026, 12:54pm 8

You're welcome. Are you referring to the beta released yesterday (which you can get here) or choosing a filter?

Topic		Replies	Views
Session Browser, Toad 10.6. Strangeness Toad for Oracle & DevOps Toolkit	2	838	June 16, 2011
Session Browser - Auto Refresh issue Toad for Oracle & DevOps Toolkit	3	373	March 14, 2024
Problem with Session Browser - always expands the tree on refresh. Toad for Oracle & DevOps Toolkit	2	2079	October 24, 2016
Toad 13.3 session browser does not work properly on RAC Toad for Oracle & DevOps Toolkit	11	4577	August 24, 2020
Toad 12.8 Question - Sessions Browser Toad for Oracle & DevOps Toolkit	7	3070	February 12, 2016

Toad for Oracle 2026 R1 Session Browser windows opening or refreshing Sessions tab takes too long

Related topics