Scripts and Tips for Monitoring CPU Resource Manager
(Doc ID 1338988.1)
Last updated on AUGUST 04, 2018
Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 11.1 to 12.1] Information in this document applies to any platform.
Oracle Database Resource Manager is a tool for managing how multiple consumer groups (i.e. workloads) or pluggable databases (PDBs) use and share resources, such as CPU, I/O, and parallel servers. In this document, we focus on using Resource Manager to manage CPU. Once you have created and enabled a resource plan, you should run real or representative workloads, monitor Resource Manager, and tune the resource plan as needed.
This document provides scripts for monitoring and tuning Resource Manager for CPU.
This script can be run on any Enterprise Edition database that is version 11.1 or later. We do not provide scripts for earlier versions since the v$rsrcmgrmetric_history view was introduced in 11.1.
You must be logged in as a SYS user to run this script.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!