Attribute Name
|
Session Type
|
Description
|
Current_Schema
|
Local
|
Sets the current schema for the local session. The current schema is the schema used when an identifier in a SQL statement is unqualified. The string value must be the name of a schema visible in the local session. For example:
ALTER SESSION SET CURRENT_SCHEMA=AUTOREST
|
Stmt_Call_Limit
|
Local
|
Sets the maximum number of Web service calls the driver can make in executing a statement. It sets the default Web service call limit used by any statement on the connection. Executing this command on a statement overrides the previously set StmtCallLimit for the connection. The value specified must be a positive integer or 0. The value 0 means that no call limit exists. For example:
ALTER SESSION SET STMT_CALL_LIMIT=150
|
Ws_Call_Count
|
Remote
|
Resets the Web service call count of a remote session to the value specified. The value must be 0 or a positive integer. WS_Call_Count represents the total number of Web service calls made to the remote data source instance for the current session. For example:
ALTER SESSION SET autorest.WS_CALL_COUNT=0
The current value of WS_Call_Count can be obtained by referring to the System_Remote_Sessions system table (see SYSTEM_REMOTE_SESSIONS Catalog Table for details). For example:
SELECT * from information_schema.system_remote_sessions WHERE session_id = cursessionid()
|