RE: GV$ROLLNAME on RAC

What is wrong with use DBA_ROLLBACK_SEGS to get the rollback segment_names for each instance?  

• Mark D Powell -- Phone (313) 592-5148

  ---

	From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Alvaro Jose Fernandez
	Sent: Monday, September 17, 2007 11:01 AM
	To: shivaswamykr_at_gmail.com; Oracle-L
	Subject: RE: GV$ROLLNAME on RAC
	
	

	Hi,

	 

	You have GV$TRANSACTION and for the rollback stats, GV$ROLLSTAT (both includes instance number)

	żis these what are you looking for?

	 

	regards,

	
	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

--
http://www.freelists.org/webpage/oracle-l