Skip Headers
Oracle® TimesTen In-Memory Database Reference
Release 11.2.1

Part Number E13069-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF



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.

Required privilege

This procedure requires the CACHE_MANAGER privilege.


ttCacheAWTMonitorConfig ('state', samplingFrequency)


ttCacheAWTMonitorConfig has the parameters:

Parameter Type Description
state TT_CHAR(10) Enables and disables AWT monitoring. Its value can be ON or OFF. Default is OFF
samplingFactor TT_INTEGER Positive integer that specifies the frequency with which the AWT workflow is sampled. If samplingFactor 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 samplingFactor is 16. If state is set to OFF, the default for samplingFactor 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.


Example 2-1

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

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

Example 2-2

Enable monitoring and set the sampling frequency to 16.

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

Example 2-3

Disable monitoring.

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

See also