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