How to Monitor Oracle Database Performance

An Oracle database provides several v$ views to query information about the database instance, including statistical information that can be used for monitoring and problem analysis purposes. Rene Nyffenegger wrote a nice Summary on Oracle’s v$ views that gives an overview of all available views.

The following illustration shows a dashboard with key metrics that we pull out from an Oracle database when doing performance management with our clients:

Dynatrace Dashboard showing key performance metrics queried from an Oracle Database via v$ tables
Dynatrace Dashboard showing key performance metrics queried from an Oracle Database via v$ tables

Read the rest of article where I provide a quick overview on what these metrics tell us and how to get them. If you run Dynatrace in your environment you can also download the Oracle Monitor Plugin from our Community Portal.

Andreas Grabner has 20+ years of experience as a software developer, tester and architect and is an advocate for high-performing cloud scale applications. He is a regular contributor to the DevOps community, a frequent speaker at technology conferences and regularly publishes articles on blog.dynatrace.com. You can follow him on Twitter: @grabnerandi