The AppDynamics Database Monitoring module for Oracle is a comprehensive, 24/7 deep-dive tool used to monitor any edition of Oracle Database running on any platform.
Oracle Database, Oracle’s flagship product, is a commercial relational database management system (RDBMS). It provides large organizations an enormous feature set, right out-of-the-box. These core features include logical data storage using tablespaces, table partitioning based on key sets, and database monitoring and tracking. Oracle Database offers extensions to customize the system’s core functionality. Known as "database options", these include such features as Advanced Compression, Advanced Security using data encryption, Content Database to store unstructured data, Data Mining to find patterns among existing data, and an In-Memory Database Cache that leverages TimesTen technology. Oracle also provides its customers the option to install additional "Management Packs", designed to utilize cutting-edge database technologies like multi-tenancy cloud file systems, and online analytical processing (OLAP), among other features.
Deep visibility into Oracle V$SYSSTAT statistics
Get to the root cause quickly and resolve costly performance problems with real-time visibility into any V$SYSSTAT metrics in any Oracle server throughout your organization.
Historical Oracle performance trends
Analyze and alert based on Oracle server performance trends over time, and use this information to proactively tune performance to improve resource efficiency and optimize the end user experience.
Quickly troubleshoot issues with a one-click analysis that displays details of the SQL statement and execution plan.
View Oracle objects
Gain a holistic view of your Oracle objects with full visibility and correlation with SQL execution plans. Easily see parameters, properties, and information related to database objects, including current configuration values.
Comprehensive performance reports
Visualize important information, like historical reporting of time series comparisons and top SQL reports to make data-driven decisions about your Oracle servers.
This extension works only with the standalone machine agent.
Before you jump into creating KPIs for your Oracle database, clearly state and test your assumptions right up front. That has to come first. Otherwise, you’ll go down a blind alley many times trying to achieve better performance that will never happen because your assumptions were wrong in the first place.