DBA Data[Home] [Help] [Dependency Information]


VIEW: SYS.GV_$PROCESS

Object Details
Object Name: GV_$PROCESS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INST_ID NUMBER

ADDR RAW (8)
PID NUMBER

SOSID VARCHAR2 (24)
SPID VARCHAR2 (24)
STID VARCHAR2 (24)
EXECUTION_TYPE VARCHAR2 (10)
PNAME VARCHAR2 (5)
USERNAME VARCHAR2 (15)
SERIAL# NUMBER

TERMINAL VARCHAR2 (30)
PROGRAM VARCHAR2 (48)
TRACEID VARCHAR2 (255)
TRACEFILE VARCHAR2 (513)
BACKGROUND VARCHAR2 (1)
LATCHWAIT VARCHAR2 (16)
LATCHSPIN VARCHAR2 (16)
PGA_USED_MEM NUMBER

PGA_ALLOC_MEM NUMBER

PGA_FREEABLE_MEM NUMBER

PGA_MAX_MEM NUMBER

CON_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INST_ID
,      ADDR
,      PID
,      SOSID
,      SPID
,      STID
,      EXECUTION_TYPE
,      PNAME
,      USERNAME
,      SERIAL#
,      TERMINAL
,      PROGRAM
,      TRACEID
,      TRACEFILE
,      BACKGROUND
,      LATCHWAIT
,      LATCHSPIN
,      PGA_USED_MEM
,      PGA_ALLOC_MEM
,      PGA_FREEABLE_MEM
,      PGA_MAX_MEM
,      CON_ID
FROM SYS.GV_$PROCESS;

Dependencies

[top of page]

SYS.GV_$PROCESS references the following:

SYS.GV_$PROCESS is referenced by following:

SchemaPUBLIC
SynonymGV$PROCESS