Technical data

Monitoring autorefresh cache groups
Troubleshooting Oracle In-Memory Database Cache 4-11
■ Displaying information from the change log tables
■ Understanding messages about autorefresh in the support log
■ Diagnosing autorefresh failure
■ Diagnosing autorefresh performance problems
■ Using SNMP traps for alerts about autorefresh problems
Using the ttCacheAutorefreshStatsGet procedure
The ttCacheAutorefreshStatsGet procedure returns information about the last
ten autorefresh operations on a specified cache group.
The ttCacheAutorefreshStatsGet procedure returns information only when the
cache agent is running and the autorefresh state is ON or PAUSED. All of the return
fields are set to 0 when the cache agent is restarted or the autorefresh state is changed
to OFF.
Example 4–2 Calling ttCacheAutorefreshStatsGet
This example uses testcache, which is a READONLY cache group with one table
and an incremental autorefresh interval of 10 seconds.
Command> call ttcacheautorefreshstatsget('user1','testcache');
< 1164260, 2007-07-23 15:43:52.000000, 850280, 44, 0, 75464, 528255, 75464, 310, 110, 6800,
1890912, 12439795, 1890912, 160020, InProgress >
< 1164260, 2007-07-23 15:43:33.000000, 831700, 43, 13550, 108544, 759808, 108544, 1030, 230,
12290, 1815448, 11911540, 1815448, 160020, Complete >
< 1164260, 2007-07-23 15:43:12.000000, 810230, 42, 17040, 115712, 809984, 115712, 610, 330,
16090, 1706904, 11151732, 1706904, 146470, Complete >
< 1164260, 2007-07-23 15:42:52.000000, 790190, 41, 14300, 94208, 659456, 94208,560, 320,
13410, 1591192, 10341748, 1591192, 129430, Complete >
< 1164260, 2007-07-23 15:42:32.000000, 770180, 40, 12080, 99328, 695296, 99328,450, 290,
11340, 1496984, 9682292, 1496984, 115130, Complete >
< 1164260, 2007-07-23 15:42:12.000000, 750130, 39, 10380, 86016, 598368, 86016,430, 230,
9720, 1397656, 8986996, 1397656, 103050, Complete >
< 1164260, 2007-07-23 15:41:52.000000, 730130, 38, 13530, 112640, 700768, 112640, 530, 220,
12780, 1311640, 8388628, 1311640, 92670, Complete >
< 1164260, 2007-07-23 15:41:32.000000, 710120, 37, 9370, 56320, 326810, 56320, 310, 160,
8900, 1199000, 7687860, 1199000, 79140, Complete >
< 1164260, 2007-07-23 15:41:22.000000, 700120, 36, 2120, 10240, 50330, 10240, 50, 200, 1870,
1142680, 7361050, 1142680, 69770, Complete >
< 1164260, 2007-07-23 15:41:12.000000, 690110, 35, 0, 0, 0, 0, 0, 0, 0, 1132440, 7310720,
1132440, 67650, Complete >
10 rows found.
Table 4–1 describes the results from the first row of output.
Table 4–1 ttCacheAutorefreshStatsGet results from last autorefresh operation
Result Field name Description
1164260 cgId Cache group ID
2007-07-23
15:43:52.0
00000
startTimestamp Timestamp when autorefresh started for this
interval
850280 cacheAgentUpTime Number of cache agent clock ticks in
milliseconds at the time the autorefresh
transaction started for this interval. This
value is cumulative and is reset when the
cache agent process starts.