Display AWT Performance Results with the ttRepAdmin Utility
Use the ttRepAdmin utility with the -awtmoninfo and -showstatus commands to display the monitoring results. The AWT monitoring statistics include the following:
-
TimesTen processing time: The total number of milliseconds spent in processing AWT transaction data since monitoring was enabled.
-
Oracle Database bookmark management time: The total number of milliseconds spent in managing AWT metadata on Oracle Database since monitoring was enabled.
-
Oracle Database execute time: The total number of milliseconds spent in OCI preparation, binding and execution for AWT SQL operations since monitoring was enabled. This statistic includes network latency between TimesTen and Oracle Database.
-
Oracle Database commit time: The total number of milliseconds spent in committing AWT updates on Oracle Database since monitoring was enabled. This statistic includes network latency between TimesTen and Oracle Database.
-
Time since monitoring was started.
-
Total number of TimesTen row operations: The total number of rows updated in AWT cache groups since monitoring was enabled.
-
Total number of TimesTen transactions: The total number of transactions in AWT cache groups since monitoring was enabled.
-
Total number of flushes to the Oracle database: The total number of times that TimesTen data has been sent to the Oracle database.
-
The percentage of time spent on TimesTen processing, Oracle Database bookmark management, Oracle Database execution and Oracle Database commits.
For example:
ttRepAdmin -showstatus -awtmoninfo myDSN
[other -showstatus output]
...
AWT Monitoring statistics
-------------------------
TimesTen processing time : 8443.424000 millisecs (44.064958 )
Oracle execute (SQL execution) time : 8930.320000 millisecs (46.605994 )
Oracle execute (PL/SQL execution) time : 0.000000 millisecs (0 )
Oracle commit time : 1787.568000 millisecs (9.329048 )
Time since monitoring was started: 21954.410000 millisecs
CacheAwtMethod mode : 0
Cache-connect Operational Stats :
SQL Operations sent to Oracle : 143556
Number of update operations : 58
Number of update batches : 58
Number of insert operations : 143498
Number of insert batches : 1146
Number of delete operations : 0
Number of delete batches : 0
Total number of batches sent: 1204
Number of bytes sent : 4769094
Number of TimesTen Transactions sent to Oracle (includes retries) :
143556
Number of retries on TimesTen due to errors on Oracle : 0
Number of round trips to Oracle (includes executes, commits and
rollbacks) : 2290
Number of commits on Oracle : 1086
Number of rollbacks on Oracle : 0
Number of rxbatches: 244
Number of rxskips: 0
Peer name Host name Port State Proto
---------------- ------------------------ ------ ------- -----
_ORACLE MYHOST Auto Start 27
Last Msg Sent Last Msg Recv Latency TPS RecordsPS Logs
------------- ------------- ------- ------- --------- ----
00:00:00 - 2.35 6311 6311 1