Oracle教程 2023-03-23

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

本站中文解释

Oracle视图DBA_XSTREAM_SPLIT_MERGE_HIST用于存储和查看Capture进程或注册的Streams进程及其活动。

它表示在时间窗口内进行的合并和拆分活动，这些活动是在暂停和重新启动应用程序进程时完成的以维护Streams环境。

当Capture进程在捕获和实施数据的变化时，Streams有时需要拆分运行的队列表以获取更具体的控制。最重要的是，Streams提供队列合并功能，以允许将多于一个队列（可能具有多个父队列和多个嵌套的消费者）合并为单个队列逻辑实例，以改进性能并精简体系结构。

视图DBA_XSTREAM_SPLIT_MERGE_HIST包含有关已拆分和合并元数据和组件的元数据以及完成操作的应用程序进程信息。可以使用此视图检查实施拆分和合并的日期和时间，以及实施拆分和合并的操作类型（即合并、拆分或两者）。

要查看此视图，需要具有SELECT_CATALOG_ROLE角色以及执行以下查询所需的DBA角色：

SELECT *
FROM dba_xstream_split_merge_hist;

官方英文解释

DBA_XSTREAM_SPLIT_MERGE_HIST displays information about past XStream 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_QUEUE_OWNER`	`VARCHAR2(128)`		Owner of the queue used by the original capture process
`ORIGINAL_QUEUE_NAME`	`VARCHAR2(128)`		Name of the queue used by the original capture process
`CLONED_QUEUE_OWNER`	`VARCHAR2(128)`		Owner of the queue used by the cloned capture process
`CLONED_QUEUE_NAME`	`VARCHAR2(128)`		Name of the queue used by 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
`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_HIST 官方解释，作用，如何使用详细说明

分享到：

本站中文解释

官方英文解释

相关推荐