Note
This view is available starting with V3.2.1.
Purpose
This view displays running tasks.
Applicability
This view is available only in Oracle-compatible mode of OceanBase Database.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| SID | NUMBER | NO | The identifier of the process that is executing the task. |
| JOB | NUMBER | NO | The identifier of the task. |
| FAILURES | NUMBER | YES | The number of successful and failed executions since the last successful execution of the task. |
| LAST_DATE | DATE | YES | The date of the last successful execution of the task. |
| LAST_SEC | VARCHAR2(32) | NO | The start time of the last successful execution of the task. |
| THIS_DATE | DATE | YES | The date when the task started to be executed. |
| THIS_SEC | VARCHAR2(32) | NO | The start time when the task was successfully executed. |
| INSTANCE | VARCHAR2(128) | YES | The zone where the job is running. |