Re: Fasten huge index rebuild - How To ?
- From: Prem Khanna J <premjhere@xxxxxxxxx>
- To: zhuchao@xxxxxxxxx
- Date: Thu, 19 May 2005 19:47:39 +0530
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
