DBA SGA Target Advice

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Orace's SGA target advice view.
It shows an estimation of how an SGA resize would affect overall database time and IO.

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Download
   
Related Blitz Reports
DBA SGA+PGA Memory Configuration DBA SGA Memory Allocation FND Concurrent Requests 11i FND Concurrent Requests AP Suppliers PAY Pay Advice (Singapore) AP Supplier Upload XX AP Suppliers PAY Pay Advice (Hong Kong)
Blitz Report™

Blitz Report™ provides multiple benefits: