Reference Guide > TDV and Business Directory System Tables > SYS_TRANSACTIONS
 
SYS_TRANSACTIONS
The SYS_TRANSACTIONS system table provides a list of current and recent transactions and their current status.
Users see no rows unless they have the ACCESS_TOOLS right. If they have this right, they see rows for all transactions they own. Users with both ACCESS_TOOLS and READ_ALL_STATUS rights can see all rows.
Column
TDV JDBC Data Type
Nullable
Description
TRANSACTION_ID
BIGINT
 
The unique ID for the transaction to which this log entry applies.
SESSION_ID
BIGINT
 
The transaction’s session ID.
OWNER_ID
INTEGER
 
The ID of the user logged into this session.
OWNER
VARCHAR(255)
 
The name of the user logged into this session.
MODE
VARCHAR(255)
 
The mode of the transaction, which can be:
AUTO—The transaction will automatically commit or roll back at the end of the primary request.
EXPLICIT—The transaction will not commit or roll back until explicitly told to do so.
STATUS
VARCHAR(20)
 
Status of the transaction, which can be:
ACTIVE—The transaction is still being executed.
COMMITTED—The transaction has been committed.
ROLLED_BACK—The transaction has been rolled back.
TERMINATED—The transaction was terminated.
START_TIME
TIMESTAMP
 
The time when the transaction was started.
END_TIME
TIMESTAMP
Yes
The time when the transaction completed. NULL if it is still in progress.
DURATION
BIGINT
 
The number of milliseconds the transaction was running.
TOTAL_REQUESTS
INTEGER
 
The number of requests created in the transaction.
ACTIVE_REQUESTS
INTEGER
 
The number of requests active in the transaction.