The Oracle Enterprise Manager Grid Control 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 configuration, system information, and performance statistics. Configuration information and performance statistics are captured at user-defined intervals. The captured information are periodically uploaded and stored in the Oracle Enterprise Manager repository database. Users can monitor database activities using pre-defined charts, or generate user-defined reports using the flexible Enterprise Manager report wizard.
The System Monitoring Plug-In for Oracle TimesTen In-Memory Database collects performance metrics for key areas including: cache operations, checkpoints, connections, locks, memory, PL/SQL, replication, SQL statements, transactions, workloads, client/server and aging. It delivers the captured information in different formats including:
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.