Show TOC

Object documentationSESSIONS Locate this document in the navigation structure

 

The SYSINFO.SESSIONS system table describes the connection between an application and a database task.

Structure

SESSIONS

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)

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 (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

CURRENTSCHEMANAME

CHAR(32)

Name of the current schema of the database session

CURRENTCOMMANDID

CHAR(8) BYTE

Identification of the currently executed SQL statement

More Information

Evaluating System Tables, SESSIONS

Documentation Concept of the Database System

Glossary, OMS Heap, SSL/TLS