Reports2017-11-18T12:27:27+00:00

DBA SGA Target Advice

Description
Categories: DBA, Enginatics
Orace's SGA target advice view.
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


By continuing to use the site, you agree to the use of cookies. Accept