ttCacheADGStandbyTimeoutGet
Retrieve the timeout specified with the ttCacheADGStandbyTimeoutSet built-in procedure.
Required Privilege
This procedure requires no privileges.
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
ttCacheADGStandbyTimeoutGet()
Parameters
ttCacheADGStandbyTimeoutGet has no parameters.
Result Set
ttCacheADGStandbyTimeoutGet returns the timeout:
| Column | Type | Description |
|---|---|---|
|
|
|
The timeout in seconds on how long to wait for a response from the standby Oracle database in an Active Data Guard configuration before using only the primary Oracle database to autorefresh the cache groups. |
Examples
The following example shows how to use the ttCacheADGStandbyTimeoutSet built-in procedure to set the timeout that indicates the time to wait for a response from the standby Oracle database. And then, it shows how to call the ttCacheADGStandbyTimeoutGet built-in procedure to retrieve the value of the timeout.
Command> call ttCacheADGStandbyTimeoutSet('60');
Command> call ttCacheADGStandbyTimeoutGet();
< 60 >
1 row found.