Akshally, I'd say the two things are more or less exclusive.
Frelists are mostly relevant to block contention due to INSERT
(and maybe DELETE?) activity.
While INITRANS is mostly relevant for block contention due to
UPDATE. This is why it is important when talking about a database with
"lots of updates" to be specific and explain what kind of "update".
Cheers
Nuno Souto
nsouto_at_bizmail.com.au
- Original Message -----
From: <chris_at_thedunscombes.f2s.com>
> I've generally found that most "block level contention" e.g. buffer busy
> waits,
> data block waits, segment header waits etc. is influenced much more by
> freelists and freelist groups than it is by initrans.
>
> Quoting "Mark W. Farnham" <mwf_at_rsiz.com>:
>> So in addition to avoiding ITL waits, I would also say to pre-emptively
>> set
>> INITRANS when you need to systematically guarantee no deadlocks.
--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
To search the archives - http://www.freelists.org/archives/oracle-l/
Received on Fri Sep 10 2004 - 05:23:44 CDT
