Gunnar
Give SORT_AREA_SIZE a try. I think you will be pleasantly pleased with
the results. Remember you can set it with ALTER SESSION, particularly useful
for creating indexes.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Monday, September 08, 2003 7:49 AM
To: Multiple recipients of list ORACLE-L
Hi all,
we have a couple of huge tables and we have some performance problems while
creating indexes. Here are some methods we already have tried, is there
something else:
Here's the list of features we already know:
- Using NOLOGGING mode
- Using PARALLEL option => PARALLEL 4 (the server has 4 CPU's)
- Using NOSORT option => not applicable because the rows are not stored in
the right order
- Creating an index first as unusable and then rebuilding it => this was
tested after the QA cutover but the duration remained unchanged
- Increasing sort_area_size => has not yet been tested
Something else, any help will be appreciated...
rgds
g
_____
Want to chat instantly with your online friends?
<http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.co
m/> Get the FREE Yahoo! Messenger
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
