Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

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

Go to previous page
Go to next page
View PDF


This view lists session statistics for parallel queries. 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.

Column Datatype Description
STATISTIC VARCHAR2(30) Name of the statistic:
  • Queries Parallelized - Number of queries run in parallel

  • DDL Parallelized - Number of DDL operations run in parallel

  • DML Parallelized - Number of DML operations run in parallel

  • DFO Trees - Number of executed DFO trees

  • Server Threads - Total number of cluster databases 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 Value of the statistic for the last operation
SESSION_TOTAL NUMBER Value of the statistic for the entire session to this point in time