Technical data

Displaying information from the change log tables................................................................... 4-13

Understanding messages about autorefresh in the support log .............................................. 4-13

Diagnosing autorefresh failure ..................................................................................................... 4-14

Diagnosing autorefresh performance problems......................................................................... 4-15

Using SNMP traps for alerts about autorefresh problems........................................................ 4-15

Optimize Performance for IMDB Cache .......................................................................................... 4-15

Autorefresh not refreshing cache at the specified interval ........................................................... 4-16

Reset autorefresh state.................................................................................................................... 4-17

Recover and reset autorefresh Oracle objects ............................................................................. 4-17

Incremental autorefresh not progressing ......................................................................................... 4-18

Validate autorefresh Oracle objects.............................................................................................. 4-18

Incremental autorefresh becomes full autorefresh......................................................................... 4-19

Detecting when incremental autorefresh becomes full ............................................................. 4-19

Understanding the cache administration user tablespace ........................................................ 4-19

Diagnosing a full cache administration user tablespace ........................................................... 4-20

Monitoring the usage of the cache administration user's tablespace...................................... 4-21

Considerations when the cache administration user's tablespace is full................................ 4-21

Poor autorefresh performance ............................................................................................................ 4-22

Unresponsive or dead TimesTen database degrades autorefresh performance ................... 4-23

Setting cached TimesTen database timeout ........................................................................ 4-23

Configuring recovery method for certain cache groups .................................................... 4-23

Excessive deadlocks, buffer busy and row lock waits during autorefresh cache group refresh....

............................................................................................................................................... 4-26

Abnormally large log and base tables degrade autorefresh performance.............................. 4-27

Performance degrades when autorefresh interval is small....................................................... 4-28

5 Troubleshooting AWT Cache Groups

Unable to start or stop replication agent.............................................................................................. 5-1

Replication does not work...................................................................................................................... 5-2

Using SNMP traps for notification of replication events................................................................. 5-2

Monitoring AWT performance.............................................................................................................. 5-2

Possible causes of poor AWT performance......................................................................................... 5-3

Permanent Oracle errors reported by TimesTen................................................................................ 5-3

Transient Oracle errors reported by TimesTen.................................................................................. 5-4

6 Troubleshooting Replication

Unable to create a replication scheme .................................................................................................. 6-1

Unable to alter a replication scheme .................................................................................................... 6-2

Unable to start or stop replication agent.............................................................................................. 6-2

Using SNMP traps for notification of replication events................................................................. 6-3

Replication does not work...................................................................................................................... 6-3

Check status of TimesTen daemon and replication agents.......................................................... 6-3

Check that replication agents are communicating........................................................................ 6-5

Check replication state ...................................................................................................................... 6-5

Check replication scheme configuration ........................................................................................ 6-6

Check ttRepAdmin -showconfig .............................................................................................. 6-6

Check the TTREP.TTSTORES table.......................................................................................... 6-7