(B)0[m[4mSHOW[m [4mTRANSACTION[m qqq>
Displays information about the transaction mode, transaction id
(TID), transaction sequence number (TSN), and, for read/write
transactions, the status of updates and the full recovery-unit
journal (RUJ) file specification. The SHOW TRANSACTION statement
also shows whether or not fast commit is enabled.
You must have the Oracle Rdb READ privilege for a database to use
the SHOW TRANSACTION statement.
The following START_TRANSACTION statement starts a read/write
transaction reserving the EMPLOYEES table for shared read. Note
that the SHOW TRANSACTION statement shows that fast commit is
enabled for the database.
RDO> START_TRANSACTION READ_WRITE RESERVING
cont> EMPLOYEES FOR SHARED READ
RDO> SHOW TRANSACTION
All Transactions in Database with filename MF_PERSONNEL
a read-write transaction is in progress
- updates have not been performed
- fast commit is enabled
- transaction sequence number (TSN) is 121
- snapshot space for TSNs less than 121 can be reclaimed
- session ID number is 42