Timeout

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 timeout value is exceeded, the database system ends the database session with a ROLLBACK.

You can configure the timeout value in the following way:

?     You can use the SESSION_TIMEOUT special database parameter to configure the default timeout value for all users of the database instance.

?     You can specify a special timeout value for a single user with a CREATE USER statement or an ALTER USER statement.

You can specify a special timeout value for a user group with a CREATE USERGROUP statement or an ALTER USERGROUP statement.

The database system always uses the smallest of these timeout values for a database session. When you log on to the database instance, you can also select an even smaller timeout value for the duration of the database session.

Enter timeout values in seconds.

See also:

Concepts of the Database System, Special Database Parameters

SQL Reference Manual, Authorization