Oracle教程

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

本站中文解释

Oracle视图V$EQ_CROSS_INSTANCE_JOBS记录多个实例的跨实例作业的活动状态。它可用于帮助用户监视跨实例作业的活动状态，以及查看对实例及跨实例作业的健康状态的动态视图。

V$EQ_CROSS_INSTANCE_JOBS视图可以帮助用户监控以下信息：

（1）装态：正在运行，已完成，正在准备，已取消，失败，超时。

（2）起始和结束时间。

（3）实例名称。

（4）作业步骤详细情况。

使用V$EQ_CROSS_INSTANCE_JOBS可以针对特定跨实例作业检查其装态，并通过在第二列中查看准备状态来检查跨实例作业的运行状态。要监测特定跨实例作业的进度，请在“job_name”列中检查表中的具体内容。用户可以从V$EQ_CROSS_INSTANCE_JOBS视图中获取相关信息，并以图形格式展示任务的状态。另外，用户还可以对跨实例作业的运行状态进行实时监控，以进行正确的调整和处理。

官方英文解释

V$EQ_CROSS_INSTANCE_JOBS describes Transactional Event Queue (TEQ) cross-instance jobs.

Each job forwards messages for an event stream from a source instance to a destination instance for a set of subscribers of a TEQ.

Column Datatype Description

JOB_ID

NUMBER

Job ID within this coordinator

SCHEMA_NAME

VARCHAR2(128)

Source schema of the job

QUEUE_NAME

VARCHAR2(128)

Source queue name of the job

EVENT_STREAM_ID

NUMBER

Source event stream ID

START_EVENT_STREAM_PARTITION_ID

NUMBER

Start event stream partition ID of the job

DESTINATION_INSTANCE_ID

NUMBER

Destination instance of the job

COORDINATOR_ID

NUMBER

Index of the coordinator serving the job

DEST_SERVER_PROCESS_ID

NUMBER

Process ID of the destination server

JOB_STATE

VARCHAR2(28)

State of the job. Possible values:

  • REQUESTED

  • RUNNING

  • STOPPED

  • PAUSED

  • CRASHED

  • INACTIVE

FLOW_CONTROL

NUMBER

Indicates whether the job is flow controlled. Possible values:

  • 0 – The job is not flow controlled

  • 1 – The job is flow controlled

MSGS_SENT

NUMBER

Number of messages sent during the job

BYTES_SENT

NUMBER

Number of bytes sent during the job

ACK_LATENCY

NUMBER

Latency for receiving ACK for the job

JOB_TYPE

VARCHAR2(26)

Job type. Possible values:

  • CROSS_STREAM: This job type is responsible for forwarding an event stream from its owner instance to a destination dequeue instance for all subscribers performing dequeue from that event stream at the destination dequeue instance.

  • DEQUEUE_AFFINITY_TO_REMOTE: This job type is responsible for switching a subscriber’s dequeue affinity from an event stream’s owner instance to a remote dequeue instance.

  • DEQUEUE_AFFINITY_TO_LOCAL: This job type is responsible for switching back a subscriber’s dequeue affinity from a remote dequeue instance to an event stream’s owner instance.

PRIORITY0_CROSS_LWM

NUMBER

ID of last priority 0 event stream partition received at DESTINATION_INSTANCE_ID

PRIORITY1_CROSS_LWM

NUMBER

ID of last priority 1 event stream partition received at DESTINATION_INSTANCE_ID

PRIORITY2_CROSS_LWM

NUMBER

ID of last priority 2 event stream partition received at DESTINATION_INSTANCE_ID

PRIORITY3_CROSS_LWM

NUMBER

ID of last priority 3 event stream partition received at DESTINATION_INSTANCE_ID

PRIORITY4_CROSS_LWM

NUMBER

ID of last priority 4 event stream partition received at DESTINATION_INSTANCE_ID

PRIORITY5_CROSS_LWM

NUMBER

ID of last priority 5 event stream partition received at DESTINATION_INSTANCE_ID

PRIORITY6_CROSS_LWM

NUMBER

ID of last priority 6 event stream partition received at DESTINATION_INSTANCE_ID

PRIORITY7_CROSS_LWM

NUMBER

ID of last priority 7 event stream partition received at DESTINATION_INSTANCE_ID

PRIORITY8_CROSS_LWM

NUMBER

ID of last priority 8 event stream partition received at DESTINATION_INSTANCE_ID

PRIORITY9_CROSS_LWM

NUMBER

ID of last priority 9 event stream partition received at DESTINATION_INSTANCE_ID

JOB_START_TIME

TIMESTAMP(3) WITH TIME ZONE

Start time of this job

SUBSCRIBER_ID

NUMBER

ID of the subscriber whose affinity is being switched for the DEQUEUE_AFFINITY_TO_REMOTE and DEQUEUE_AFFINITY_TO_LOCAL job types

SUBSCRIBER_NAME

VARCHAR2(512)

Name of subscriber whose affinity is being switched for the DEQUEUE_AFFINITY_TO_REMOTE and DEQUEUE_AFFINITY_TO_LOCAL job types.

This column is NULL for the CROSS_STREAM job type.

OWNER_INSTANCE_ID

NUMBER

ID of the instance that owns the event stream

QUEUE_ID

NUMBER

Queue ID

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

Note:

This view is available starting with Oracle Database 21c.

See Also:

Oracle Database Advanced
Queuing User’s Guide for more information about Oracle Transactional Event Queues and Advanced Queuing


数据运维技术 » Oracle 视图 V$EQ_CROSS_INSTANCE_JOBS 官方解释，作用，如何使用详细说明
分享到：

相关推荐