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 ?
>=20
> ----- 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
>=20
> >Instance runs 20 parallel load processes
>=20
> You might be encountering enqueue waits.
> Typically INITRANS=3D1 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.
>=20
>=20
>=20
> --=20
>=20
> Best Regards,
> K Gopalakrishnan=20
> Co-Author: Oracle Wait Interface, Oracle Press 2004
> http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
>=20
>

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