SUMMARY_WORKLOAD_TRANSACTION
Displays information about transactions loaded in the database, as shown in Table 1. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and information about a PDB is returned if this view is accessed in the PDB.
| Name | Type | Description |
|---|---|---|
| workload | name | Workload name. |
| commit_counter | numeric | Number of user transactions committed. |
| rollback_counter | numeric | Number of user transactions rolled back. |
| resp_min | bigint | Minimum response time of user transactions (unit: μs). |
| resp_max | bigint | Maximum response time of user transactions (unit: μs). |
| resp_avg | bigint | Average response time of user transactions (unit: μs). |
| resp_total | numeric | Total response time of user transactions (unit: μs). |
| bg_commit_counter | numeric | Number of background transactions committed. |
| bg_rollback_counter | numeric | Number of background transactions rolled back. |
| bg_resp_min | bigint | Minimum response time of background transactions (unit: μs). |
| bg_resp_max | bigint | Maximum response time of background transactions (unit: μs). |
| bg_resp_avg | bigint | Average response time of background transactions (unit: μs). |
| bg_resp_total | numeric | Total response time of background transactions (unit: μs). |
| dbid | oid | ID of the database to which the statistics belong. |
