V$OB_PX_TARGET_MONITOR

2025-12-09 07:09:36  Updated

Feature

This view displays the usage of PX threads on OBServer nodes.

Fields

Field Type Nullable Description
SVR_IP VARCHAR2(46) NO The IP address of the local OBServer.
SVR_PORT NUMBER(38) NO The port number of the local OBServer.
TENANT_ID NUMBER(38) NO The ID of the tenant.
IS_LEADER CHAR(1) NO Indicates whether the replica is the leader replica of the dummy table.
VERSION NUMBER(38) NO The number of times that statistics collection is reinitiated.
PEER_IP VARCHAR2(46) NO The IP address of the peer OBServer.
PEER_PORT NUMBER(38) NO The port number of the peer OBServer.
PEER_TARGET NUMBER(38) NO The total number of PX threads on the peer OBServer.
PEER_TARGET_USED NUMBER(38) NO The number of used PX threads on the peer OBServer.
LOCAL_TARGET_USED NUMBER(38) NO The number of peer PX threads used by the local OBServer.
LOCAL_PARALLEL_SESSION_COUNT NUMBER(38) NO The number of sessions being concurrently executed on the local OBServer.

Contact Us