Maximize Database Performance
Oracle IT Analytics lets you get insights into the performance of your databases by viewing information about database performance degradation, databases with varying workload performance, database inefficiency, and Top SQL statements.
Problems in the performance of your databases affect your application performance. As an IT administrator, you can use Database Performance Analytics to analyze database performance issues across your enterprise, and identify the underlying systemic causes of the performance issues.
Using Oracle IT Analytics, you can find:
- Databases degrading in performance with decrease in demand
- Databases degrading in performance without change in demand
- Databases which are increasingly inefficient
- Top SQL statements
- SQL queries that are highly varied in performance
Oracle IT Analytics can be also be used to maximize database performance of both types of Autonomous Databases - Shared: Autonomous Data Warehouse – Shared and Autonomous Transaction Processing – Shared. For more information on Autonomous Databases - Shared, see: Discover Autonomous Databases in Using Oracle Database Management for Autonomous Databases.