Toad World® Forums

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 )

.

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.

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

its re-posted by mistake… discard… this…

another email thread is already exist.

Saurabh