TTC_Timeout
The TTC_Timeout attribute sets a maximum time limit, in seconds, for a network operation that is completed by using the TimesTen client and server. The TTC_Timeout attribute also determines the maximum number of seconds a TimesTen client application waits for the result from the corresponding TimesTen server process before timing out. For example, if the Client application is running long queries, you may want to increase the timeout interval.
The operating systemselect() call on the client side of a client/server connection uses the value of TTC_Timeout. The SQLExecute() and OCIStmtExecute() functions do not.
A value of 0 indicates that client/server operations should not timeout. If this attribute is not set, the default timeout period is 60 seconds. The maximum timeout period is 99,999 seconds. Upon timeout, the operation is interrupted, the Client application receives a timeout error and the connection is terminated and socket closed (without a call to SQLDisconnect).
For active standby pair failover scenarios, the minimum value is 60 seconds.
The timeout value can be set after establishing a connection by calling the ttIsql clienttimeout command. When the query timeout is set after establishing a connection to the database, the client driver returns an error if the network timeout value is greater than 0, and the query timeout value greater than or equal to the network timeout value. The SQLState is set to S1000.
This attribute is not supported (the setting ignored) when shared memory is used for client/server inter-process communication.
See Choose SQL and PL/SQL Timeout Values in Oracle TimesTen In-Memory Database Operations
Guide for information about the relationship between TTC_Timeout, SQLQueryTimeout, and PLSQL_TIMEOUT.
TTC_Timeout can be overridden for connect and disconnect requests by TTC_ConnectTimeout and for all other SQL execution requests by TTC_SqlTimeoutMS (at millisecond level). See TTC_ConnectTimeout and TTC_SqlTimeoutMS.
The SQLQueryTimeout/SQLQueryTimeoutMsec value should be less than the TransactionTimeout value; the TransactionTimeout value should be less than the TTC_Timeout value.
Required Privilege
No privilege is required to change the value of this attribute.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in both TimesTen Classic and TimesTen Scaleout.Setting
Set TTC_Timeout as follows.
| Where to set the attribute | How the attribute is represented | Setting |
|---|---|---|
|
C or Java programs or UNIX and Linux systems |
|
A value between 0 and 99999 that represents the number of seconds that the TimesTen client waits for an operation to complete before timing out. (The default value is |
|
Windows ODBC Data Source Administrator |
Network Timeout field on the Oracle TimesTen Client DSN Setup dialog. |
A value between 0 and 99999 that represents the number of seconds that the TimesTen client waits for an operation to complete before timing out. (The default value is |