By: Lora Johnson
For Oracle DBAs, Oracle Enterprise Manager serves as only one piece of the puzzle to drive better performance across workloads. Connecting your hardware and software together obviously makes it easier to connect the dots between issues, but extending your monitoring to other layers of the IT stack offers insight into how your non-Oracle components may be impacting performance.
In this blog post, we’ll highlight three ways you can leverage extended monitoring to optimize the performance of your Oracle Enterprise Manager workloads.
Key Relationships
Within Oracle Enterprise Manager, functionality extends across your platform — and your reporting should, too. Understanding how your virtual machines impact the operation of your databases can significantly reduce the amount of time that your team has to spend troubleshooting in order to find the root-cause of the issue.
The Blue Medora Oracle Enterprise Manager Management Pack for vRealize Operations offers insight into important relationships within your Oracle Enterprise Manager environment through key performance indicators and use-case driven dashboards.
Figure 1: Oracle Enterprise Manager EM Environment Dashboard
With the Oracle Enterprise Manager EM Environment Dashboard, you can see an overview of your entire environment, including key relationships, status badges and top alerts. In the event that one of your databases, for example, has an inordinate amount of executions per second compared to your other databases, this dashboard will give you a top-level indication of the issue with the ability to drill down into specific utilization metrics so you can quickly pinpoint the root-cause of the problem.
Capacity Definitions and Alerts
When it comes to making sure your Oracle environment operates at peak performance, clearly understanding your capacity breakdown can make a big difference — after all, knowing when your system will reach its “full” can ensure you are able to mitigate issues arising from capacity problems before they hit your end users.
Figure 2: Example of a capacity analysis badge in Blue Medora’s Oracle Enterprise Manager Management Pack for vRealize Operations
Leveraging the capacity definitions capability within the management pack gives you the ability to clearly understand utilization, adding access to key elements like vRealize Operations calculated CPU capacity, memory capacity, sessions capacity and user capacity.
Reporting and Dashboards
Extend monitoring to see more than 550 metrics for your Oracle Enterprise Manager resources, enabling better visibility across your entire Oracle environment. See metrics like active sessions, average response time, CPU, disk, memory and wait bottlenecks, among others.
In addition, extend monitoring with access to 12 out-of-the-box monitoring dashboards — and the ability to create custom ones to meet your organization’s needs — along with over 20 exportable reports to see key Oracle Enterprise Manager resources, like CPU utilization, database throughput and disk usage.
Figure 3: Example of the Oracle Enterprise Manager DB Overview Dashboard
How to Get the Oracle Enterprise Manager Management Pack
To learn more about the Oracle Enterprise Manager Management Pack or to download a free trial, please visit the True Visibility Suite for VMware vRealize Operations page on Blue Medora’s website.