Prepare to Identify Inefficient Database Performance
Use Database Performance Analytics to perform a historical, comparative analysis to find any bottlenecks affecting enterprise-wide database performance. You can also determine the root cause of recurring systemic problems, identify the performance profile and activity types for CPU or I/O intensive database activities.
Learn About Identifying Database Performance Issues
One of the first steps in determining database performance issues is identifying the cause.
Gain insights into the performance of your databases by viewing the following details:
-
Databases with varying workload performance
-
Databases which are increasingly inefficient
-
Databases degrading in performance with decrease in demand
-
Databases degrading in performance without change in demand
-
Databases degrading in performance with increase in demand
Review each task in the table to help identify database performance issues.
Task | Purpose |
---|---|
Analyze workloads with unusual characteristics |
|
Analyze performance trends |
|
Analyze database performance degradation and access workload stability |
|
Before you begin, you must:
-
Establish a communication channel between Oracle Cloud Infrastructure and Oracle Management Cloud. Configure a private subnet for the database host and a public subnet for the gateway.
-
Install an agent on the Oracle Cloud Infrastructure system where your database is running.
-
Discover the database.
-
Enable Oracle Management Cloud - Enterprise Edition on both the Host (Oracle Cloud Infrastructure system) and the database.