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


V$PX_SESSTAT

This view contains information about the sessions running parallel execution.

Column  Datatype  Description 

SADDR 

RAW(4) 

Session address 

SID 

NUMBER 

Session identifier 

SERIAL# 

NUMBER 

Session serial number 

QCSID 

NUMBER 

Session identifier of the parallel coordinator 

QCSERIAL# 

NUMBER 

Session serial number of the parallel coordinator 

QCINST_ID 

NUMBER 

Instance number on which the parallel coordinator is running 

SERVER_GROUP 

NUMBER 

The logical group of servers to which this cluster database process belongs 

SERVER_SET 

NUMBER 

The logical set of servers that this cluster database process belongs to. A single server group will have at most two server sets. 

SERVER# 

NUMBER 

The logical number of the cluster database process within a server set 

DEGREE 

NUMBER 

The degree of parallelism being used by the server set 

REQ_DEGREE 

NUMBER 

The degree of parallelism that was requested by the user when the statement was issued and prior to any resource, multi-user, or load balancing reductions 

STATISTIC# 

NUMBER 

Statistic number (identifier) 

VALUE 

NUMBER 

Statistic value 


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