Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> non-active transactions and undo
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?
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 17 2006 - 12:46:24 CDT
![]() |
![]() |