Re: INITRANS on indexes

Norman Dunbar wrote:
>
> Quick question - hopefully,
>
> I have a table with INITRANS set to 5
> What should be the INITRANS setting on the tables index(es) and why ?
>
> I know that the default is one for a table and two for an index because
> the index transactions are serialised and therefore need one extra slot.
> Does this mean that the table above will need its indexes set to
> INITRANS 10, or just 6 ?
>
> Thanks in advance.
>
> Norman.
>
> ------------------------------------------------------------------------
> -----
> Norman Dunbar EMail: Norman.Dunbar_at_LFS.co.uk
> Database/Unix administrator Phone: 0113 289 6265
> Fax: 0113 289 3146
> Lynx Financial Systems Ltd. URL: http://www.Lynx-FS.com
> ------------------------------------------------------------------------
> -----

Slots can grow to what is required anyway (up to maxtrans obviously) - where things can get nasty is when you have a very low pctfree, and thus when the block becomes nominally "full", you can run out of the space that the automatic slot expansion would normally grab.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."