Oracle Database Monitoring

An extension of Introscope, the web application management solution, CA APM for Oracle Databases provides visibility into the performance and availability of Oracle databases. With this extension, you can better ensure the health and availability of Oracle-connected web applications. You can proactively detect and isolate database-related performance problems and effectively communicate with database administrators for fast problem resolution.
apmdevops106
An extension of Introscope, the web application management solution, CA APM for Oracle Databases provides visibility into the performance and availability of Oracle databases. With this extension, you can better ensure the health and availability of Oracle-connected web applications. You can proactively detect and isolate database-related performance problems and effectively communicate with database administrators for fast problem resolution.
Features and Benefits
CA APM for Oracle Databases enables you to:
  • Monitor the performance of Oracle databases from a web application perspective
  • Correlate Oracle database-to-web application activity
  • Verify the application use of Oracle database activity capacity
  • Share critical performance and availability information with DBAs
  • Compare current database activity with historical database activity
CA APM for Oracle Databases provides real-time visibility into critical database resources such as deadlocks, full table scans, redo log files, rollback segments and more. You can see immediate time to value in preconfigured dashboards and performance-triggered alerts that pro-actively notify you of potential SLA violations, before end users are affected. CA APM for Oracle Databases arms application support personnel with the information to determine whether web application performance issues are related to the database. By providing critical performance data, it facilitates collaboration with database administrators and eliminates finger-pointing so that problems can be detected, isolated, and eliminated quickly. As this product uses the Introscope platform, all the information gathered can be visualized, analyzed and queried as with any other Introscope data.
CA APM for Oracle Databases monitors the following database resources:
  • Availability
  • Number of deadlocks
  • Number of full Table Scans
  • Redo Log Files wait and switch counts
  • Rollback Segments get/wait counts and ratios
  • System Global Area (SGA) buffer size
  • Sorts disk/memory ratio
  • Table Spaces read/write count
CA APM for Oracle Databases offers you the following benefits:
  • Seamless integration with Introscope, provides direct visibility into the Oracle database from within Introscope
  • Prebuilt Dashboards and Alerts give instant information
  • Deeper visibility into back-end systems that affect the application availability and performance
  • Captures most important metrics, directly from Oracle performance metrics
  • Application administrators do not need to learn different tools to monitor Oracle databases
  • Constructive communication between application administrators and database administrators; an application administrator can relay critical Oracle database information in the language that the database administrator understands.
Usage Scenarios
Introscope and application administrators can use CA APM for Oracle Databases to diagnose the following problems:
  • Problem root cause isolation:
     You can effectively triage problems, showing whether the problem is with your application, the application server, or the Oracle database.
  • Oracle Database instance availability:
     When web applications are running slowly or returning errors, the extension reports availability of all monitored Oracle database instances. Administrators can rapidly determine which Oracle databases are unavailable.
  • Slow response times:
     The extension shows data to determine the database resources that are causing performance slowdown.
Functionality
CA APM for Oracle Databases is a standalone Java application that can be installed on a separate host from the one on which Oracle resides.
CA APM for Oracle Databases queries Oracle through JDBC for its health statistics, converts the data to Introscope metrics and sends the information to the Enterprise Manager. You can view the information using the Workstation.
One installation of CA APM for Oracle Databases can monitor multiple Oracle databases on multiple hosts.