SESSIONS

Definition

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

Structure

SESSIONS

SESSIONID

FIXED(10)

ID of the database session

OWN

CHAR(3)

Current database session (YES | NO)

SESSIONTYPE

CHAR(4)

Specification of the database instance type (OLTP | LVC)

OLTP: database instance type OLTP
LVC: 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

Time at which database session started

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

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

See also:

Evaluating System Tables, SESSIONS

Documentation Concept of the Database System

Glossary, OMS Heap, SSL/TLS