Re: Index freelists
- From: "Nuno Souto" <dbvision@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Apr 2004 21:29:15 +1000
----- Original Message -----
From: "Tanel Põder" <tanel.poder.003@xxxxxxx>
> snip
> But if you have contention on index segment's header block because of
block
> splits/freelist operations, then either partition the index or have
multiple
> freelist groups, adding freelists again won't help here. Note that adding
> freelist groups require segment rebuild.
Very interesting points, Tanel. I've discussed a similar situation with
one of the local Oracle consultants here when 10G and ASSM/ASM were
announced
(re-announced?) early last year.
We both reached the conclusion the best approach to contention problems in
situations like these (header block contention) is to hash partition as much
as we can (and dare) and forget about fine-tuning segment-headers, freelists
and all that jazz. Much better bang-for-buck of our time. Same applies to
RAC and clustered situations where there may be block (or row) contention.
Just hash partition the table + indexes over 50 or so splits and be done
with it. 99 times out of 100 it's all you need to do, the remaining 1%
you ask a guru to sort it out. Would you agree?
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision@xxxxxxxxxxxxxxx
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
