Re: Subject: Batch load freezes every couple of minutes
- From: "Ranko Mosic" <mosicr@xxxxxxxxxx>
- To: "K Gopalakrishnan" <kaygopal@xxxxxxxxx>
- Date: Wed, 20 Apr 2005 07:10:23 -0400
Blocksize is 8k = 168 ITL's according to your formula.
----- Original Message -----
From: "K Gopalakrishnan" <kaygopal@xxxxxxxxx>
To: <mosicr@xxxxxxxxxx>
Cc: "sol beach" <sol.beach@xxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx>;
<ryan_gaffuri@xxxxxxxxxxx>
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@xxxxxxxxxx> wrote:
> Isn't maxtrans of 255 ( default )sufficient ?
>
> ----- Original Message -----
> From: "sol beach" <sol.beach@xxxxxxxxx>
> To: <mosicr@xxxxxxxxxx>
> Cc: <oracle-l@xxxxxxxxxxxxx>; <ryan_gaffuri@xxxxxxxxxxx>
> 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/
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
