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
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
Kommentare
Kommentar veröffentlichen