Parallel Query Server (PD_PDPQ)
- Organization of this page
Function
The Parallel Query Server (PD_PDPQ) record stores performance data indicating the status of parallel query servers at a specific point in time. PFM - Agent for Oracle creates one record for each parallel query server of an instance. This is a multi-instance record.
Default and changeable values
|
Item |
Default value |
Changeable |
|---|---|---|
|
Collection Interval |
300 |
Y |
|
Collection Offset |
55 |
Y |
|
Log |
No |
Y |
|
LOGIF |
(Blank) |
Y |
|
Over 10 Sec Collection Time |
No |
N |
ODBC key fields
PD_PDPQ_SLAVE_NAME
Lifetime
From the start to the end of a Parallel Execution Server
Record size
-
Fixed part: 678 bytes
-
Variable part: 90 bytes
Fields
|
PFM - View name (PFM - Manager name) |
Description |
Summary |
Format |
Delta |
Supported version |
Data source |
|---|---|---|---|---|---|---|
|
Busy % (PERCENT_BUSY) |
Percentage of time the query server was busy |
-- |
double |
No |
All |
(V$PQ_SLAVE.BUSY_TIME_TOTAL / (V$PQ_SLAVE.IDLE_TIME_TOTAL + V$PQ_SLAVE.BUSY_TIME_TOTAL)) * 100 |
|
Current Busy Time (BUSY_TIME_CUR) |
Length of time the query server was busy during the SQL statement processing in the session that was active during data collection |
-- |
ulong |
No |
All |
V$PQ_SLAVE.BUSY_TIME_CUR |
|
Current CPU Secs (CPU_SECS_CUR) |
CPU time used in the session that was active during data collection |
-- |
ulong |
No |
All |
V$PQ_SLAVE.CPU_SECS_CUR |
|
Current Idle Time (IDLE_TIME_CUR) |
Length of time the query server was idle during SQL statement processing in the session that was active during data collection |
-- |
ulong |
No |
All |
V$PQ_SLAVE.IDLE_TIME_CUR |
|
Current Msgs Rcvd (MSGS_RCVD_CUR) |
Number of messages received during SQL statement processing by the session that was active during data collection |
-- |
ulong |
No |
All |
V$PQ_SLAVE.MSGS_RCVD_CUR |
|
Current Msgs Sent (MSGS_SENT_CUR) |
Number of messages sent during SQL statement processing by the session that was active during data collection |
-- |
ulong |
No |
All |
V$PQ_SLAVE.MSGS_SENT_CUR |
|
Idle % (PERCENT_IDLE) |
Number of messages sent during SQL statement processing by the session that was active during data collection |
-- |
double |
No |
All |
(V$PQ_SLAVE.IDLE_TIME_TOTAL / (V$PQ_SLAVE.IDLE_TIME_TOTAL + V$PQ_SLAVE.BUSY_TIME_TOTAL)) * 100 |
|
Record Time (RECORD_TIME) |
Collection termination time for the performance data stored in the record |
-- |
time_t |
No |
All |
Agent Collector |
|
Record Type (INPUT_RECORD_TYPE) |
Record name (always PDPQ) |
-- |
string(4) |
No |
All |
Agent Collector |
|
Sessions (SESSIONS) |
Number of sessions in use by the parallel query server |
-- |
ulong |
No |
All |
V$PQ_SLAVE.SESSIONS |
|
Slave Name (SLAVE_NAME) |
Name of the parallel query server |
-- |
string(4) |
No |
All |
V$PQ_SLAVE.SLAVE_NAME |
|
Start Time (START_TIME) |
Collection start time for the performance data stored in the record |
-- |
time_t |
No |
All |
Agent Collector |
|
Status (STATUS) |
Status of the parallel query server during data collection. Valid values are BUSY and IDLE. |
-- |
string(4) |
No |
All |
V$PQ_SLAVE.STATUS |
|
Total Busy Time (BUSY_TIME_TOTAL) |
Total length of time the query server was active during the interval |
-- |
double |
No |
All |
V$PQ_SLAVE.BUSY_TIME_TOTAL |
|
Total CPU Secs (CPU_SECS_TOTAL) |
Total CPU time used by the query server to process SQL statements during the interval |
-- |
double |
No |
All |
V$PQ_SLAVE.CPU_SECS_TOTAL |
|
Total Idle Time (IDLE_TIME_TOTAL) |
Total length of time the query server was idle during the interval |
-- |
double |
No |
All |
V$PQ_SLAVE.IDLE_TIME_TOTAL |
|
Total Msgs Rcvd (MSGS_RCVD_TOTAL) |
Total number of messages received by the query server during the interval |
-- |
double |
No |
All |
V$PQ_SLAVE.MSGS_RCVD_TOTAL |
|
Total Msgs Sent (MSGS_SENT_TOTAL) |
Total number of messages sent by the query server during the interval |
-- |
double |
No |
All |
V$PQ_SLAVE.MSGS_SENT_TOTAL |