Note
This view was introduced in OceanBase Database V4.2.5.
Purpose
The oceanbase.DBA_OB_SPM_EVO_RESULT view displays the SQL Plan Management (SPM) evolution information of the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | YES | The user that performed the evolution task. |
| RECORD_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the evolution task was recorded. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server where the evolution task was performed. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server where the evolution task was performed. |
| SQL_ID | VARCHAR2(32) | NO | The ID of the SQL statement that performed the evolution task. |
| TYPE | VARCHAR2(32) | NO | The type of the record. Value values:
|
| START_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | YES | The start time of the evolution task. |
| END_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | YES | The end time of the evolution task. |
| STATUS | VARCHAR2(7) | YES | The status of the evolution task.
|
| NEW_PLAN_BETTER | NUMBER(38) | YES | Indicates whether the evolution plan is better. |
| EVO_PLAN_EXEC_COUNT | NUMBER(38) | YES | The number of executions of the evolution plan during the evolution. |
| EVO_PLAN_CPU_TIME | NUMBER(38) | YES | The average CPU time taken by the evolution plan during the evolution. |
| BASELINE_EXEC_COUNT | NUMBER(38) | YES | The number of executions of the baseline plan during the evolution. |
| BASELINE_CPU_TIME | NUMBER(38) | YES | The average CPU time taken by the baseline plan during the evolution. |