The system table named SYSTEM_SESSIONINFO describes details about your connection to Salesforce.

The following table defines the keys for the SYSTEM_SESSIONINFO table. The values change based on your data source settings.
Table 1. SYSTEM_SESSIONINFO Catalog Table
Key Description
AUTOCOMMIT Autocommit is always enabled.
DATABASE The location and the filename prefix for the data mapping and configuration files.
DATABASE_ READONLY Indicates whether the database the session is connected to is read only.
DB_FILE_LOCATION The fully qualified path to the directory or folder that contains the database and mapping files.
DB_FILE_PREFIX The filename prefix of the database and mapping files the driver is using.
IDENTITY Currently always zero.
MAXROWS Currently always zero.
LOG_CONFIG_FILE The fully qualified path to the directory or folder that contains the logging configuration file.
SCHEMA The name of the remote Salesforce schema.
SESSION_ID The ID for this session.
SESSION_READONLY Indicates whether the session is read only.
USER The user that is associated with this session.