how do you find out which sql statements generated the most undo from non-active transactions? i know you can go to v$transaction for an active transaction. also, how do you join v$transaction to v$sql? do I have to go through v$session?
