Query Timeout

The length of time, in seconds, that the connector waits for a round-trip call between the client and the server to complete before timing out and returning an error.

A value of 0 or -1 indicates that the round-trip timeout is disabled, and the client-server calls do not time out.

When this option is set to a value from 1 to 2,147,483,647 (both inclusive), the connector specifies the round-trip timeout using the OCI_ATTR_CALL_TIMEOUT attribute. For information about this attribute, see “Service Context Handle Attributes” in the Oracle Call Interface Programmer’s Guide: https://docs.oracle.com/en/database/oracle/oracle-database/19/lnoci/handle-and-descriptor-attributes.html#GUID-CB59C987-07E7-42D4-ADDF-96142CBD3D11.

Note: Be aware that, if you run a large query while round-trip timeout is enabled, your connection might time out.
Key Name Default Value Required

QueryTimeout

0

No