DBA SGA Target Advice
Description
Categories: Enginatics, Kcapps
Repository: Github
Repository: Github
Orace's SGA target advice view.
It shows an estimation of how an SGA resize would affect overall database time and IO.
It shows an estimation of how an SGA resize would affect overall database time and IO.
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 |
