skip to main content
Using the driver : Catalog Tables : SYSTEM_REMOTE_SESSIONS catalog table
  

Try DataDirect Drivers Now

SYSTEM_REMOTE_SESSIONS catalog table

The system table named SYSTEM_REMOTE_SESSIONS stores information about the each of the remote sessions that are active for a given database. The values in the SYSTEM_REMOTE_SESSION table are read-only.
The following table defines the columns of the SYSTEM_REMOTE_SESSIONS table, which is sorted on the following columns: SESSION_ID and SCHEMA.
Table 8. SYSTEM_REMOTE_SESSIONS catalog table
Column Name
Data Type
Description
SESSION_ID
INTEGER, NOT NULL
The connection (session) id with which the remote session is associated.
SCHEMA
VARCHAR(128), NOT NULL
The schema name that is mapped to the remote session.
TYPE
VARCHAR(30), NOT NULL
The remote session type. The current valid type is OracleSalesCloud .
INSTANCE
VARCHAR(128)
The value for INSTANCE is null.
VERSION
VARCHAR(30), NOT NULL
The version of the remote data source to which the session is connected. This is the version of the web service API the driver is using to connect to Oracle Sales Cloud.
CONFIG_OPTIONS
LONGVARCHAR, NOT NULL
The configuration options used to define the remote data model to relational data model mapping.
SESSION_OPTIONS
LONGVARCHAR, NOT NULL
The options used to establish the remote connection. This typically is information needed to log into the remote data source. The password value is not displayed.
WS_CALL_COUNT
INTEGER, NOT NULL
The number of Web service calls made through this remote session. The value of the WS_CALL_COUNT column can be reset using the ALTER SESSION statement.
WS_AGGREGATE_CALL_COUNT
INTEGER, NOT NULL
The total of all of the web service calls made to the same remote data source by all active connections using the same server name and user ID.
REST_AGGREGATE_CALL_COUNT
INTEGER, NOT NULL
The number of REST calls made by this connection. REST calls are used for bulk operations, invoking reports, and describing report parameters.