ttRepQueryThresholdGet
This procedure returns the number of seconds that was most recently specified as the query threshold for the replication agent. The number of seconds returned may not be the same as the query threshold in effect. Setting a new value for the query threshold takes effect the next time the replication agent is started.
Required Privilege
This procedure requires the ADMIN privilege.
Usage in TimesTen Scaleout and TimesTen Classic
This procedure is supported in TimesTen Classic but not supported in TimesTen Scaleout.Related Views
This procedure has no related views.
Syntax
ttRepQueryThresholdGet()
Parameters
ttRepQueryThresholdGet has no parameters.
Result Set
ttRepQueryThresholdGet returns the result:
| Column | Type | Description |
|---|---|---|
|
|
|
The number of seconds that a replication query executes before returning an error. |
Examples
To get the replication query threshold value, use:
CALL ttRepQueryThresholdGet (); < 4 > 1 row found.
See Also
- ttRepDeactivate
- ttReplicationStatus
- ttRepPolicyGet
- ttRepQueryThresholdSet
- ttRepStart
- ttRepStop
- ttRepSubscriberStateSet
- ttRepSubscriberWait
- ttRepSyncGet
- ttRepSyncSet
- ttRepTransmitSet
- ttRepDuplicateEx in Oracle TimesTen In-Memory Database C Developer's Guide