Re: inittrans in OLTP system

No, incorrect. Buffer busy waits have nothing to do with itl entries. The symptom you would get with insufficient itls would be enqueue waits. You just wait and wait until the blocking session commits its transaction. You might also see an occasional deadlock, in which trace file there will be an indication of "no rows" involved. This means that itl entries could not grow dynamically and transactions that were involving the same blocks but different rows were deadlocking each other.

Although you can alter the INITRANS value dynamically, you still have to rebuild the table with a higher INITRANS and perhaps a different PCTFREE in order to reallocate space in the blocks. Existing blocks will not be affected by the INITRANS alteration.

Ricky

yong321_at_yahoo.com wrote:

> You don't have to. You increase it if you have too many buffer busy
> waits on the hot tables, usually on a site with too much concurrent
> transaction. In 8i, you can alter table initrans to change it. Below 8i
> (or 8?), you have to rebuild the table.
>
> But this is not all. In fact, more important is probably leaving a
> PCTFREE a little higher than you thought. That way, ITLs (interested
> transaction lists) have room to grow up to maxtrans.
>
> Yong Huang
> yong321_at_yahoo.com
>
> In article <JvM76.7584$1%2.336355_at_sjc-read.news.verio.net>,
> "sp" <sdpant_at_yahoo.com> wrote:
> > I read somewhere that the inittrans for a OLTP system should be
 between 5 to
> > 10? Is it right? If it is, what is the logic behind this?
> > Thanks in advance.
> > SP
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Jan 31 2001 - 17:44:04 CST