Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 124 of 211


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 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback