Note
This view is available starting with V4.0.0.
Overview
Displays all tasks that should be generated currently, including those that have been generated and those that have not been generated.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| LS_ID | NUMBER(38) | NO | Log Stream ID |
| TASK_TYPE | VARCHAR2(64) | NO | Task type. Valid values:
|
| PRIORITY | CHAR(5) | NO | Task priority. Valid values:
|
| TARGET_REPLICA_SVR_IP | VARCHAR2(46) | YES | IP Address of the Server Where the Target Replica Resides |
| TARGET_REPLICA_SVR_PORT | NUMBER(38) | YES | Port number of the server where the target replica resides |
| TARGET_PAXOS_REPLICA_NUMBER | NUMBER(38) | YES | Quorum Paxos Replica Count for Log Stream Target |
| TARGET_REPLICA_TYPE | VARCHAR2(16) | YES | Target Replica Type |
| SOURCE_REPLICA_SVR_IP | VARCHAR2(46) | YES | IP address of the server where the source replica resides. This field is invalid and displays as NULL for tasks such as deleting a replica or modifying the quorum count. |
| SOURCE_REPLICA_SVR_PORT | NUMBER(38) | YES | Port number of the server where the source replica resides. This field is invalid and displays as 0 for tasks such as deleting a replica or modifying the quorum count. |
| SOURCE_PAXOS_REPLICA_NUMBER | NUMBER(38) | YES | Number of Paxos Followers in Log Stream Primary State |
| SOURCE_REPLICA_TYPE | VARCHAR2(16) | YES | Source Replica Type This field is invalid for tasks such as deleting replicas or modifying the quorum replica count, and is displayed as NULL. |
| TASK_EXEC_SVR_IP | VARCHAR2(46) | YES | IP Address of the Task Execution Server |
| TASK_EXEC_SVR_PORT | NUMBER(38) | YES | Port number of the task execution machine |
| COMMENT | VARCHAR2(2048) | YES | Reason for Task Generation Remarks |
Sample query
View the tasks that should be generated for the current tenant.
obclient> SELECT * FROM SYS.V$OB_LS_REPLICA_TASK_PLAN\G
The query result is as follows:
*************************** 1. row ***************************
LS_ID: 1
TASK_TYPE: ADD REPLICA
PRIORITY: HIGH
TARGET_REPLICA_SVR_IP: 172.xx.xxx.243
TARGET_REPLICA_SVR_PORT: 2882
TARGET_PAXOS_REPLICA_NUMBER: 3
TARGET_REPLICA_TYPE: FULL
SOURCE_REPLICA_SVR_IP: 172.xx.xxx.254
SOURCE_REPLICA_SVR_PORT: 2882
SOURCE_PAXOS_REPLICA_NUMBER: 2
SOURCE_REPLICA_TYPE: FULL
TASK_EXEC_SVR_IP: 172.xx.xxx.243
TASK_EXEC_SVR_PORT: 2882
COMMENT: add paxos replica according to locality
1 row in set