ttCacheADGStandbyTimeoutSet
ttCacheADGStandbyTimeoutSet
built-in procedure to designate how long to wait for a response from the standby Oracle database in an Active Data Guard configuration. If the standby Oracle database does not respond after this period, then the state of the standby Oracle database is automatically changed to FAILED
and the cache agent facilitates autorefresh using only the primary Oracle database.
Note:
At any time, the user can restore the standby Active Data Guard state by running the ttCacheADGStandbyStateSet
built-in procedure and set the state to OK
.
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
ttCacheADGStandbyTimeoutSet(timeout)
Parameters
ttCacheADGStandbyTimeoutSet
has the parameters:
Parameter | Type | Description |
---|---|---|
|
|
A timeout specified in seconds on how long to wait for the standby Oracle database to respond before using only the primary Oracle database to autorefresh the cache groups. Default is 0, which indicates that no timeout is used and the state of the standby Oracle database does not change from |
Result Set
ttCacheADGStandbyTimeoutSet
returns no results.
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.