SelectStar database monitoring showing wait time, queries, sessions and configuration analysis for an Oracle database

Oracle Database Deep Dive with SelectStar

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.

Figure 1: Health, Compliance, and Configuration details of an Oracle Database. Alerts and Recommendations are in the right sidebar.

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.

Figure 2: Opening a recommendation will show you the history of the recommendation as well as how to resolve it. Once resolved, your compliance score will increase.

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.

Figure 3: The Analysis section of an Oracle Database.

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.

Figure 4: The queries detail page.

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.

Advanced

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.

Figure 5: The Advanced section of an Oracle Database in SelectStar.

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.

Figure 6: The Redo page of an Oracle database in SelectStar.

Relationships

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.

Figure 7: An example of the relationships section for an Oracle Database Running on VMware.

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.

Figure 8: An Oracle Database Instance page.

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.

LET'S GET STARTED!

Try SelectStar for 14 days. No credit card required.

TRY IT NOW!