optimal,one pass,multi pass auto manage para:pga_aggregate_target v$pgastat v$sql_workarea v$sql_workarea_histogram v$sql_workarea_active v$sql v$sql_plan v$tempseg_usage v$pga_target_advice v$sysstat v$pga_target_advice_histogram v$sort_usage v$sort_segment union minus intersect sort,union all no sort dba_temp_files