Most business critical applications are database driven and needs Oracle Monitoring. The Oracle database management capability helps database administrators to seamlessly detect, diagnose and resolve Oracle performance issues and monitor Oracle 24X7. The database server monitoring tool is an agentless monitoring software that provides out-of-the-box performance metrics and helps you visualize the health and availability of an Oracle Database server farm. Database administrators can login to the web client and visualize the status and Oracle performance metrics.
Applications Manager also provides out-of-the-box Oracle reports that help analyze the database server usage, Oracle database availability and database server health.
The other key performance indicators monitored by Applications Manager include attributes for database backup status, Oracle ASM (automatic storage management) instances, block corruption, PGA (program global area) details, processes, scheduled jobs, objects approaching max extents and more. These performance attributes are tracked across all versions of Oracle, including the latest 12c version.
The ManageEngine Applications Manager Oracle Monitoring capability includes monitoring Oracle Recovery Point Objective (RPO), i.e. the amount of data you can afford to lose, if your server has a failure. You can monitor common elements such as the alert log file, archive log destination, and archive log history of both your primary and standby databases.
Additionally the grouping capability helps group your databases based on the business process supported and helps the operations team to prioritize alarms as they are received.
Additionally, Applications Manager also provides the ability to monitor any SQL Query of an Oracle Database by using the Database Query Monitoring capability. With this, a DBA can monitor additional performance metrics, monitor custom database tables and even monitor and expose Business Metrics to Line of Business Managers.
"Everything is going well with Applications Manager. It is a straightforward interface that provides great visibility of how well servers and applications are performing. E-mail alarms and notifications are proving to be extremely useful."
Note: Oracle Application Server performance monitoring is also possible in Applications Manager.
For more information, refer Oracle Management Online Help.