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:
Hi:
Today I did some small testing on our db (Oracle 8173 on Solaris 2.8) to
test index rebuild (with nologging) performance vs sort_area_size. I used
"alter session set sort_area_size = " to set the sort_area_size value.
Nothing else was changed. The temp tablespace is 8G. There is no other
a