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
Oracle optimizing sort operations
最新推荐文章于 2016-08-24 15:34:36 发布