QueryThreshold
Use this attribute to write a warning to the daemon log when the execution time of a SQL statement exceeds the specified value.
You cannot set a query threshold for a SQL statement that is executed by the cache agent. The value of QueryThreshold
applies to all connections. It applies to all SQL statements except those executed by the replication agent or the cache agent.
The value of this attribute can be any integer equal to or greater than 0. The default value is 0
. A value of 0
indicates that no warning is issued. The unit is seconds.
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 QueryThreshold
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
A non-negative integer. Default is |
Windows ODBC Data Source Administrator |
Not applicable |