1 – transactions_field
This field gives the number of completed database transactions.
This is the count of the COMMIT and ROLLBACK statements that have
executed.
2 – __committed_field
This field identifies the actual number of transactions that
committed successfully to the database.
3 – __rolled_back_field
This field identifies the actual number of transactions that were
aborted and were not applied to the database.
4 – ____duration_x100_field_
This field identifies the duration of the transaction rollback
operation, expressed in hundredths of a second displayed as a
whole number. For example, the value 500 is actually 5 seconds.
5 – __prepared_field
This field identifies the number of distributed transactions
that have successfully "prepared" themselves for subsequent
transaction commit.
6 – __not_modified_field
This field identifies the number of committed transactions that
did not modify any database objects. This field includes both
read-only and read/write transactions.
7 – verb_successes_field
This field gives the number of completed verbs that returned a
successful status code.
8 – verb_failures_field
This field gives the number of completed verbs that returned
an error status code. Errors include end-of-collection and
deadlocks, as well as all other exception conditions.
9 – __duration_x100_field
This field identifies the duration of the verb failure rollback
operation, expressed in hundredths of a second displayed as a
whole number. For example, the value 500 is actually 5 seconds.
10 – checkpoints_field
This field identifies the number of checkpoints performed by
users. This field does not include the initial checkpoint when
the user first attaches to the database.
11 – ___duration_x100_field
This field displays the checkpoint duration, expressed in
hundredths of a second displayed as a whole number. For example,
the value 500 is actually 5 seconds.
12 – RUJ file reads field
This field displays the total number of read I/O operations
performed on the RUJ journal during the transaction undo phase.
The RUJ file is never written by the database recovery (DBR)
process.
This field includes both synchronous and asynchronous I/O read
requests.
13 – ____file_writes_field_
This field displays the total number of write I/O operations
performed on the RUJ journal during the transaction phase.
This field includes both synchronous and asynchronous I/O read
requests.
14 – ____file_extend_field_
This field identifies the number of times an RUJ file has been
extended.