The Oracle Enterprise Manager Cloud Control 12c System Monitoring Plug-in for Oracle TimesTen In-Memory Database is deployed as part of an Enterprise Manager Agent, running on the server on which the TimesTen database resides. The Plug-in provides users the ability to monitor the TimesTen database’s activities, including memory and disk usage, performance statistics and configuration information. Configuration information and performance statistics are collected at user-scheduled intervals. The captured information is periodically uploaded and stored in the Oracle Enterprise Manager repository database. Users can monitor database activities using pre-defined pages.
The System Monitoring Plug-In for Oracle TimesTen In-Memory Database collects performance metrics for key areas including: cache and replication activities, checkpoint history, connection rates, locks, log activity, memory usage, SQL command cache, transactions, workloads. The captured information is presented in various formats including times series graphs, tabular results showing current and historic values.
To monitor and manage the system by exception, users may define thresholds for critical events and notifications to be generated. Supported notification types include SMTP, SNMP, PL/SQL procedures, O/S commands and scripts.
The System Monitoring Plug-in for Oracle TimesTen In-Memory Database provides administrators with a consolidated view of the TimesTen system in the entire enterprise. This enables administrators to monitor and manage all of their Oracle software components from a central place. Having such an integrated tool reduces the total cost of ownership by eliminating the need to manually compile critical information from several different tools, thus streamlining the correlation of availability and performance problems across the entire set of IT components.