I upgraded my toad from 12 to 13.3. At 13.3 I noticed that the session browser was not working properly. For example, in the picture I sent, although I started from different sessions, two different sql_id appear under TOAD.EXE. I have trouble seeing which SQLs are in the session I started. However,…

Thanks you John, are there any admin tools in this version? The size of the file is too small. what's missing here?

What specifically do you mean by "Admin tools"? If you click the "Here" link above, it should take you to another page. On that page, scroll down and then click either "Download/Update 32-bit Beta" or "Download/Update 64-bit Beta". The file sizes are around 145Mb. -John

As you said, I installed the toad 14 version. But again there is a problem. version 12 is also grouped under TOAD.EXE, while version 14 is not grouped under TOAD.EXE. As far as I can tell, the best version is 12. why not update it by looking at version 12. [toad_12]

Toad 12's grouping technique does not work on Oracle 19c. I'll take another look at this. Thank you.

Which Oracle server version are you using? For me, it is grouping correctly, even when I use the same SQL ID in more than one session. [image] The query that I am using looks like this with ps as (select 1 as inst_id, sid, serial#, qcsid, qcserial# from v$px_session where qc…

hi, database version is 11.2.0.4 When I ran the query you gave, it got an error. [Error] Execution (117: 10): ORA-00904: "S"."PLSQL_DEBUGGER_CONNECTED": geçersiz belirleyici I did the operations you said later. their output is like this. -- Session: SYS@xxx -- Timestamp: 21:54:07.376 with ps…

Oh, I see you are on a RAC database. That may affect this. As a test, if you uncheck "Use RAC Views", does it work properly?

I see the problem on RAC. It seems that that parent session is not always on the same instance as the child sessions. I was expecting them to always match up. I have logged the bug and it will be fixed soon. [image]

Hi, is it fixed now? If yes, for which version it has been fixed? Does Toad for Oracle 13.4.0 has this fix?

Toad 13.3 session browser does not work properly on RAC

Toad for Oracle & DevOps Toolkit

JohnDorlon July 27, 2020, 9:52pm 2

This is fixed in the current beta, which you can get here.
Thanks for reporting it.

Topic		Replies	Views
Toad for oracle 14.0.75 - Session browser not showing full details Toad for Oracle & DevOps Toolkit	8	2868	November 2, 2020
Session Browser displays specific parallel processes for multiple sessions Toad for Oracle & DevOps Toolkit	6	3870	October 28, 2020
List index out of bounds (0). during session browser, Current Statement Toad for Oracle & DevOps Toolkit	16	1651	July 6, 2020
Toad crashes too often Toad for Oracle & DevOps Toolkit	17	3235	November 18, 2021
Problem mit Session Browser Toad Version 10.6 + Oracle DB 11g2 and client 11g Toad for Oracle & DevOps Toolkit	1	465	November 8, 2011

Toad 13.3 session browser does not work properly on RAC

Related topics