vROps & Oracle Monitoring Soup by Blue Medora

By now many of you have heard of Blue Medora, a VMware partner and creator of platform extensions (a.k.a., management packs) for vROps. One of Blue Medora’s newest offerings is the vROps Management Pack for Oracle Database.

If Oracle Database is a part of your organization’s current DBMS strategy, the Management Pack likely has you covered from a compatibility standpoint. Here are the specs:

Supported:

Oracle 11g and 12c (Standard and Enterprise editions)

Oracle Cloud Database

Oracle Real Application Clusters (RAC)

SSL

Oracle Database Objects, Relationships, and the Virtual Layer

The Management Pack connects to each Oracle instance via JDBC Thin Driver, collecting database object (i.e., instance, database, tablespace, and query) and relationship information as well as health and availability metrics about that Oracle environment—making it visible within vROps.

Using the vROps Inventory Tree navigation feature, Oracle admins gain visibility into internal database object relationships as well as external relationships to the virtual layer. The hierarchical structure implicitly shows which databases belong to each instance—and where each Oracle database is hosted—enabling quick drill-downs to root-cause issues.

Oracle DatabaseDashboards

When the Management Pack is installed and configured within vROps, seven Oracle Database-specific dashboards are added. Each dashboard provides a different level—or view—of key performance metrics (KPIs), from a high-level overview of the entire Oracle database environment, to specific KPIs and alerts related to an individual resource for deep-dive investigation.

Oracle Queries – Displays a ranking of the Top 10 slowest queries for a selected Oracle instance. The dashboard also allows you to select individual queries from the heat map to view performance metrics for the selected query.

The Management Pack also displays Session Capacity Remaining for a selected Oracle instance using the predictive analytics capabilities of the vROps Analysis Badges. An Oracle Session Capacity Report is also available, among five other reports, making it easier to demonstrate and communicate the need to provision more resources to an Oracle environment to your team or management.