Monitoring the TimesTen System Tables

Each TimesTen database contains a group of system tables that store metadata about the current state of the database. The system tables are described in System Tables and Views in the Oracle TimesTen In-Memory Database System Tables and Views Reference.

Note:

You can execute SELECT statements on a system table, but you cannot execute a statement such as INSERT, UPDATE or DELETE on these tables.

Use the system table SYS.SYSTEMSTATS to view database metrics. In addition, the ttStats utility enables you to monitor database metrics and to take and compare snapshots of metrics. For more information, see SYS.SYSTEMSTATS in the Oracle TimesTen In-Memory Database System Tables and Views Reference, ttStats in the Oracle TimesTen In-Memory Database Reference, and TT_STATS in the Oracle TimesTen In-Memory Database PL/SQL Packages Reference.

You can also view the SYS.MONITOR table, which contains statistics about certain events that have occurred since the first connection to the database. For example, the SYS.MONITOR table contains information about the number of connections to the database; the number of checkpoints taken; the size of the database; and the amount of memory currently in use. Check the contents of the SYS.MONITOR table by executing SELECT statements on the columns or by using the ttIsql monitor command. For an example of how to use the ttIsql monitor command, see Using the ttIsql Utility in the Oracle TimesTen In-Memory Database Operations Guide.