SET SESSION IDLESESSIONTIMEOUT

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

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

  • Superusers can increase the time a session can remain idle to any value, regardless of database or node settings.
  • Non-superusers can only set the session idle time to a value equal to or lower than their own user setting. If no session idle time is explicitly set for a user, the session idle time for that user is inherited from the node or database settings.

Examples

See Managing Client Connections in the Administrator's Guide.