TT_STATS

The TT_STATS package provides features for collecting and comparing snapshots of TimesTen system metrics, according to the capture level. Each snapshot can consist of what TimesTen considers to be basic metrics, typical metrics, or all available metrics.

For those familiar with Oracle Database performance analysis tools, these reports are similar in nature to Oracle Automatic Workload Repository (AWR) reports.

Table 7-9 TT_STATS Subprograms

Subprogram	Description
CAPTURE_SNAPSHOT procedure and function	Takes a snapshot of TimesTen metrics. The function also returns the snapshot ID.
DROP_SNAPSHOTS_RANGE function	Deletes snapshots according to a specified range of snapshot IDs or timestamps.
GENERATE_REPORT_HTML procedure	Produces a report in HTML format based on the data from two specified snapshots.
GENERATE_REPORT_TEXT procedure	Produces a report in plain text format based on the data from two specified snapshots.
GET_CONFIG function	Retrieves the value of a specified TT_STATS configuration parameter or the values of all configuration parameters.
SET_CONFIG procedure	Sets a specified value for a specified TT_STATS configuration parameter.
SHOW_SNAPSHOTS function	Shows the snapshot IDs and timestamps of all snapshots currently stored in the database.