|
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 RightNow.
|
|
INSTANCE
|
VARCHAR(128)
|
The remote session instance name or null if the remote data source does not have multiple instances.
The Oracle Service Cloud value for INSTANCE has the following form:
Organization_Name
where Organization_Name is the organization name of the Oracle Service Cloud instance to which the connection is established.
|
|
VERSION
|
VARCHAR(30), NOT NULL
|
The version of the remote data source to which the session is connected.
For Oracle Service Cloud, this is the version of the Web Service API the driver is using to connect to Oracle Right Now.
|
|
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 invoking reports, and describing report parameters.
|