12.2 : Automate SGA / PGA Advisor

Hello  ,

Our Linux 6.1 production server hosts about 200 Oracle 12.2 databases.

Huge pages and ASMM are activated.

pre_page_sga TRUE

use_large_pages ONLY

memory_max_target 0

memory_target 0

sga_min_size 0sga_target xxG (variable xx <10)

sga_max_size 10G

We are almost full in terms of server RAM and we would like to optimize the SGA_TARGET and SGA_MAX_TARGET for each Oracle instance in order to save memory.

I want to develop a global script able to send me directly the new optimized value of SGA_TARGET and SGA_MAX_SIZE based on the advisor SGA

select * from v $ sga_target_advice order by sga_size;