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 MARCH 12, 2021

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.