RE: [toadbeta] RBS activity tab in "Database browser" on RAC

It's working fine here.  We are joining dba_rollback_segs to  gv$rollstat, and when I try it I see results from more than one instance.

Turn on spool sql and see what the query is.  If we are selecting from gv$rollstat, then we are just showing what the database gives us and there is not a problem in Toad.  If we are selecting from v$rollstat, then Toad doesn't think it is connected to RAC.  We use dbms_utility.is_cluster_database to determine if we are connected to RAC or not.



From: [email protected] [mailto:[email protected]] On Behalf Of pathak saurabh
Sent: Tuesday, January 10, 2012 9:39 AM
To: [email protected]; [email protected]
Subject: [toadbeta] RBS activity tab in "Database browser" on RAC




Hi all,

It does not list the RBS activity of all the instances.  Toad list only currently connected instance's system generated RBS only. (

i am using Toad 11.1.0.22(Beta) , and verified also same problem with 11.0.0.116

Saurabh



Reply to sender<mailto:[email protected]?subject=Re%3A%20Running%20script%20on%20another%20instance%20of%20RAC-database> | Reply to group<mailto:[email protected]?subject=Re%3A%20Running%20script%20on%20another%20instance%20of%20RAC-database> | Reply via web post<http://groups.yahoo.com/group/toad/post;_ylc=X3oDMTJxam43ZzEzBF9TAzk3MzU5NzE0BGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BG1zZ0lkAzU3MDUzBHNlYwNmdHIEc2xrA3JwbHkEc3RpbWUDMTMyNjE5MDA3MQ--?act=reply&messageNum=57053> | Start a New Topic<http://groups.yahoo.com/group/toad/post;_ylc=X3oDMTJlOHExMnNoBF9TAzk3MzU5NzE0BGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA250cGMEc3RpbWUDMTMyNjE5MDA3MQ-->
Messages in this topic<http://groups.yahoo.com/group/toad/message/57053;_ylc=X3oDMTM2ZTRoYm9rBF9TAzk3MzU5NzE0BGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BG1zZ0lkAzU3MDUzBHNlYwNmdHIEc2xrA3Z0cGMEc3RpbWUDMTMyNjE5MDA3MQR0cGNJZAM1NzA1Mw--> (1)
.