Oracle教程 2023-02-24

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 官方解释，作用，如何使用详细说明

分享到：

本站中文解释

官方英文解释

相关推荐