DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:mime-version:content-type;
        b=bsc7ymQXvT/K18rZuO/yMYUkebwZMlnU3H+VJF+N5oDvogxj9CFzr3gJcfD9y95ULo89ECR8v4TdUXW3iN37xCAVVg58GzLFQwKA5KkRih+QlcKQS0kyetebFFBoQXI/ltnQgUghkRDhOsL1zwQeOTj0ya0oOi3LwP1RPql/xzs=
Message-ID: <1e52ad820709170749y6f4d733ft1ac9ea703b3498cb@mail.gmail.com>
Date: Mon, 17 Sep 2007 10:49:48 -0400
From: "Shivaswamy Raghunath" <shivaswamykr@gmail.com>
To: Oracle-L <oracle-l@freelists.org>
Subject: GV$ROLLNAME on RAC
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_3984_10133862.1190040588517"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: shivaswamykr@gmail.com
------=_Part_3984_10133862.1190040588517
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello.

I do not seem to find a way to list all active transactions in the different
nodes of the cluster from the connected instance (10.2.0.2).

I do not see a view like GV$ROLLNAME which can give me the names of the Undo
segments in different instances. We have only V$ROLLNAME.

I understand undo segments are local to each instance, but having a
centralized view could have been handy.

Do you guys have any work around for this?

Thanks,
Shiva

------=_Part_3984_10133862.1190040588517
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello.<br><br>I do not seem to find a way to list all active transactions in the different nodes of the cluster from the connected instance (<a href="http://10.2.0.2">10.2.0.2</a>). <br><br>I do not see a view like GV$ROLLNAME which can give me the names of the Undo segments in different instances. We have only V$ROLLNAME. 
<br><br>I understand undo segments are local to each instance, but having a centralized view could have been handy.<br><br>Do you guys have any work around for this?<br><br>Thanks,<br>Shiva<br><br>

------=_Part_3984_10133862.1190040588517--
--
http://www.freelists.org/webpage/oracle-l