ttCacheAWTMonitorConfig

This procedure enables monitoring to determine the amount of time spent in each component of the workflow of an AWT cache group.

To display the monitoring results, use the ttRepAdmin utility with the -awtmoninfo and -showstatus commands.

If the replication agent is restarted, monitoring is turned off. Setting the monitoring state to OFF resets the internal counters of the monitoring tool.

Run this procedure on the replication node that is replicating AWT changes to the Oracle database. If the active standby pair is functioning properly, the node replicating AWT changes is the standby. If the active is operating standalone, the node replicating AWT changes is the active.

If a failure occurs on the node where the active database resides, the standby node becomes the new active node. In that case you would run this procedure on the new active node.

Required Privilege

This procedure requires the CACHE_MANAGER 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

ttCacheAWTMonitorConfig (['state'], [samplingRate])

Parameters

ttCacheAWTMonitorConfig has the optional parameters:

Parameter	Type	Description
`state`	`TT_CHAR(10)`	Enables and disables AWT monitoring. Its value can be `ON` or `OFF`. Default is `OFF`
`samplingRate`	`TT_INTEGER`	Positive integer that specifies the frequency with which the AWT workflow is sampled. If `samplingRate` is set to `1`, every AWT operation is monitored. Greater values indicate less frequent sampling. The value recommended for accuracy and performance is `16`. If `state` is set to `ON`, the default for `samplingRate` is 16. If state is set to `OFF`, the default for `samplingRate` is `0`.

Result Set

ttCacheAWTMonitorConfig returns the following result if you do not specify any parameters. It returns an error if the replication agent is not running or if an AWT cache group has not been created.

Column	Type	Description
`state`	`TTVARCHAR (10) NOT NULL`	Current state of AWT monitoring. The value can be `ON` or `OFF`.
`AWTSamplingFactor`	`TT_INTEGER NOT NULL`	Positive integer that specifies the frequency with which the AWT workflow is sampled.

Examples

Retrieve the current state and sampling factor when monitoring is disabled.

Command> CALL ttCacheAWTMonitorConfig;
< OFF, 0 >
1 row found.

Enable monitoring and set the sampling frequency to 16.

Command> CALL ttCacheAWTMonitorConfig ('ON', 16);
< ON, 16 >
1 row found.

Disable monitoring.

Command> CALL ttCacheAWTMonitorConfig; ('OFF')
< OFF, 0 >
1 row found.