My Oracle Support Banner

What is the Meaning of the PX_SERVER# Column in the (G)V$SQL_MONITOR View (Doc ID 2034924.1)

Last updated on JULY 22, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Goal

Explain what does PX_SERVER# column in the (G)V$SQL_MONITOR view mean, and what is expected to be seen there.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 EXAMPLE 1 -- 1 SLAVE GROUP, 1 SLAVE SET WITH DOP=2, HENCE 2 PX SLAVES
 EXAMPLE 2 -- 1 SLAVE GROUP, 2 SLAVE SETS with DOP=2, HENCE 4 PX SLAVES
 EXAMPLE 3 -- 3 SLAVE GROUPS, 2 SLAVE SETS FOR 2 SLAVE GROUPS AND 1 SLAVE SET FOR 1 SLAVE GROUP, DOP=2, HENCE 10 PX SLAVES
 EXAMPLE 4 -- 1 SLAVE GROUP, 1 SLAVE SET WITH DOP=4, HENCE 4 PX SLAVES
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.