The SYSINFO.SESSIONS system table describes the connection between an application and a database task.
SESSIONID |
FIXED(10) |
ID 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) |
ID 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) |
ID of the communication partner of the database task |
CONNECTSTATE |
CHAR(32) |
Connection status |
TASKID |
FIXED(10) |
ID 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) |
USEDTEMPORARYSIZE |
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 (ANSI | DB2 | ORACLE | INTERNAL) |
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 |
CURRENTSCHEMANAME |
CHAR(32) |
Name of the current schema of the database session |