Toad World® Forums

Customize SessionBrowser column visibility

#1

Hi all,

I use toad to monitor both rac and non-rac databases. I customized my session browser to show the column INST_ID.

This works ok when working with a rac database but leads to the error ORA-00904: “INST_ID”: invalid identifier when changing to a non rac db and then subsequently to toad being closed.

Is there a way to change this behaviour? Can I write sort of a trigger in toad which recognizes db type and then changes column visibility?

Any help appreciated.

#2

For me, the Session Browser doesn’t have any problems switching between RAC and non-RAC with the INST_ID column showing. Maybe I have things set up a little different than you though - can you post a screen shot?

#3

I’ll upload word file INST_ID.docx.
INST_ID.docx (108 KB)

#4

Oh, I can reproduce it now. It only happens when you have sorted by the Inst_ID column. Click another column header before you change sessions and you won’t have an error. I’ll fix this for the next beta.

#5

Thank’s.