Viewing the Span of a Transaction

In this example, the transaction is identified by system process ID 15 and the database ID is 4:

select loginfo(4, 'xactspanbyspid', 15) 
    as xact_span_spid15_dbid4

xact_span_spid15_dbid4 
 ---------------------- 
                     10 

This indicates that system process 15 is an active transaction and the log transaction span is 10 percent.