TimesTen Enterprise Manager Plug-in Overview

Oracle Enterprise Manager for TimesTen In-Memory Database provides system administrators with a consolidated view of the TimesTen systems within the enterprise. It enables administrators to manage and monitor the health, availability, and performance of the TimesTen databases from a central management console. Using a single centralized Instance view, users can monitor and manage all of their TimesTen databases. The Instance Home view provides a summary of the Instance’s health along with configuration information.

You can automate administration tasks, such as user-specified backup schedules and frequencies, through the TimesTen Enterprise Manager plug-in configuration. You can set backup frequency to hourly, daily, weekly, or monthly. You can manage storage usage by specifying the maximum number of backups to retain before recycling older backups. You can restore a database from a specific backup in the list of backup files.

For performance troubleshooting, the SQL Monitor provides information for the most executed SQL statements, average statement execution time, and the long running queries in the application workload. SQL Monitor captures seven categories of database performance metrics for real-time analysis: application connections, SQL statements, application workload, transactions, lock contention, transaction logs and database checkpoints.

When using TimesTen as an application-tier cache database for the Oracle Database, users can monitor the transaction flows between the TimesTen database and the Oracle Database to ensure that data synchronization is going smoothly.

The Replication Monitor provides an overview of replication activities on the target database with status and properties of the replication components in the TimesTen instance. Replication performance metrics such as transactions sent/received rates and the pending replication logs can be used to indentify lags between the active and the standby database.