SelectStar is a platform that monitors your heterogeneous database environments and underlying infrastructure in one place. One common technology, Oracle Database, is no exception. Continue reading to see how you can monitor your Oracle Databases and Instances with SelectStar.
Health, Compliance, & Configuration
After selecting an Oracle Database from the SelectStar homepage, the first thing you’ll see is the Health, Compliance, Configuration, Alerts, and Recommendations for that Oracle resource.
Alerts are tied to specific performance metric thresholds that you can customize to meet your requirements. When these thresholds are exceeded, an alert will appear in the right sidebar and will impact the health of the database. Recommendations are generally tied to configuration metrics and best practices. When best practices are not met, recommendations appear in the right sidebar and will degrade the Compliance score of the database.
Finally, the Configuration Details section will show you what Oracle Database version you’re running, the underlying infrastructure (if you’ve connected that to SelectStar), and whether the collector is running.
Deep Dive with Analysis
Below the Health, Compliance, and Configuration overview section is the Analysis section. Here you will find key performance metrics for your Oracle Database and the underlying infrastructure. For Oracle Databases, key metrics include Wait Time, Queries, Sessions, and Instance Configuration.
What does this mean for the future of your database infrastructure? It’s crucial to prioritize planning so that your data can continue to support the business’ needs in the future, but it’s far too easy to get caught up the numerous other responsibilities demanding the database administrators’ time. Establishing SLAs to focus on future goals helps teams become more strategic with today’s tools while preparing for the organization’s future needs. In addition, leveraging a database and infrastructure monitoring platform that offers you more visibility into key performance indicators and reduces troubleshooting times can free up your time so you can focus more on preventing issues and less on reacting to them.
Clicking any of these KPI sections will show you more detail about the KPI. For example, clicking on the Queries section will let you look at the queries being run on your Oracle Database, as well as their execution time, number of executions, and more.
If you have added infrastructure monitoring to SelectStar, you will also see KPI’s for the infrastructure your Oracle Database relies on. You can see in Figure 3 the VMware Virtual Machine KPIs for the VM this Oracle Database runs on. Clicking anywhere in the infrastructure box will take you to the infrastructure resource page where you can get even more detail.
The Advanced section of an Oracle Database contains all metric categories such as “Redo”, “Undo”, and “Misc”. Clicking on any of these metric categories will bring you to a page focused on the selected category.
For example, clicking on the “Redo” box will bring you to a page with all redo-related metrics. Relevant configuration values are shown at the top, while performance metrics are individually charted. Just like on the Oracle Database page, you can click any of the performance metrics to get advanced graphing functionality.
Back on the Oracle Database page there is one final section called “Relationships”. Here you will see any related resources within the Oracle Database hierarchy, as well as any underlying infrastructure resources if you’re collecting them. Compliance scores are available at each level, and any active alerts will appear on the appropriate resource.
The Oracle database, in this case ora16g-oel7-f, is the page we are on right now. For more information about the VMware layer, you would click on “vcsa-test/ora12c-oel7-f….”. For information on the Oracle Instance, you can click on OEM12c.
Oracle Database Instances have a similar layout, with health/compliance/etc at the top, followed by an “Advanced” section with metric categories that can be drilled into. I/O metrics, locks, operating system performance, cache metrics, and more can be found on the Oracle Database Instance page.
To learn more about SelectStar or request a free trial, visit selectstar.staging.wpengine.com.