Parallel Query Server Interval (PI_PIPQ)
- Organization of this page
Function
The Parallel Query Server Interval (PI_PIPQ) record stores performance data, taken at specific intervals, about parallel query servers. 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 |
45 |
Y |
|
Log |
No |
Y |
|
LOGIF |
(Blank) |
Y |
|
Over 10 Sec Collection Time |
No |
N |
ODBC key fields
PI_PIPQ_SLAVE_NAME
Lifetime
From the start to the end of a Parallel Execution Server
Record size
-
Fixed part: 678 bytes
-
Variable part: 246 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#2 |
AVG |
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#2 |
AVG |
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#2 |
AVG |
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#2 |
AVG |
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#2 |
AVG |
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#2 |
AVG |
ulong |
No |
All |
V$PQ_SLAVE.MSGS_SENT_CUR |
|
Idle % (PERCENT_IDLE) |
Percentage of time the query server was idle#2 |
AVG |
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#1 |
COPY |
time_t |
No |
All |
Agent Collector |
|
Record Type (INPUT_RECORD_TYPE) |
Record name (always PIPQ)#1 |
COPY |
string(4) |
No |
All |
Agent Collector |
|
Sessions (SESSIONS) |
Number of sessions in use by the parallel query server#2 |
AVG |
ulong |
Yes |
All |
V$PQ_SLAVE.SESSIONS |
|
Slave Name (SLAVE_NAME) |
Name of the parallel query server#1 |
COPY |
string(4) |
No |
All |
V$PQ_SLAVE.SLAVE_NAME |
|
Start Time (START_TIME) |
Collection start time for the performance data stored in the record#1 |
COPY |
time_t |
No |
All |
Agent Collector |
|
Status (STATUS) |
Status of the parallel query server during data collection. Valid values are BUSY and IDLE.#1 |
COPY |
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#2 |
AVG |
double |
Yes |
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#2 |
AVG |
double |
Yes |
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#2 |
AVG |
double |
Yes |
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#2 |
AVG |
double |
Yes |
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#2 |
AVG |
double |
Yes |
All |
V$PQ_SLAVE.MSGS_SENT_TOTAL |