PGA Status:
SELECT NAME, VALUE
FROM v$pgastat
WHERE NAME IN
('aggregate PGA target parameter',
'aggregate PGA auto target',
'total PGA inuse',
'total PGA allocated',
'over allocation count',
'extra bytes read/written',
'cache hit percentage'
);
v$sql_workarea_histogram :
SELECT low_optimal_size / 1024 low_kb, (high_optimal_size + 1) / 1024 high_kb,
optimal_executions OPTIMAL, onepass_executions onepass,
multipasses_executions multipasses
FROM v$sql_workarea_histogram
WHERE total_executions != 0;
PGA Advice:
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;