Specifying Timeouts resource limits

Idle Query Timeouts and Server Response Timeouts resource limits can be set for both data sources and for individual queries. The Idle Connection Timeouts resource limit can only be set for data sources and not for individual queries. The Timeouts resource limits are as follows:

Idle Query Timeouts

These fields specify the amount of time that a query can remain idle. The Warning limit field displays the number of seconds that a query can remain idle before the user is informed and asked if the query should be canceled. The Cancel limit field displays the number of seconds that a query can remain idle before the query is automatically canceled.

Server Response Timeouts

These fields specify the amount of time that can be spent waiting for a response from the database. The Warning limit field specifies the number of seconds that can elapse before the user is informed and asked if the database request should be canceled. The Cancel limit field specifies the number of seconds that can elapse before the database request is automatically canceled.

Note: A lower timeout limit prevents long running, runaway queries. A higher timeout limit allows database requests to complete when the database server is slow due to resource contention or other reasons.

Idle Connection Timeouts

This field specifies the amount of time that an idle connection to a database data source is retained. The Cancel limit field specifies the number of seconds that an idle connection is retained before it is automatically closed.

Note: A lower timeout limit minimizes the resources consumed at the database by idle connections. A higher timeout limit minimizes the overhead of establishing connections.