=============
mail one
------------
> PFA ctl files tuned , Please check the same and let us know the performance
> difference before and after using the tuned CTLs.>
> Please note down the time and no of records/rows we are loading to target
> for each script.
>
> Waiting for your feedback.
>
> Thanks and Regards
>
> Shiju
=============
mail two
------------
> Hi Shiju
>
> I loaded the data by using the control files that you are provided. That
> increased the performance.
> And the timings to load 5136324 records are
>
> Before modifying the code
> 11 mins
> After modifying the code (as suggested by you)
> 7mins
> Thank you very much for providing such tuning technique.
>
> Thanks and Regards
=============
mail three
------------
Thanks for the feedback.
What I have done is increase the "bind array" for SQL*Loader tool.
There are some more steps we need to follow to get well tuned result.
Initially we need to estimate the RBS requirement (Rollback Segment).
1) determine size of a single row.
2) determine size of a bind array
memory= No.of Rows * rowsize
bindArraysize=min(memory,
3) estimate the size of RBS size required.
rollbacksegment size=1.3*bindarraysize.
When estimating the size of rollback segment size ,I recommend to add 30%
for overhead to the bindarray size.
Since SQL *Loader cant select the RBS for its own, we need to
make offline other rollback segments offline that are small as per the
calculation we have made.
another tips are
1)drop the indexes of the table you are loading data, then recreate
the same after loading.
(please dont drop indexes associated with primary and unique key constraints).
2)Use larger redolog files.
3)fixed width input data file faster than csv file.
NB: Please perform all these steps only with the help of a DBA.
Thanks and Regards
