ttCacheConfig
For all cache groups that cache data from the same Oracle instance, this procedure specifies a timeout value and recovery policies in the case that the Oracle database server is unreachable and the cache agent or database is considered terminated.
The automatic refresh state of the database and cache groups can be determined from the procedure ttCacheDbCgStatus.
Required Privilege
This procedure requires the CACHE_MANAGER
privilege.
Usage in TimesTen Scaleout and TimesTen Classic
This procedure is supported in both TimesTen Classic and TimesTen Scaleout.Related Views
This procedure has no related views.
Syntax
ttCacheConfig(Param, tblOwner, tblName, Value)
Parameters
ttCacheConfig
has these parameters:
Parameter | Type | Description |
---|---|---|
|
VARCHAR2(50) NOT NULL |
Specifies the parameter to be set by
|
|
|
Specifies the owner of the cached Oracle database table. This parameter is required if A synonym cannot be used to specify a table name. |
|
|
Specifies the name of the cached Oracle database table. This parameter is required if Using a synonym to specify a table name is not supported. |
|
|
Specifies the value to be set for
Or Specifies the value to be set by
|
Result Set
ttCacheConfig
returns no results when an application uses it to set parameter values. When it is used to return parameter settings, ttCacheConfig
returns the following results.
Column | Type | Value |
---|---|---|
|
|
Parameter name:
|
|
|
Owner of the cached Oracle database table. |
|
|
Name of the cached Oracle database table. Using a synonym to specify a table name is not supported. |
|
|
Specifies the value set for
|
Examples
To set the cache agent timeout to 600 seconds (10 minutes), enter:
CALL ttCacheConfig('AgentTimeout',,,'600');
To determine the current cache agent timeout setting, enter:
CALL ttCacheConfig('AgentTimeout'); < AgentTimeout, <NULL>, <NULL>, 600 > 1 row found.
To set the recovery method to Manual
for cache groups whose automatic refresh status is dead
, enter:
CALL ttCacheconfig('DeadDbRecovery',,,'Manual');
Configure TimesTen to prevent an automatic full refresh and receive an Oracle database error when there is an update on a cached Oracle database table while the cache administration user's tablespace is full. The Oracle database table is terry.customer
. See Impact of Failed Autorefresh Operations on TimesTen Databases in the Oracle TimesTen In-Memory Database Cache
Guide for details.
CALL ttCacheConfig('TblSpaceFullRecovery','terry','customer','None');
To determine the current setting for TblSpaceFullRecovery
on the terry.customer
cached Oracle database table, enter:
Command> CALL ttCacheConfig('TblSpaceFullRecovery','terry','customer'); < TblSpaceFullRecovery, TERRY, CUSTOMER, none > 1 row found.
To configure a warning to be returned when the cache administration user's tablespace is 85 percent full and an update operation occurs on the cached Oracle database table, enter:
Command> CALL ttCacheConfig('AutoRefreshLogTblSpaceUsagePCT',,,'85');
TimesTen Classic calculates the percentage of fragmentation for the change log tables as a ratio of used space to the total size of the space. If this ratio falls below a defined threshold, TimesTen alerts you of the necessity for defragmentation of the change log tables by logging a message. By default, this threshold is set to 40%. For example, to set the fragmentation threshold to 50%, perform:
Command> CALL ttCacheConfig('AutoRefreshLogFragmentationWarningPCT',,,'50'); < AutoRefreshLogFragmentationWarningPCT, <NULL>, <NULL>, 50 > 1 row found.
To set the time interval to 3600 seconds for when to calculate the fragmentation percentage of the change log tables, perform:
Command> CALL ttCacheConfig('AutorefreshLogMonitorInterval',,,'3600'); < AutorefreshLogMonitorInterval, <NULL>, <NULL>, 3600 > 1 row found.
When working in an Oracle RAC environment, the following shows how to retrieve the value of the failover timeout:
Command> CALL ttCacheConfig('AgentFailoverTimeout'); < AgentFailoverTimeout, <NULL>, <NULL>, 4 > 1 row found.
The following sets the failover timeout to 5 minutes:
Command> CALL ttCacheConfig('AgentFailoverTimeout',,,5); < AgentFailoverTimeout, <NULL>, <NULL>, 5 > 1 row found.
Notes
-
This procedure is available only for cache operations.
-
You must call the
ttCacheConfig
built-in procedure from every node in an active standby pair.
See Also
- ttCacheDbCgStatus
- ttCachePolicyGet
- ttCachePolicySet
- ttCacheStart
- ttCacheStop
- ttCacheUidGet
- ttCacheUidPwdSet
- ttAdmin
- Managing a Caching Environment, Reporting Oracle Database Permanent Errors for AWT Cache Groups, and Setting Up Cache in an Oracle RAC Environment (regarding Agent Failover) in Oracle TimesTen In-Memory Database Cache Guide.