Transactions that prevent truncation points from moving
None
| Name | Data Type | Description |
|---|---|---|
| DBID | long | Database ID |
| DBNAME | string(32) | Database name |
| SPID | long | Session process ID |
| PAGE | double | Page # of the start of the oldest transaction, or of the truncation page for Replication Server |
| XACTID | binary(8) | Transaction ID of the oldest active transaction; 0x0 for Replication Server |
| MASTERXACTID | binary(8) | ID of the master transaction, if applicable; 0x0 = no master transaction, or Replication Server |
| STARTTIME | time | Time of the start of the transaction, or when the truncation point was set for Replication Server |
| NAME | string(92) | Name of the oldest active transaction; "$user_transaction", if no name given for the transaction with "begin transaction"; "$chained_transaction" for implicit transactions started by ANSI chained mode; "$replication_truncation_point" for Replication Server |
| XLOID | long | Lock ownership ID |
| SECS_HELD | long | Hold time by the transaction, in seconds |
| INSTANCEID | long | Instance ID; 0 = non-CE |
| Attributes: | None |
|---|---|
| Minimum database version: | 12.5.0.3 |