Activating and Monitoring the Resource Manager
for
classify sessions into groups and allocate resources accordingly, optimizing performance
DBMS_RESOURCE_MANAGER
similar processing requirements (e.g., 'OLTP_Group', 'Batch_Group', 'Reporting_Group').
PDB to manage its internal workloads.
CREATE_SIMPLE_PLAN
BEGIN
DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN(
group1_cpu => 75,
group2_cpu => 15
-- The remaining 10% is automatically assigned to OTHER_GROUPS
The chart below visualizes the CPU allocation for this simple plan. It guarantees 75% of
BEGIN DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA(); END; /
'Online transaction users');
plan for my database');
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(PLAN =>
>
;
DBMS_RESOURCE_MANAGER.VALIDATE_PENDING_AREA();
DBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA(); END; /
ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = 'daytime_plan';
performance views (V$ views) for this purpose:
V$RSRC_PLAN
including CPU consumed, wait times, and queue length. High values for
CPU_WAIT_TIME
QUEUED
A common sign that DBRM is actively managing resources is the appearance of the
resmgr:cpu quantum
minimal waits, demonstrating DBRM's throttling mechanism in action.
DBMS_SCHEDULER
Reusable, named objects that define a specific action, such as a PL/SQL
jobs.
A mechanism for grouping jobs to manage them collectively. Crucially, job
DBMS_CREDENTIAL
Creating a
Creating a
Creating an
This powerful combination allows DBAs to ensure that heavy background jobs do not
Activating and Monitoring the Resource Manager
Troubleshooting Common Issues: 'resmgr:cpu quantum'
$RSRC_CONSUMER_GROUP
• OLTP_GROUP: CPU usage high, wait time low → prioritized
• Batch_GROUP: CPU usage capped, wait time high → throttled
Create job
Chain Steps:
1. Extract Data → Success
2. Transform Data → Success
3. Load Data → Success
4. Generate Report → Pending
Chain Execution:
Conclusion: Optimizing Oracle Workloads with DBRM and Scheduler
In today’s complex database environments, performance and stability hinge on intelligent
resource allocation and reliable task automation. Oracle provides two robust tools to meet
these demands:
• Database Resource Manager (DBRM) ensures that high-priority workloads receive
the CPU and system resources they need, preventing bottlenecks and enforcing
business-aligned policies.
• Oracle Scheduler empowers DBAs to automate tasks with precision—whether time-
based, event-driven, or distributed across remote systems—while integrating
seamlessly with DBRM for resource-aware execution.
Together, these tools enable database administrators to:
• Maintain fairness and control across competing workloads.
• Automate critical operations with minimal human intervention.
• Monitor, troubleshoot, and tune performance using built-in views and metrics.
• Build scalable, responsive systems that adapt to business needs.
By mastering DBRM and Oracle Scheduler, organizations can achieve a balanced, efficient,
and resilient database infrastructure—one that supports both operational excellence and
strategic growth.
Objective
To provide database administrators and technical professionals with a comprehensive
understanding of Oracle’s Database Resource Manager (DBRM) and Oracle Scheduler,
enabling them to:
• Effectively manage and prioritize system resources across diverse workloads.
• Design and implement resource plans that align with business performance goals.
• Automate routine and complex tasks using time-based, event-driven, and dependency-
aware scheduling.
• Monitor, troubleshoot, and optimize resource usage and job execution using Oracle’s
built-in views and tools.
• Integrate resource control and task automation to build scalable, efficient, and resilient
database environments.
