The system table named SYSTEM_SESSIONINFO describes details about your connection to Oracle Service Cloud.

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 Oracle Service Cloud 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.