DBA SGA Target Advice

Description
Categories: Enginatics, Kcapps, Toolkit - DBA
Repository: Github
Orace's SGA target advice view.
It shows an estimation of how an SGA resize would affect overall database time and IO.
Run DBA SGA Target Advice and other Oracle EBS reports with Blitz Report™ on our demo environment
select
gsta.inst_id,
gsta.sga_size_factor,
gsta.sga_size/1024 sga_size,
gsta.estd_db_time_factor*100 estd_db_time_percent,
gsta.estd_physical_reads_factor*100 estd_physical_reads_percent
from
(
select
gsta.*,
gsta.estd_physical_reads/max(decode(gsta.sga_size_factor,1,gsta.estd_physical_reads)) over (partition by gsta.inst_id) estd_physical_reads_factor
from
gv$sga_target_advice gsta
) gsta