Mark, You're right for the names. I gave only gv$transaction and the other since Shiva asked for the ones to get the active transactions (but I've not thought abot the names) >What is wrong with use DBA_ROLLBACK_SEGS to get the rollback segment_names for each instance?