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 NOVEMBER 07, 2023

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 WORKER GROUP, 1 WORKER SET WITH DOP=2, HENCE 2 PX WORKERS
 EXAMPLE 2 -- 1  WORKER GROUP, 2 WORKER SETS with DOP=2, HENCE 4 PX WORKERS
 EXAMPLE 3 -- 3 WORKER GROUPS, 2 WORKER SETS FOR 2 WORKER GROUPS AND 1 WORKER SET FOR 1 WORKER GROUP, DOP=2, HENCE 10 PX WORKERS
 EXAMPLE 4 -- 1 WORKER GROUP, 1 WORKER SET WITH DOP=4, HENCE 4 PX WORKERS
References


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