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

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