Oracle 视图 DBA_XSTREAM_SPLIT_MERGE 官方解释,作用,如何使用详细说明

本站中文解释

Oracle视图DBA_XSTREAM_SPLIT_MERGE是一个描述了数据库注册和任务状态的系统视图。它显示了客户机上运行的XStream流合并和拆分任务,包括任务名称、状态、任务类型、何时开始和何时结束。

使用案例:使用此视图,DBA可以检查先前在客户机上运行的拆分和合并任务的状态,并确定任务的时间段。

官方英文解释

DBA_XSTREAM_SPLIT_MERGE displays information about XStream current automatic split and merge operations.

Column Datatype NULL Description

ORIGINAL_CAPTURE_NAME

VARCHAR2(128)

NOT NULL

Name of the original capture process

CLONED_CAPTURE_NAME

VARCHAR2(128)

Name of the cloned capture process

ORIGINAL_CAPTURE_STATUS

VARCHAR2(8)

Status of the original capture process:

  • DISABLED

  • ENABLED

  • ABORTED

CLONED_CAPTURE_STATUS

VARCHAR2(8)

Status of the cloned capture process:

  • DISABLED

  • ENABLED

  • ABORTED

ORIGINAL_XSTREAM_NAME

VARCHAR2(128)

Name of the original XStream component that receives database changes directly from the original capture process. The component is either a progagation or a local apply process.

CLONED_XSTREAM_NAME

VARCHAR2(128)

Name of the cloned XStream component that receives database changes directly from the cloned capture process. The component is either a progagation or a local apply process.

XSTREAM_TYPE

VARCHAR2(11)

Type of the component in ORIGINAL_XSTREAM_NAME and CLONED_XSTREAM_NAME:

  • PROPAGATION

  • APPLY

RECOVERABLE_SCRIPT_ID

RAW(16)

Unique ID of the script to split or merge operation

SCRIPT_STATUS

VARCHAR2(12)

Status of the recoverable script:

  • GENERATING

  • NOT EXECUTING

  • EXECUTING

  • EXECUTED

  • ERROR

ACTION_TYPE

VARCHAR2(7)

type of action performed by the script:

  • SPLIT

  • MERGE

  • MONITOR

ACTION_THRESHOLD

VARCHAR2(40)

For SPLIT actions, the threshold set by the split_threshold capture process parameter. For MERGE actions, the threshold set by the merge_threshold capture process parameter.

STATUS

VARCHAR2(16)

Status of the action:

  • NOTHING TO SPLIT – Not ready to split or does not need to split

  • ABOUT TO SPLIT

  • SPLITTING – A split is in progress

  • SPLIT DONE – A split is done

  • NOTHING TO MERGE – Not ready to merge

  • ABOUT TO MERGE

  • MERGING – A merge is in progress

  • MERGE DONE – A merge is done

  • ERROR – An error was returned during a split or merge

  • NONSPLITTABLE – The original capture is not splittable either because it is disabled, it has more than one publisher to its queue, or it has only one destination for captured messages

STATUS_UPDATE_TIME

TIMESTAMP(6)

Time when status was last updated

CREATION_TIME

TIMESTAMP(6)

Time when the action started

LAG

NUMBER

Time (in seconds) that the cloned capture process lags behind the original capture process

JOB_OWNER

VARCHAR2(128)

Owner of the job that performs the split or merge operation

JOB_NAME

VARCHAR2(128)

Name of the job that performs the split or merge operation

JOB_STATE

VARCHAR2(15)

Current state of the job:

  • DISABLED

  • RETRY SCHEDULED

  • SCHEDULED

  • RUNNING

  • COMPLETED

  • BROKEN

  • FAILED

  • REMOTE

  • SUCCEEDED

  • CHAIN_STALLED

JOB_NEXT_RUN_DATE

VARCHAR2(64)

Next time the job will run

ERROR_NUMBER

NUMBER

Error number if the capture process was aborted

ERROR_MESSAGE

VARCHAR2(4000)

Error message if the capture process was aborted


数据运维技术 » Oracle 视图 DBA_XSTREAM_SPLIT_MERGE 官方解释,作用,如何使用详细说明