Re: Fasten huge index rebuild - How To ?

Don't have experience with domain index, but here are the tips for the
btree index creation:
1. create the index local, unusable,
2. use several sessions to rebuild the individual partitions in parallel.
3. As rebuild index also need sort, give it a huge sort area size and
retained size.
4. as rebuild will do full table/partition scan, give a big
db_file_multiblock_read_count;
5. use nologging to speedup the action.
6. If you can bounce the instance, give a huge log_buffer helps when
you are building index in logging mode.
Hope it helps.
By the way, seems db_file_directio_count does not help for the disk sort.

On 5/19/05, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote:
> How many CPUs does each box have?
>=20
>=20
> On 5/19/05, Prem Khanna J <premjhere@xxxxxxxxx> wrote:
> >
> > Thanx Raj , it seems he had tried that.any other trick that can make it
> > fas=3D
> > ter ?
> >
> > <original post>
> > Based on the timing for the domain index creation on the CLOB column
> > in development database with smaller data volume using parallel degree
> > of 8, I extrapolated (development database is on a much smaller box
> > and I used linear extrapolation) that it will take ~53 hours to create
> > the same index in production database, which is not feasible to do
> > even in a weekend.
> > </original post>
> >
> > Regards,
> > Prem.
> >
> > On 5/19/05, rjamya <rjamya@xxxxxxxxx> wrote:
> > > normally I create large indexes in parallel and then alter then to do
> > > noparallel, works for me.
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
>=20
>=20
>=20
> --
> Niall Litchfield
> Oracle DBA
> http://www.niall.litchfield.dial.pipex.com
>=20
> --
> http://www.freelists.org/webpage/oracle-l
>=20


--=20
Regards
Zhu Chao
www.cnoug.org
--
http://www.freelists.org/webpage/oracle-l

Other related posts: