Timeout Value 

The timeout value defines the maximum period of inactivity during a database session. The inactivity period is the time interval between the completion of an SQL statement and the next SQL statement. The database session is terminated with a ROLLBACK WORK RELEASE when the specified maximum inactivity period is exceeded.

Timeout values are specified in seconds.

Setting the Timeout Value

You set the timeout value with a database parameter and, if necessary, SQL statements.

·        The default timeout value for all users is set with the database parameter SESSION_TIMEOUT.

·        You can use a CREATE USER statement or an ALTER USER statement to define a user-specific timeout value.

·        You can use a CREATE USERGROUP statement or an ALTER USERGROUP statement to define a timeout value for a group of users. If a user belongs to a user group that has a timeout value, then this value is also the user-specific timeout value.

·        When a user connects to the database instance, the current timeout value is determined:
If the user-specific timeout value is larger than the timeout value defined with SESSION_TIMEOUT, or if there is no user-specific timeout value, then the current timeout value is the one defined in SESSION_TIMEOUT. Otherwise, the current timeout value is the user-specific timeout value.

·        You can specify a timeout value when you connect to the database instance (CONNECT statement). This timeout value must be less than or equal to the current timeout value.
If you do not specify a timeout value, then the current timeout value that the system has determined is valid.