TRANSACTIONS
This
statistical system table contains information on the active transactions of a database instance.TRANSACTIONS
|
SESSION |
FIXED (10) |
Database session identification |
|
TRANSCOUNT |
CHAR ( 20) |
Transaction identification |
|
PROCESS |
FIXED (10) |
User process identification |
|
USERNAME |
CHAR ( 32) |
User name |
|
CONNECTDATE |
DATE |
Date of start of session |
|
CONNECTTIME |
TIME |
Time of start of session |
|
TERMID |
CHAR ( 18) |
Terminal identification |
|
REQTIMEOUT |
CHAR ( 10) |
Remaining time until REQUEST_TIMEOUT in seconds |
|
LASTWRITE |
CHAR ( 10) |
Elapsed time since last write request in timeout intervals |
|
LOCKMODE |
CHAR ( 14) |
Type of lock |
|
LOCKSTATE |
CHAR ( 10) |
Status of lock |
|
REQMODE |
CHAR ( 14) |
Type of lock request |
|
REQSTATE |
CHAR ( 10) |
Status of lock request |
|
APPLPROCESS |
FIXED (10) |
Identifier of application process |
|
APPLNODEID |
CHAR ( 64) |
Identifier of client machine of application process |