From:Steve Adams
Date:07-Nov-2001 00:02
Subject:   SCN for a transaction

The start SCN for current transactions is visible in V$TRANSACTION. The commit SCN for recent transactions is visible in X$KTUXE.

How to know SCN for a particular trasaction and also the last SCN? Your help would be appriciated.