Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

Dynamic Performance (V$) Views, 113 of 179


V$PX_PROCESS

This view contains information about the sessions running parallel execution.

Column  Datatype  Description 

SERVER_NAME 

VARCHAR2(4) 

The name of the parallel server (P000, P001, etc) 

STATUS 

VARCHAR2(9) 

The state of the parallel server. Either In Use or Available 

PID 

NUMBER 

The process identifier 

SPID 

VARCHAR2(9) 

The OS process ID 

SID 

NUMBER 

The session ID of slave, if in use 

SERIAL# 

NUMBER 

The session serial number of slave, if in use 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index