Scripts and Tips for Monitoring CPU Resource Manager
(Doc ID 1338988.1)
Last updated on AUGUST 23, 2021
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 11.1 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
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!
In this Document
|Monitor Current Resource Plan|
|Determine Current Resource Plan Details|
|Monitor CPU Usage and Waits by Consumer Group|
|Monitor CPU Usage and Waits by Pluggable Database|