Session Timeouts

Statements for management of timeouts of the current connection.

`SET SESSION IDLE TIMEOUT`

Sets the session idle timeout

Syntax

SET SESSION IDLE TIMEOUT value [<time-unit>]

<time-unit> ::= MINUTE | HOUR | SECOND

Table 1. `SET SESSION IDLE TIMEOUT` Statement Parameters
Parameter	Description
value	The timeout duration expressed in time-unit.A value of `0` defers to connection idle timeout configured for the database.
time-unit	Time unit of the timeout.Defaults to `MINUTE`.

The SET SESSION IDLE TIMEOUT sets an idle timeout at connection level and takes effect immediately.The statement can run outside transaction control (without an active transaction).

Setting a value larger than configured for the database is allowed, but is effectively ignored, see also [fblangref50-management-session-timeout-effective].

The current timeout set for the session can be retrieved through RDB$GET_CONTEXT, namespace SYSTEM and variable SESSION_IDLE_TIMEOUT.Information is also available from MON$ATTACHMENTS:

MON$IDLE_TIMEOUT: Connection-level idle timeout in seconds;0 if timeout is not set.
MON$IDLE_TIMER: Idle timer expiration time;contains NULL if an idle timeout was not set, or if a timer is not running.

Both RDB$GET_CONTEXT('SYSTEM', 'SESSION_IDLE_TIMEOUT') and MON$ATTACHMENTS.MON$IDLE_TIMEOUT report the idle timeout configured for the connection;they do not report the effective idle timeout.

The session idle timeout is reset when [fblangref50-management-session-reset-alter] is executed.