ttCacheADGStandbyTimeoutGet
Retrieve the timeout specified with the ttCacheADGStandbyTimeoutSet built-in procedure.
Required Privilege
This procedure requires no privileges.
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.