Viewing the Span of a Transaction

The system administrator can view the span of a transaction started by a specific process.

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.