Oracle-L: RE: would imp speed affect by setting indexes to NOLOGGING?

From: gmei <gmei_at_incyte.com>
Date: Wed, 28 May 2003 07:24:43 -0800
Message-ID: <F001.005A4390.20030528072443@fatcity.com>

I have a question about index creation. When I run

create index xyz ... tablespace indx_ts ...

at what stage "sort_area_size" (and temp space if sort_area_size is not large enough) is used during the process? Is my understanding correct that the index will be created in "indx_ts" (not temp tablespace). As long as we have enough space in "indx_ts" we are fine. I thought sort_area_size and temp space is used for sorting only.

Guang

Original Message: In respone to someone's question about improving exp/imp speed I had posted the following quite some time ago. Most of it may help you.
- Kirti

<snip>

9) After the import is completed, set sort_area_size, sort_area_retained_size to a higher value (whatever is adequate and
possible) to speed up index build process. Also, consider TEMPORARY type
temp tablespace with properly configured initial and next (multiples of
sort_area_size) extents. Make sure temp tablespace has ample room, should
index build processes perform disk sorts. Also, make sure quota is okay on
tablespaces for primary key constraint indexes.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: gmei
INET: gmei_at_incyte.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed May 28 2003 - 10:24:43 CDT