If possible consider setting the tablespace that holds the table data as
'read only' for the duration of the index rebuild. Also the parallel
option can help, just make sure you have multiple datafile in the index
tablespace to table advantage of spreading the i/o across multiple disks.
- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Saturday, May 03, 2003 12:26 AM
> Hi all -
> We are on 8.1.7.4 and HP11. I am rebuilding all indexes in the database
and
> wonder if DBAs out there can give me some tips on how to speed things up.
> I am aware of some of the things that need to be done, like using
> 'nologgin', increasing sort area size and buffer cache, shared pool. I
have
> tried them all and so far the results have not been satisfactory. I am
> wondering if I missed something important.
>
> TIA
>
> Dennis
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Meng, Dennis
> INET: Dennis.Meng_at_alcoa.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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Patti Johnson
INET: pjohns2_at_tampabay.rr.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 Sun May 04 2003 - 10:46:35 CDT
