Why use Oracle database metrics with WLM?

The key benefit of using Oracle database metrics with WLM is that you can use these metrics to manage the performance of your instances. You specify SLOs for the instances based on the metrics.

For example, with these metrics you can:

Keep response times for your transactions below a given level by setting response-time SLOs
Increase an instance’s available CPU resources (cores) when a particular user connects to the instance
Increase an instance’s available cores when more than n users are connected
Increase an instance’s available cores when a particular job is active
Give an instance n CPU shares for each process in the instance
Give an instance n CPU shares for each user connection to the instance

For examples showing how to set up these types of SLOs, see the files with names ending in “.wlm” in the directory /opt/wlm/toolkits/oracle/config/.

Why use Oracle database metrics with WLM?

Technical documentation

» Table of Contents