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;