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

the sql i got from sqltracker is 

SELECT s.inst_id,
       r.segment_name,
       r.owner,
       r.tablespace_name,
       r.status,
       r.initial_extent / 1024 / 1024 initial_extent,
       r.next_extent / 1024 / 1024 next_extent,
       s.extents,
       ROUND (s.rssize / 1024 / 1024) rssize,
       s.xacts
  FROM dba_rollback_segs r, v$rollname n, gv$rollstat s
 WHERE r.segment_name = n.name AND 
       n.usn = s.usn


which list all sys generated rollback segs in UNDO Tablespace for the instance you connected and listing one of each instance "SYSTEM" tablespace rbs. 

Saurabh


To: [email protected]; [email protected]
From: [email protected]
Date: Tue, 10 Jan 2012 15:53:08 +0000
Subject: 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 | 
Reply to group | 
Reply via web post | 
Start a New Topic




Messages
 in this topic (1) 



.