The AppDynamics Database Visibility 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.
AppDynamics Database Visibility collects hundreds of Oracle metrics out-of-the-box.
Visualize when Oracle performance exceeds its historical baselines.
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 the actual execution plan for a problematic query and quickly understand the root cause of its slow performance.
Gain visibility into the objects and configuration of your Oracle instance.
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.
The time comparison report can be used to compare two time ranges to understand the performance differences.
"It was simple to deploy. It took minutes, literally. On our first proof-of-concept, we saw results within an hour."
Eric Poon, Director of Operations Analytics, Nasdaq