SET SESSION IDLESESSIONTIMEOUT

Sets the maximum amount of time that a session can remain idle before it exits.

Note: An idle session has no queries running.

Syntax

SET SESSION IDLESESSIONTIMEOUT duration

Parameters

duration

Specifies the amount of time a session can remain idle before it exits:

  • NONE (default): No idle timeout set on the session.
  • 'interval': Specifies as an interval the maximum amount of time a session can remain idle.
  • =DEFAULT: Sets the idle timeout period for this session to the user's IDLESESSIONTIMEOUT value.

Privileges

Examples

See Managing Client Connections in the Administrator's Guide.