Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sum of PGA_AGGREGATE_LIMIT of all PDBs is greater than CDB

user964944Mar 21 2020 — edited Mar 21 2020

Hello,

What happens when sum of all PGA_AGGREGATE_LIMIT parameter of all PDBs exceeds the amount of value set for CDB level?

For example:

If I have PGA_AGGREGATE_LIMIT=10GB and have 2 PDBs, 1st PDB has 6GB and 2nd PDB has also 6GB so totally they have 12GB but PGA_AGGREGATE_LIMIT at CDB level is only 10GB.

Same applies to SGA_TARGET and PGA_AGGREGATE_TARGET.

This post has been answered by mariam.kupa on Mar 21 2020
Jump to Answer
Comments
Post Details
Added on Mar 21 2020
#general-database-discussions, #memory
7 comments
2,112 views