ALTER SESSION

ALTER SESSION modifies a Session Parameters in order to change the behavior of the current user session.

ALTER SESSION also allows you to set the values of User Defined Session Variables. These may be set to any VARCHAR literal value.

Syntax

ALTER SESSION SET  [ <session_parameter> | <session variable> ] = [ <literal> | MAX | MIN ]

Example

ALTER SESSION SET "cacheStatements" = FALSE;

See also: ALTER SYSTEM and Configuring SQLstream.