Tuning PGA and Temporary Space

Savoir si la pga est assez grande? sinon exécution dans TBS temp pas bon.

col PGA_SIZE for a45

SELECT CASE WHEN low_optimal_size < 1024*1024
THEN to_char(low_optimal_size/1024,’999999′) ||
‘kb <= PGA < ‘ ||
(high_optimal_size+1)/1024|| ‘kb’
ELSE to_char(low_optimal_size/1024/1024,’999999′) ||
‘mb <= PGA < ‘ ||
(high_optimal_size+1)/1024/1024|| ‘mb’
END pga_size,
optimal_executions,
onepass_executions,
multipasses_executions
FROM v$sql_workarea_histogram
WHERE total_executions <> 0
ORDER BY low_optimal_size
/