Ask about Temporary Segments

   Hi all,

   My db is 9.0.2.4 on linux.   

   From Temporary Segments: What happens when a sort occurs [ID 102339.1] , in the Guideline section Oracle show formular to calculate NEXT and INITIAL value when create TEMPORAY tablespace but for dictionaty managed temp tablespace, so how calculate for local managed temp tb ? 

   Also this section, Oracle said: "- Try and avoid sorts in index creation by loading rows into the table in ascending order of the index column. When the index is created, use the NOSORT option in the CREATE INDEX command." So When create new Indexes and use this option, effect to SQL performance ?