Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Presentations

Diagnostics

Internals

Acknowledgements

Fixed View: X$HS_SESSION

Versions

Oracle Version X$ Version
10.1.0.3.0 1
10.2.0.1.0 1
11.1.0.6.0 1

Columns

Version 1

Column Name Data Type
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
AGENT_ID NUMBER
MACHINE VARCHAR2(64)
PROCESS VARCHAR2(9)
PROGRAM VARCHAR2(48)
OSUSER VARCHAR2(30)
AGT_STARTTIME DATE
AGENT_TYPE NUMBER
FDS_CLASS_ID NUMBER
FDS_INST_ID NUMBER
HS_SESSION_ID NUMBER
SID NUMBER
DB_LINK VARCHAR2(128)
DB_LINK_OWNER NUMBER
SES_STARTTIME DATE

Indexes

Version 1

Version 1 of this fixed view does not have any indexes