Overview
The DBA_WR_ACTIVE_SESSION_HISTORY view displays the persisted ASH data for the current tenant.
Columns
Column |
Type |
Is NULL |
Description |
|---|---|---|---|
| CLUSTER_ID | bigint(20) | NO | Cluster ID |
| TENANT_ID | bigint(20) | NO | Tenant ID |
| SNAP_ID | bigint(20) | NO | Snapshot ID |
| SVR_IP | varchar(46) | NO | Node IP |
| SVR_PORT | bigint(20) | NO | Node Port |
| SAMPLE_ID | bigint(20) | NO | Sample ID |
| SESSION_ID | bigint(20) | NO | ID of the sampled session.
|
| SAMPLE_TIME | timestamp(6) | NO | Sampling Time |
| USER_ID | bigint(20) | YES | User ID of the Sampled Session |
| SESSION_TYPE | tinyint(4) | YES | SESSION type.
|
| SESSION_STATE | varchar(7) | NO | Status at the time of session sampling.
|
| SQL_ID | varchar(32) | YES | SQL ID |
| TRACE_ID | varchar(64) | YES | TRACE_ID |
| EVENT_NO | bigint(20) | YES | Internal event ID, used to associate queries with other tables |
| EVENT_ID | bigint(20) | YES | Indicates the ID of the event currently being waited for. |
| TIME_WAITED | bigint(20) | YES | Total wait time for this event, in microseconds (μs). |
| P1 | bigint(20) | YES | Value of Parameter 1 for the Wait Event |
| P2 | bigint(20) | YES | Value of Parameter 2 for the Wait Event |
| P3 | bigint(20) | YES | Value of Parameter 3 for Waiting for Events |
| SQL_PLAN_LINE_ID | bigint(20) | YES | SQL operator ID during sampling. The value is NULL if no operator is found. |
| GROUP_ID | bigint(20) | YES | Resource Group ID |
| PLAN_HASH | bigint(20) unsigned | YES | Plan hash of the currently executed SQL statement |
| THREAD_ID | bigint(20) | YES | Thread ID of the current active session |
| STMT_TYPE | bigint(20) | YES | SQL Type of Current Active Session |
| TX_ID | bigint(20) | YES | Current Transaction ID |
| BLOCKING_SESSION_ID | bigint(20) | YES | If the current session is blocked, displays the session ID that blocked it. This feature currently takes effect only in lock conflict scenarios, showing the session IDs of the holding locks. |
| TIME_MODEL | bigint(20) unsigned | YES | Information about TIME MODEL |
| IN_PARSE | varchar(1) | NO | Whether the current session is performing SQL parse during sampling |
| IN_PL_PARSE | varchar(1) | NO | Whether the current session is performing SQL PL parse during sampling |
| IN_PLAN_CACHE | varchar(1) | NO | Whether the current session is performing plan cache during sampling |
| IN_SQL_OPTIMIZE | varchar(1) | NO | Whether the current session is performing SQL optimization during sampling |
| IN_SQL_EXECUTION | varchar(1) | NO | Whether the current session is performing SQL execution during sampling |
| IN_PX_EXECUTION | varchar(1) | NO | Whether the current session is performing SQL parallel execution during sampling. When a session is in this state, it must also be in the IN_SQL_EXECUTION state. |
| IN_SEQUENCE_LOAD | varchar(1) | NO | Whether the current session is fetching values from an auto-increment column or a sequence during sampling. |
| IN_COMMITTING | varchar(1) | NO | Whether the current sampling point is in the transaction commit phase |
| IN_STORAGE_READ | varchar(1) | NO | Whether the current sampling point is in the storage read phase |
| IN_STORAGE_WRITE | varchar(1) | NO | Whether the current sampling point is in the storage write phase |
| IN_REMOTE_DAS_EXECUTION | varchar(1) | NO | Whether the current sampling point is in the DAS remote execution phase |
| IN_FILTER_ROWS | varchar(1) | NO | Whether the current sampling point is in the store pushdown execution phase |
| IN_FILTER_ROWS | varchar(1) | NO | Indicates whether the current sampling point is in the store pushdown execution phase. |
| IN_RPC_ENCODE | varchar(1) | NO | The serialization operation currently in progress for the SQL statement |
| IN_RPC_DECODE | varchar(1) | NO | Deserialization Operation in Progress for the Current SQL |
| IN_CONNECTION_MGR | varchar(1) | NO | The current SQL statement is performing a link establishment operation. |
| PROGRAM | varchar(64) | YES | Program name being executed at the current sampling point:
|
| MODULE | varchar(64) | YES | The MODULE value recorded in the current session at the sampling moment. It is obtained through DBMS_APPLICATION_INFO.SET_MODULE Package settings |
| ACTION | varchar(64) | YES | The sampled ACTION value recorded on the current session, obtained through DBMS_APPLICATION_INFO.SET_ACTION Package settings |
| CLIENT_ID | varchar(64) | YES | The CLIENT_ID value recorded in the current session at the sampling moment, obtained through DBMS_SESSION.set_identifier Package settings |
| BACKTRACE | varchar(512) | YES | Auxiliary debugging field, used to record the code call stack when an event occurs. |
| PLAN_ID | bigint(20) | YES | The plan ID of the sampled SQL statement in the PLAN CACHE, used to associate the sampling point with the plan. |
| TM_DELTA_TIME | bigint(20) | YES | Calculate the time interval of the time model, in microseconds. |
| TM_DELTA_CPU_TIME | bigint(20) | YES | Past TM_DELTA_TIME The amount of time spent on the CPU during the period |
| TM_DELTA_DB_TIME | bigint(20) | YES | Past TM_DELTA_TIME The amount of time spent on database calls within the time period. |
| TOP_LEVEL_SQL_ID | varchar(32) | YES | Top-level SQL ID |
| IN_PLSQL_COMPILATION | varchar(1) | NO | Current PL Compilation Status: Y/N |
| IN_PLSQL_EXECUTION | varchar(1) | NO | Current PL Execution Status: Y/N |
| PLSQL_ENTRY_OBJECT_ID | bigint(20) | YES | OBJECT ID of the Top-Level PL |
| PLSQL_ENTRY_SUBPROGRAM_ID | bigint(20) | YES | Sub-project ID of the top-level PL |
| PLSQL_ENTRY_SUBPROGRAM_NAME | varchar(32) | YES | Sub project name of the top-level PL |
| PLSQL_OBJECT_ID | bigint(20) | YES | ID of the PL object currently being executed |
| PLSQL_SUBPROGRAM_ID | bigint(20) | YES | ID of the PL subprogram currently being executed |
| PLSQL_SUBPROGRAM_NAME | varchar(32) | YES | Name of the currently executing PL subprogram |
| DELTA_READ_IO_REQUESTS | bigint(20) | YES | Number of Reads Between Two Samples |
| DELTA_READ_IO_BYTES | bigint(20) | YES | Cumulative File Size Read Between Two Samples |
| DELTA_WRITE_IO_REQUESTS | bigint(20) | YES | Number of Writes Between Two Samples |
| DELTA_WRITE_IO_BYTES | bigint(20) | YES | Cumulative File Size Written Between Two Samples |
| TABLET_ID | bigint(20) | YES | ID of the tablet being processed by the current SQL statement |
| PROXY_SID | bigint(20) | YES | Proxy Session ID |
| WEIGHT | double | YES | This WR record indicates the number of occurrences of the same action by the same tenant within the specified time range. |
Sample query
Query the persistent ASH data for this tenant.
obclient(root@mysql001)[oceanbase]> SELECT * FROM oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY limit 1\G
The return result is as follows:
*************************** 1. row ***************************
CLUSTER_ID: 10001
TENANT_ID: 1002
SNAP_ID: 414
SVR_IP: xxxxxx
SVR_PORT: 2882
SAMPLE_ID: 11498170
SESSION_ID: 2305843009213711000
SAMPLE_TIME: 2026-04-30 16:00:42.757594
USER_ID: 0
SESSION_TYPE: 1
SESSION_STATE: WAITING
SQL_ID: NULL
TRACE_ID: NULL
EVENT_NO: 141
EVENT_ID: 18249
TIME_WAITED: 100037
P1: 22440449135792
P2: 0
P3: 0
SQL_PLAN_LINE_ID: NULL
GROUP_ID: 0
PLAN_HASH: NULL
THREAD_ID: 3048339
STMT_TYPE: NULL
TX_ID: NULL
BLOCKING_SESSION_ID: NULL
TIME_MODEL: 0
IN_PARSE: N
IN_PL_PARSE: N
IN_PLAN_CACHE: N
IN_SQL_OPTIMIZE: N
IN_SQL_EXECUTION: N
IN_PX_EXECUTION: N
IN_SEQUENCE_LOAD: N
IN_COMMITTING: N
IN_STORAGE_READ: N
IN_STORAGE_WRITE: N
IN_REMOTE_DAS_EXECUTION: N
IN_PLSQL_COMPILATION: N
IN_PLSQL_EXECUTION: N
IN_FILTER_ROWS: N
IN_RPC_ENCODE: N
IN_RPC_DECODE: N
IN_CONNECTION_MGR: N
PROGRAM: T1002_LogService
MODULE: LogRestoreService
ACTION: RemoteLogWriter
CLIENT_ID: NULL
BACKTRACE: NULL
PLAN_ID: 0
TM_DELTA_TIME: 1000050
TM_DELTA_CPU_TIME: 187
TM_DELTA_DB_TIME: 1000050
TOP_LEVEL_SQL_ID: NULL
PLSQL_ENTRY_OBJECT_ID: NULL
PLSQL_ENTRY_SUBPROGRAM_ID: NULL
PLSQL_ENTRY_SUBPROGRAM_NAME: NULL
PLSQL_OBJECT_ID: NULL
PLSQL_SUBPROGRAM_ID: NULL
PLSQL_SUBPROGRAM_NAME: NULL
DELTA_READ_IO_REQUESTS: 0
DELTA_READ_IO_BYTES: 0
DELTA_WRITE_IO_REQUESTS: 0
DELTA_WRITE_IO_BYTES: 0
TABLET_ID: NULL
PROXY_SID: 2305843009213711000
WEIGHT: 1
1 row in set (0.278 sec)