The increase in performance of course comes from
sorting in memory and avoiding disk writes.
Try running this bit of SQL before and after your tests,
and record the numbers:
select
stat.sid,
name.name name,
stat.value
from v$sesstat stat, v$statname name, v$session sess
where
stat.si
We have not seen any performance gains after setting the sort_area_size in excess of
50Mb. We have set this as a
standard in our re-indexing scripts to set this to 50Mb maximum.
HTH.
-Original Message-
Sent: Monday, January 13, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L
Hi:
