Re: Subject: Batch load freezes every couple of minutes

Blocksize is 8k = 168 ITL's according to your formula.

• Original Message ----- From: "K Gopalakrishnan" <kaygopal_at_gmail.com> To: <mosicr_at_rogers.com> Cc: "sol beach" <sol.beach_at_gmail.com>; <oracle-l_at_freelists.org>; <ryan_gaffuri_at_comcast.net> Sent: Wednesday, April 20, 2005 6:15 AM Subject: Re: Subject: Batch load freezes every couple of minutes

Ranko:

255 is the theoritical maximum. But in practice the variable part of the datablock header can not occupuy more than 50% of the data block. So in practical you can have approx(blocksize-fixed header)/2 bytes left for ITL creation. This makes approx (blocksize/48)-2 ITLs.

Going by the same approximation a 2k blocksize can have only 40 ITLs. irrespective of MAXTRANS settings.

KG

On 4/19/05, Ranko Mosic <mosicr_at_rogers.com> wrote:
> Isn't maxtrans of 255 ( default )sufficient ?
>
> ----- Original Message -----
> From: "sol beach" <sol.beach_at_gmail.com>
> To: <mosicr_at_rogers.com>
> Cc: <oracle-l_at_freelists.org>; <ryan_gaffuri_at_comcast.net>
> Sent: Sunday, April 17, 2005 9:18 PM
> Subject: Re: Subject: Batch load freezes every couple of minutes
>
> >Instance runs 20 parallel load processes
>
> You might be encountering enqueue waits.
> Typically INITRANS=1 for tables & 2 for indexes (YMMV).
> Unless & until the session holding the Interested Transaction Lock
> releases it, other sessions will quietly get into line waiting for it
> to be released. This is NOT a deadlock & won't be reported as one.
>
>
>
> --
>
> Best Regards,
> K Gopalakrishnan
> Co-Author: Oracle Wait Interface, Oracle Press 2004
> http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
>
>

--
http://www.freelists.org/webpage/oracle-l