Show TOC

TimeoutLocate this document in the navigation structure


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. When 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 SessionTimeout special database parameter to configure the default timeout value for all users of the database.

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

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

Timeout values are specified in seconds.

More Information

Database Administration, Special Database Parameters

SQL Reference Manual, CREATE USER, ALTER USER Statement, CONNECT Statement