Re: INITRANS and MAXTRANS

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 26 Nov 2004 09:08:48 +1100
Message-ID: <41a657ed$0$20857$afc38c87@news.optusnet.com.au>

Jonathan Lewis wrote:

> Note in-line
>
> -- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated Sept 19th "Howard J. Rogers" <hjr@dizwell.com> wrote in message news:41a62c19$0$17539$afc38c87@news.optusnet.com.au...

You know that "--" causes Thunderbird to not include every line beneath it when the Reply button is clicked? If the quoting in this reply has therefore screwed up, it's because a manual cut and paste job was needed to fix the problem. Just thought I'd mention it.

>>>>> But what happen when there isn't enough space in the block ??? an 
>>>>> exception occur ??
>>
>>>
>>> A buffer busy wait. You queue up for access to a freed transaction slot. 
>>> That's measured as a wait on the system.

>
>
> An ITL wait, not a buffer busy wait, which shows
> up as a TX lock wait in mode 4 in v$lock (one of
> several reasons for TX/4).

Absolutely correct, and I apologise for the error. I wrote the buffer busy wait bit first. Then had my doubts. Wrote the remaining two less specific sentences instead, intending to check and decide between them. And then hit the Send button without thinking about it.

Stupid of me, I realise.

Regards
HJR Received on Thu Nov 25 2004 - 16:08:48 CST