Oracle PGA Target Advice Report
Displays PGA memory tuning recommendations and predicts how changes to PGA_AGGREGATE_TARGET may impact cache hit ratio and memory overallocation. Useful for PGA sizing and performance tuning.
oraclesqlperformance-tuningv1.0.0
0 stars0 downloads12 views0 comments
By OracleDba • Created
Code
(13 lines)12345678910111213
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/pga_target_advice.sql
-- Author : Tim Hall
-- Description : Predicts how changes to the PGA_AGGREGATE_TARGET will affect PGA usage.
-- Requirements : Access to the V$ views.
-- Call Syntax : @pga_target_advice
-- Last Modified: 12/02/2004
-- -----------------------------------------------------------------------------------
SELECT ROUND(pga_target_for_estimate/1024/1024) target_mb,
estd_pga_cache_hit_percentage cache_hit_perc,
estd_overalloc_count
FROM v$pga_target_advice;