Re: Slow performance on index creation
From: Bob Manieri <bmanieri_at_ford.com>
Date: 1996/03/26
Message-ID: <4j8r0p$s3e_at_eccdb1.pms.ford.com>#1/1
Date: 1996/03/26
Message-ID: <4j8r0p$s3e_at_eccdb1.pms.ford.com>#1/1
Brian:
Get yourself a decent size on your redo logs, 5 to 10 meg. Another
thing to do is, if you are running with 7.2 or higher, add the clause
UNRECOVERABLE as the last part of your CREATE INDEX command. This will
cause Oracle to skip writing the index create stuff to the redo logs.
On a database running in archivelog mode it makes a BIG difference.
You also want to consider adding the PARALLEL clause if you're on an
SMP machine. Keep in mind though, this will shoot holes in your
tablespace if you specify a PARALLEL number that is too high.
Hopes this helps...
--Received on Tue Mar 26 1996 - 00:00:00 CET
==================================================================
Bob Manieri email : bmanieri_at_ford.com Database Administrator voice : (610) 584-7085 Ford Electronics, Lansdale, PA pager : (609) 342-0314 ------------------------------------------------------------------ Business is war....information is the high ground. - J.Abrahamson ..we can deprive the enemy of the high ground. - J. Buford
==================================================================