skip to main content
Using the Driver : Using Catalog Tables : SYSTEM_SESSIONINFO Catalog Table
  

Try DataDirect Drivers Now

SYSTEM_SESSIONINFO Catalog Table

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 4. 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.