There is something that I have long chafed about that is still a thing in 2025r1.
When Toad is connected to a mounted standby database in managed recovery in a SYSDBA session, it does not offer SYS as an available user in Schema Browser. It only offers my logon user even in a SYSDBA session, which is actually a SYS session.
Toad has done this for years, and I have always disliked it. I ought to at least be able to get to SYS for its dynamic performance views.
Cheers,
Russ
Hi Russ,
something that I have long chafed about that
Have you mentioned this before? If so, sorry I missed it. If not, you should have.
It's an easy change that makes sense. And also in the Object Palette. I'll add it soon.
-John
I have not mentioned it here before but should have. The problem has been around a long time, and I thought it was one of those things that are "just the way it has to be".
Cheers,
Russ
I thought it was one of those things that are "just the way it has to be".
No, it was like that because our list of users comes from a query to dba/all/user_users, which of course we couldn't run when connected to db that is mounted but not started. But I can easily add just 'SYS' to that list in this case.
I'm not sure how useful the schema browser will be with only access to V$ views, but I know I can at least show a list of V$ views.
For DBAs who connect frequently to standby databases, being able to pull up v$ views in SB will be a big help.
Cheers,
Russ