Note
This view is available starting with V3.2.1.
Purpose
This view displays the running tasks.
Applicability
This view is available only in Oracle mode of OceanBase Database.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| SID | NUMBER | NO | The identifier of the process that is running 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 this task. |
| LAST_DATE | DATE | YES | The date of the last successful execution of this task. |
| LAST_SEC | VARCHAR2(32) | NO | The start time of the last successful execution of this task. |
| THIS_DATE | DATE | YES | The date when the task started to run. |
| THIS_SEC | VARCHAR2(32) | NO | The start time when the task ran successfully. |
| INSTANCE | VARCHAR2(128) | YES | The zone where the job runs. |