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, 125 of 211


V$PQ_SYSSTAT

This view lists system statistics for parallel queries.

Column  Datatype  Description 

STATISTIC 

VARCHAR2(30) 

The following statistics (fixed rows) have been defined for this view. After you have run a query or DML operation, you can use the information derived from V$PQ_SYSSTAT to view the number of slave processes used, and other information for the system. 

 

 

Name of the statistic:

  • Servers Busy - number of currently busy servers on this instance

  • Servers Idle - number of currently idle servers on this instance

  • Servers Highwater - number of active servers on this instance that have partaken in >= 1 operation so far

  • Server Sessions - total number of operations executed in all servers on this instance

  • Servers Started - total number of servers started on this instance

  • Servers Shutdown - total number of servers shutdown on this instance

  • Servers Cleaned Up - total number of servers on this instance cleaned up due to process death

 

 

 

  • Queries Initiated - total number of parallel queries initiated on this instance

  • DML Initiated - total number of parallel DML operations that were initiated

  • DFO Trees - total number of DFO trees executed on this instance

  • Local Msgs Sent - total number of local (intra-instance) messages sent on this instance

  • Distr Msgs Sent - total number of remote (inter-instance) messages sent on this instance

  • Local Msgs Recv'd - total number of remote (inter-instance) messages received on this instance

  • Distr Msgs Recv'd - total number of remote (inter-instance) messages received on this instance

 

VALUE 

NUMBER 

The value of the statistic 


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