Database Memory & 4030/4031 (MOSC)

MOSC Banner

Excessive usage SGA

Hello!

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.13.0.0.0

I am faced with a strange situation. At the PDB level, the limit for using SGA sga_target=100G is set. In fact, the PDB consumes 358G. The settings are set according to 2170772.1. How is this possible? How can I strictly limit the use of SGA at the PDB level? Please advise me.

SQL> select con_id,sga_bytes/1024/1024/1024 sga_gb from v$rsrcpdbmetric;


  CON_ID   SGA_GB

---------- ----------

     3 358.581125

SQL> select con_id,name,value,display_value from v$system_parameter where name like '%sga%' and con_id <> 2;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center