Hello,
I am seeing some weird situation, where in my Oracle 12.1 DB, SGA_TARGET and current SGA allocation is more than maximum RAM/memory on OS.
My RAM is 24 GB
and when checking current SGA utilization it is showing as:
SQL> select sum(CURRENT_SIZE)/(1024*1024*1024) from v$sga_dynamic_components;
SUM(CURRENT_SIZE)/(1024*1024*1024)
----------------------------------
63.98
-.> SGA_TARGET=64
-> Memory_target =0
My question:
1) How it is possible that DB started successfully with SGA_TARGET=64, which is more than VM Max memory =24 GB
2) Next, why SGA current allocation is showing 64GB (63.98 GB), even checked just after DB bounce, it showing 63.98 GB
3) Because of this SWAP started using.
Thanks,
Jorden