eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.GV_$SESSION

Object Details

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

[View Source]

Columns

Name	Datatype	Length
INST_ID	NUMBER
SADDR	RAW	(8)
SID	NUMBER
SERIAL#	NUMBER
AUDSID	NUMBER
PADDR	RAW	(8)
USER#	NUMBER
USERNAME	VARCHAR2	(30)
COMMAND	NUMBER
OWNERID	NUMBER
TADDR	VARCHAR2	(16)
LOCKWAIT	VARCHAR2	(16)
STATUS	VARCHAR2	(8)
SERVER	VARCHAR2	(9)
SCHEMA#	NUMBER
SCHEMANAME	VARCHAR2	(30)
OSUSER	VARCHAR2	(30)
PROCESS	VARCHAR2	(24)
MACHINE	VARCHAR2	(64)
PORT	NUMBER
TERMINAL	VARCHAR2	(30)
PROGRAM	VARCHAR2	(48)
TYPE	VARCHAR2	(10)
SQL_ADDRESS	RAW	(8)
SQL_HASH_VALUE	NUMBER
SQL_ID	VARCHAR2	(13)
SQL_CHILD_NUMBER	NUMBER
SQL_EXEC_START	DATE
SQL_EXEC_ID	NUMBER
PREV_SQL_ADDR	RAW	(8)
PREV_HASH_VALUE	NUMBER
PREV_SQL_ID	VARCHAR2	(13)
PREV_CHILD_NUMBER	NUMBER
PREV_EXEC_START	DATE
PREV_EXEC_ID	NUMBER
PLSQL_ENTRY_OBJECT_ID	NUMBER
PLSQL_ENTRY_SUBPROGRAM_ID	NUMBER
PLSQL_OBJECT_ID	NUMBER
PLSQL_SUBPROGRAM_ID	NUMBER
MODULE	VARCHAR2	(64)
MODULE_HASH	NUMBER
ACTION	VARCHAR2	(64)
ACTION_HASH	NUMBER
CLIENT_INFO	VARCHAR2	(64)
FIXED_TABLE_SEQUENCE	NUMBER
ROW_WAIT_OBJ#	NUMBER
ROW_WAIT_FILE#	NUMBER
ROW_WAIT_BLOCK#	NUMBER
ROW_WAIT_ROW#	NUMBER
TOP_LEVEL_CALL#	NUMBER
LOGON_TIME	DATE
LAST_CALL_ET	NUMBER
PDML_ENABLED	VARCHAR2	(3)
FAILOVER_TYPE	VARCHAR2	(13)
FAILOVER_METHOD	VARCHAR2	(10)
FAILED_OVER	VARCHAR2	(3)
RESOURCE_CONSUMER_GROUP	VARCHAR2	(32)
PDML_STATUS	VARCHAR2	(8)
PDDL_STATUS	VARCHAR2	(8)
PQ_STATUS	VARCHAR2	(8)
CURRENT_QUEUE_DURATION	NUMBER
CLIENT_IDENTIFIER	VARCHAR2	(64)
BLOCKING_SESSION_STATUS	VARCHAR2	(11)
BLOCKING_INSTANCE	NUMBER
BLOCKING_SESSION	NUMBER
FINAL_BLOCKING_SESSION_STATUS	VARCHAR2	(11)
FINAL_BLOCKING_INSTANCE	NUMBER
FINAL_BLOCKING_SESSION	NUMBER
SEQ#	NUMBER
EVENT#	NUMBER
EVENT	VARCHAR2	(64)
P1TEXT	VARCHAR2	(64)
P1	NUMBER
P1RAW	RAW	(8)
P2TEXT	VARCHAR2	(64)
P2	NUMBER
P2RAW	RAW	(8)
P3TEXT	VARCHAR2	(64)
P3	NUMBER
P3RAW	RAW	(8)
WAIT_CLASS_ID	NUMBER
WAIT_CLASS#	NUMBER
WAIT_CLASS	VARCHAR2	(64)
WAIT_TIME	NUMBER
SECONDS_IN_WAIT	NUMBER
STATE	VARCHAR2	(19)
WAIT_TIME_MICRO	NUMBER
TIME_REMAINING_MICRO	NUMBER
TIME_SINCE_LAST_WAIT_MICRO	NUMBER
SERVICE_NAME	VARCHAR2	(64)
SQL_TRACE	VARCHAR2	(8)
SQL_TRACE_WAITS	VARCHAR2	(5)
SQL_TRACE_BINDS	VARCHAR2	(5)
SQL_TRACE_PLAN_STATS	VARCHAR2	(10)
SESSION_EDITION_ID	NUMBER
CREATOR_ADDR	RAW	(8)
CREATOR_SERIAL#	NUMBER
ECID	VARCHAR2	(64)
SQL_TRANSLATION_PROFILE_ID	NUMBER
PGA_TUNABLE_MEM	NUMBER
CON_ID	NUMBER
EXTERNAL_NAME	VARCHAR2	(1024)

Query Text

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


SELECT INST_ID
,      SADDR
,      SID
,      SERIAL#
,      AUDSID
,      PADDR
,      USER#
,      USERNAME
,      COMMAND
,      OWNERID
,      TADDR
,      LOCKWAIT
,      STATUS
,      SERVER
,      SCHEMA#
,      SCHEMANAME
,      OSUSER
,      PROCESS
,      MACHINE
,      PORT
,      TERMINAL
,      PROGRAM
,      TYPE
,      SQL_ADDRESS
,      SQL_HASH_VALUE
,      SQL_ID
,      SQL_CHILD_NUMBER
,      SQL_EXEC_START
,      SQL_EXEC_ID
,      PREV_SQL_ADDR
,      PREV_HASH_VALUE
,      PREV_SQL_ID
,      PREV_CHILD_NUMBER
,      PREV_EXEC_START
,      PREV_EXEC_ID
,      PLSQL_ENTRY_OBJECT_ID
,      PLSQL_ENTRY_SUBPROGRAM_ID
,      PLSQL_OBJECT_ID
,      PLSQL_SUBPROGRAM_ID
,      MODULE
,      MODULE_HASH
,      ACTION
,      ACTION_HASH
,      CLIENT_INFO
,      FIXED_TABLE_SEQUENCE
,      ROW_WAIT_OBJ#
,      ROW_WAIT_FILE#
,      ROW_WAIT_BLOCK#
,      ROW_WAIT_ROW#
,      TOP_LEVEL_CALL#
,      LOGON_TIME
,      LAST_CALL_ET
,      PDML_ENABLED
,      FAILOVER_TYPE
,      FAILOVER_METHOD
,      FAILED_OVER
,      RESOURCE_CONSUMER_GROUP
,      PDML_STATUS
,      PDDL_STATUS
,      PQ_STATUS
,      CURRENT_QUEUE_DURATION
,      CLIENT_IDENTIFIER
,      BLOCKING_SESSION_STATUS
,      BLOCKING_INSTANCE
,      BLOCKING_SESSION
,      FINAL_BLOCKING_SESSION_STATUS
,      FINAL_BLOCKING_INSTANCE
,      FINAL_BLOCKING_SESSION
,      SEQ#
,      EVENT#
,      EVENT
,      P1TEXT
,      P1
,      P1RAW
,      P2TEXT
,      P2
,      P2RAW
,      P3TEXT
,      P3
,      P3RAW
,      WAIT_CLASS_ID
,      WAIT_CLASS#
,      WAIT_CLASS
,      WAIT_TIME
,      SECONDS_IN_WAIT
,      STATE
,      WAIT_TIME_MICRO
,      TIME_REMAINING_MICRO
,      TIME_SINCE_LAST_WAIT_MICRO
,      SERVICE_NAME
,      SQL_TRACE
,      SQL_TRACE_WAITS
,      SQL_TRACE_BINDS
,      SQL_TRACE_PLAN_STATS
,      SESSION_EDITION_ID
,      CREATOR_ADDR
,      CREATOR_SERIAL#
,      ECID
,      SQL_TRANSLATION_PROFILE_ID
,      PGA_TUNABLE_MEM
,      CON_ID
,      EXTERNAL_NAME
FROM SYS.GV_$SESSION;

Dependencies

[top of page]

SYS.GV_$SESSION references the following:

SYS.GV_$SESSION is referenced by following:

GSMADMIN_INTERNAL: DBMS_GSM_NOPRIV - show dependent code
PUBLIC: GV$SESSION