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


V$PQ_TQSTAT

This view contains statistics on parallel execution operations. The statistics are compiled after the query completes and only remain for the duration of the session. It displays the number of rows processed through each parallel execution server at each stage of the execution tree. This view can help determine skew problems in a query's execution.

Column  Datatype  Description 

DFO_NUMBER 

NUMBER 

The data flow operator (DFO) tree number to differentiate queries 

TQ_ID 

NUMBER 

The table queue ID within the query, which represents the connection between two DFO nodes in the query execution tree 

SERVER_TYPE 

VARCHAR2(10) 

The role in table queue - producer/consumer/ranger 

NUM_ROWS 

NUMBER 

The number of rows produced/consumed 

BYTES 

NUMBER 

The number of bytes produced/consumed 

OPEN_TIME 

NUMBER 

Time (seconds) the table queue remained open 

AVG_LATENCY 

NUMBER 

Time (minutes) for a message to be dequeued after it enters the queue 

WAITS 

NUMBER 

The number of waits encountered during dequeue 

TIMEOUTS 

NUMBER 

The number of timeouts when waiting for a message 

PROCESS 

VARCHAR2(10) 

Process ID 

INSTANCE 

NUMBER 

Instance ID 


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