SESSIONS
The SYSINFO.SESSIONS system table describes the connection between an application and a database task.
|
SESSIONID |
FIXED(10) |
Identification of the database session |
|
OWN |
CHAR(3) |
Current database session (YES | NO) |
|
SESSIONTYPE |
CHAR(4) |
OLTP: OLTP database LVC: Database with SAP liveCache technology |
|
ENCRYPTION |
CHAR(3) |
Specifies whether SSL is used for data encryption (SSL | NO) SSL: Data encryption using SSL NO: No data encryption using SSL |
|
STARTDATE |
TIMESTAMP |
Start time of database session |
|
APPLICATIONNODE |
CHAR(64) |
Name of the computer on which the application is running |
|
APPLICATIONPROCESS |
FIXED(10) |
Operating system ID of the application |
|
APPLICATIONTYPE |
CHAR(3) |
Identification of the tool or interface that the application is using |
|
USERNAME |
CHAR(32) |
Name of the database user |
|
IDENTIFICATIONTYPE |
CHAR(8) |
Type of identification (LOCAL | EXTERNAL) LOCAL: Internal identification EXTERNAL: External identification |
|
AUTHENTICATIONMETHOD |
CHAR(8) |
Authentication method (PASSWORD | OS | GSSAPI | KERBEROS) |
|
AUTHENTICATIONMECHANISM |
CHAR(32) |
OID of authentication mechanism |
|
AUTHENTICATEDIDENTITY |
CHAR(32) |
Name of the authenticated identity |
|
PEERPROCESSID |
FIXED(10) |
Identification of the communication partner of the database task |
|
CONNECTSTATE |
CHAR(32) |
Connection status |
|
TASKID |
FIXED(10) |
Identification of the database task |
|
OMSHEAPUSEDSIZE |
FIXED(20) |
Memory consumption in the OMS heap (KB) |
|
TRACE |
CHAR(3) |
A database trace is written for this database session/all database sessions (YES|NO) |
|
CATALOGCACHEUSEDSIZE |
FIXED(10) |
Space used by the catalog cache assigned to the database session (KB) |
|
USEDTEMPORARY SIZE |
FIXED(10) |
Space used for temporary information from your database session (KB) |
|
PAGINGFILEUSEDSIZE |
FIXED(10) |
Size of the paging file in which information displaced from the catalog cache is written (KB) |
|
SQLMODE |
CHAR(8) |
SQL mode of your database session (INTERNAL | ORACLE) |
|
ISOLATIONLEVEL |
FIXED(3) |
Isolation level of your database session (0-3) |
|
TIMEOUT |
FIXED(10) |
Timeout value for your database session |
|
DATEFORMAT |
CHAR(50) |
Date and time format for your database session |
|
DEFAULTCODE |
CHAR(8) |
Default value for the code attribute of the database session |
|
IOPRIORITY |
CHAR(6) |
Priority of I/O (LOW | MEDIUM) |
|
CURRENTSCHEMANAME |
CHAR(32) |
Name of the current schema of the database session |
|
CURRENTCOMMANDID |
CHAR(8) BYTE |
Identification of the currently executed SQL statement |
Evaluating System Tables, SESSIONS
Documentation Concept of the Database System