Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Mon Sep 17 2007 - 10:00:53 CDT