The system table named SYSTEM_SESSIONS stores information about current system sessions. The values in the SYSTEM_SESSIONS table are read-only.

The following table defines the columns of the SYSTEM_SESSIONS table.

Table 1. SYSTEM_SESSIONS catalog table
Column Data Type Description
SESSION_ID INTEGER, NOT NULL A unique ID that identifies this session. The system function CURSESSIONID( ) returns the session ID associated with the connection. See Supported scalar functions for more information about the CURSESSIONID() system function.
CONNECTED DATETIME, NOT NULL The date and time the session was established.
USERNAME VARCHAR (128), NOT NULL The name of the schema map that the session is using.
IS_ADMIN BOOLEAN For internal use only.
AUTOCOMMIT BOOLEAN, NOT NULL For future use.
READONLY BOOLEAN, NOT NULL The value for READONLY is True.
MAX_ROWS INTEGER, NOT NULL For future use.
LAST_IDENTITY BIGINT, NULLABLE For future use.
TRANSACTION_SIZE INTEGER, NOT NULL For future use.
CURRENT_SCHEMA VARCHAR (128), NOT NULL The current schema for the session. The current schema may be changed using the ALTER SESSION SET CURRENT_SCHEMA statement.
STMT_CALL_LIMIT INTEGER, NOT NULL The maximum number of Web service calls that the driver uses in attempting to execute a query to a remote data source. The statement call limit for the session may be changed via the ALTER SESSION SET STMT_CALL_LIMIT statement.