Using the ttTraceMon Utility
Use the ttTraceMon
utility to log various trace information on a number of TimesTen components. Each TimesTen component can be traced at different levels of detail. You can list all of the traceable TimesTen components and their current tracing level by specifying ttTraceMon
with the show
subcommand. See ttTraceMon in the Oracle TimesTen In-Memory Database
Reference for a list of options.
TimesTen tracing severely impacts application performance and consumes a great deal of file system space if trace output is directed to a file. In addition, when using AWT cache groups, you must restart the replication agent when trying to trace the ORACON
component with ttTraceMon
. Use the ttTraceMon
utility only when diagnosing problems. When you are finished, reset tracing to the default values.
This example shows that the levels for most tracing components are set to level 0 (off) for the database1
database. Both the ERR
and DEADLOCK
components are set to 1 for tracing by default. See ERR Tracing for information.
% ttTraceMon -e show database1 AGING ... 0 API ... 0 ASYNCMV ... 0 AUTOREFRESH ... 0 BULKLOAD ... 0 BLK ... 0 CG ... 0 CKPT ... 0 DBG0 ... 0 DBG1 ... 0 DEADLOCK ... 1 DIST ... 0 EE ... 0 ERR ... 1 EXTTBLLOAD ... 0 FLOW ... 0 GRID ... 0 GRIDAS ... 0 HEAP ... 0 INTERRUPT ... 0 IX ... 0 IXGC ... 0 IXHEAP ... 0 LATCH ... 0 LBCU ... 0 LOB ... 0 LOCK ... 0 LOG ... 0 LOGF ... 0 MEM ... 0 ODBC ... 0 OPT ... 0 ORACON ... 0 PLOAD ... 0 PREP ... 0 PT ... 0 REPL ... 0 SM ... 0 SQL ... 0 TEST ... 0 TRACE ... 1 XA ... 0 XACT ... 0 XLA ... 0
The output for most TimesTen components is only of interest to TimesTen Customer Support. However, the output for the SQL
, API
, LOCK
, ERR
, AGING
and AUTOREFRESH
components may be useful to you when you are troubleshooting application problems.
The rest of this section includes the following topics: