Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Mailing Lists ->
Oracle-L ->
Re: Fasten huge index rebuild - How To ?
Re: Fasten huge index rebuild - How To ?
Thanx zhu . i will pass on ur valuable suggestions to my friend.
Regards,
Prem.
- Zhu Wrote :=20
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.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 19 2005 - 10:27:09 CDT
Original text of this message