Re: Initrans (don't forget deadlock avoidance)
- From: "Nuno Souto" <nsouto@xxxxxxxxxxxxxx>
- To: "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 10 Sep 2004 20:28:08 +1000
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@xxxxxxxxxxxxxx
----- Original Message -----
From: <chris@xxxxxxxxxxxxxxxxxxxxx>
> 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@xxxxxxxx>:
>> 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@xxxxxxxxxxxxx&subject=unsubscribe
To search the archives - //www.freelists.org/archives/oracle-l/
Other related posts:
