Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

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 | 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