Use Metrics to Evaluate Performance

Performance impact: Variable

You can use the ttStats utility to collect and display database metrics.

The ttStats utility can perform the following functions.

• Monitor and display database performance metrics in real-time, calculating rates of change during each preceding interval.

• Collect and store snapshots of metrics to the database then produce reports with values and rates of change from specified pairs of snapshots. (These functions are performed through calls to the TT_STATS PL/SQL package.)

The ttStats utility gathers metrics from TimesTen system tables, views, and built-in procedures. In reports, this includes information such as a summary of memory usage, connections, and load profile, followed by metrics (as applicable) for SQL statements, transactions, PL/SQL memory, replication, logs and log holds, checkpoints, cache groups, latches, locks, XLA, and TimesTen connection attributes.

Call the ttStatsConfig built-in procedure to modify statistics collection parameters that affect the ttStatus utility. See ttStatsConfig in the Oracle TimesTen In-Memory Database Reference.

See TT_STATS in the Oracle TimesTen In-Memory Database PL/SQL Packages Reference.