How to check memory component sizes (like SGA and PGA)

Sep 29, 2020 4:00PM

Summary

Hi guys,

In Autonomous databases, how can I check the memory component sizes (like SGA and PGA) being used?

V$MEMORY_DYNAMIC_COMPONENTS and V$SGA displays no values.

Regarding the PGA, I am using the following query, I hope this is OK:

select sum(pga_max_mem)/1024/1024 "TOTAL MAX PGA (MB)" from v$process;

19c