Session Browser, Toad 10.6. Strangeness

Toad for Oracle & DevOps Toolkit
1

Evening all,

I’ve never seen this before, but today I was watching a session in the
session browser, with a 5 second refresh. Everything was fine until a
new session joined the database - the highlight in the session browser
flipped to the new session and I lost what I was watching. :frowning:

Even worse, the new session’s data were displayed until that one logged
out, and I was left at the next “random” session at the bottom of the list.

As I say, I’ve not seen this before and I use the session browser this
way very frequently.

It happened on various tabs in the session browser - waits, current
statement -> information, locks, access the lots.

–
Cheers,
Norm. [TeamT]

2

Hi Norm,

I did some work to improve this in the beta back in March. There was a problem
with the old algorithm when sessions came and went.

-John

3

Evening John,

I did some work to improve this in the beta back in March. There was a
problem with the old algorithm when sessions came and went.
Ok, no worries. I can live with that. As I said, it's not something I've
seen before, but then again, this application is known for it's multiple
logon/logoff cycles. Sigh! Sometimes I despair.

Guess what it uses to get the next ID column? Correct - select max(id)
+1 from table. :frowning:

Robust? It's not.

--
Cheers,
Norm. [TeamT]