Dynamic Performance (V$) Views, 106 of 179

V$PQ_SLAVE

This view lists statistics for each of the active parallel execution servers on an instance.

Column	Datatype	Description
`SLAVE_NAME`	`VARCHAR2(4)`	Name of the parallel execution server
`STATUS`	`VARCHAR2(4)`	The current status of the parallel execution server (BUSY or IDLE)
`SESSIONS`	`NUMBER`	The number of sessions that have used this parallel execution server
`IDLE_TIME_CUR`	`NUMBER`	The amount of time spent idle while processing statements in the current session
`BUSY_TIME_CUR`	`NUMBER`	The amount of time spent busy while processing statements in the current session
`CPU_SECS_CUR`	`NUMBER`	The amount of CPU time spent on the current session
`MSGS_SENT_CUR`	`NUMBER`	The number of messages sent while processing statements for the current session
`MSGS_RCVD_CUR`	`NUMBER`	The number of messages received while processing statements for the current session
`IDLE_TIME_TOTAL`	`NUMBER`	The total amount of time this query server has been idle
`BUSY_TIME_TOTAL`	`NUMBER`	The total amount of time this query server has been active
`CPU_SECS_TOTAL`	`NUMBER`	The total amount of CPU time this query server has used to process statements
`MSGS_SENT_TOTAL`	`NUMBER`	The total number of messages this query server has sent
`MSGS_RCVD_TOTAL`	`NUMBER`	The total number of messages this query server has received