Working with Automatic PGA

gefunden zum Thema PGA:

Link: http://www.pythian.com/documents/Working_with_Automatic_PGA.ppt

Link: http://www.quest-pipelines.com/newsletter-v5/0304_A.htm

PGA-Tuning:

1) show parameter pga_aggregate_target

2) select name,value from v$sysstat where name like 'workarea executions%';

3) select * from v$pgastat;

4) select round(pga_target_for_estimate/1024/1024) as target_size_MB,
bytes_processed,
estd_extra_bytes_rw as est_rw_extra_bytes,
estd_pga_cache_hit_percentage as est_hit_pct,
estd_overalloc_count as est_overalloc
from v$pga_target_advice;


PGA-Bedarf aller aktueller Prozesse:
SELECT ROUND (pga_alloc_mem / 1024 / 1024, 1) AS alloc_mb,
ROUND (pga_used_mem / 1024 / 1024, 1) AS used_mb,
ROUND (pga_max_mem / 1024 / 1024, 1) AS max_mb, pid, spid, serial#,
program, traceid, background, pga_freeable_mem
FROM v$process
ORDER BY alloc_mb DESC

unter UNIX/Linux Platzbedarf prüfen:
pmap -xs