My Oracle Support Banner

Restricting the PGA Usage Per Session Level Using Resource Manager - 12.2 New Feature (Doc ID 2170748.1)

Last updated on JANUARY 07, 2025

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This document explains the Per-Process PGA Limits introduced in 12cR2.

Scope

 For DBAs who want to restrict the PGA usage per session. Knowledge of Resource Manager feature is required.

Details

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
Purpose
Scope
Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.