prompt
prompt ++++++++++++++++++++++++++++++++++ item ++++++++++++++++++++++++++++++++++
prompt + 7.0 sort area size +
prompt ++++++++++++++++++++++++++++++++++ item ++++++++++++++++++++++++++++++++++
prompt
ttitle left "*** sort area ***" skip 1
select substr(name,1,25) "sort area name",
substr(value,1,15) "value"
from v$sysstat
where name like 'sort%'
/
prompt
prompt <<<<<<<<<<<<<<<<<<< note: >>>>>>>>>>>>>>>>>>>>>>
prompt 7.0 invesigation
prompt the lower the value of the sorts to disk ,
prompt the better the sort is performing .
prompt sort_area_size can't be increase large enough to elimate sorts to disk
prompt the sorts on a database are low-maintenance items
prompt usually , sort_area_size and sort_area_retained_size should be set to the same value
prompt the optimal value of sort_area_size and sort_area_retained_size is 1m
