This is nothing compared to your work's contribution to my knowledge, but
you're welcome, any time :)
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, September 13, 2003 6:49 PM
> Tanel,
>
> Tried it out -- I stand corrected! T
Tanel,
Tried it out -- I stand corrected! Thanks for the heads up!
-Tim
on 9/8/03 9:14 AM, Tanel Poder at [EMAIL PROTECTED] wrote:
> Tim,
>
> AFAIK, when doing a rebuild the whole index is read using fast full scan,
> the branch blocks are just ignored. And sorting does occur, since fast ful
- Original Message -
> From: "Tim Gorman" <[EMAIL PROTECTED]>
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, September 08, 2003 4:49 PM
> Subject: Re: How to speed up index creation
>
>
> Gunnar,
>
> Using ALTER
Tim,
AFAIK, when doing a rebuild the whole index is read using fast full scan,
the branch blocks are just ignored. And sorting does occur, since fast full
scan doesn't guarantee all keys to be returned in an order. (yes the keys
come in ordered "chunks" because they are stored in ordered way insid
Hi!
> - Using NOLOGGING mode
Yes, definitely use nologging (if not having other constraints such physical
standby database issues)
> - Using PARALLEL option => PARALLEL 4 (the server has 4 CPU's)
I would experiment with even more slaves. 6 for example. Then there would be
more slaves per slave
[mailto:[EMAIL PROTECTED]Sent: Monday, September 08,
2003 8:49 AMTo: Multiple recipients of list
ORACLE-LSubject: How to speed up index
creation
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
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: Monda
Gunnar,
Using ALTER SESSION to increase SORT_AREA_SIZE to some obscene number (i.e.
several hundred Mb? A Gb?) may help, as long as you are running 8i or below
or (if running 9i) the parameter WORKAREA_SIZE_POLICY is set to MANUAL. If
WORKAREA_SIZE_POLICY is set to AUTO, then you may have to bum
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 ha
