Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> non-active transactions and undo

non-active transactions and undo

From: <ryan_gaffuri_at_comcast.net>
Date: Tue, 17 Oct 2006 17:46:24 +0000
Message-Id: <101720061746.6524.453516F00009CB5C0000197C2207001641079D9A00000E09A1020E979D@comcast.net>


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-l
Received on Tue Oct 17 2006 - 12:46:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US