Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

Dynamic Performance (V$) Views, 105 of 179


V$PQ_SESSTAT

This view lists session 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_SESSTAT to view the number of slave processes used, and other information for the session and system. 

 

 

Name of the statistic:

  • Queries Parallelized: Number of queries run in parallel

  • DML Parallelized: Number of DML operations run in parallel

  • DFO Trees: Number of executed DFO trees

  • Server Threads: Total number of parallel servers used

  • Allocation Height: Requested number of servers per instance

  • Allocation Width: Requested number of instances

  • Local Msgs Sent: Number of local (intra-instance) messages sent

  • Distr Msgs Sent: Number of remote (inter-instance) messages sent

  • Local Msgs Recv'd: Number of local (intra-instance) messages received

  • Distr Msgs Recv'd: Number of remote (inter-instance) messages received

 

LAST_QUERY 

NUMBER 

The value of the statistic for the last operation 

SESSION_TOTAL 

NUMBER 

The value of the statistic for the entire session to this point in time 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index