The timeout value determines the maximum duration of inactivity in a database session. The duration of inactivity is the time interval between ending an SQL statement and sending the next SQL statement. As soon as the specified timeout value is exceeded, the database session is closed implicitly using a ROLLBACK.
You can configure the timeout value in the following way:
· The special database parameter SESSION_TIMEOUT presets the timeout value for all users in the database instance.
· A CREATE USER statement or an ALTER USER statement specifies a special timeout value for a single user.
A CREATE USERGROUP statement or an ALTER USERGROUP statement specifies a special timeout value for a single user group.
· When you log on to a database instance, you can enter a lower timeout value as an option.
The timeout value is entered in seconds. The timeout value for the current database session is always the lowest value entered in this way.
See also:
Concepts of the Database System, Special Database Parameters
Reference Manual, Authorization