DSXchange

Hi Expetrs,

I had problem in Oracle Enterperise PX stage, load tables very slow, have to improve performance.

I would like to get more picture in Oracle Tuning (table loading) in PX 8.1 ,UNIX env.
could you let me know what env. variables need to tune and what are best steps in Enterprise Stage tuning .

Ultimately it has to improve performance.

Thanks Advance
Vemi

Show us what you are currently doing, in particular the generated sqlldr load script.

You generally tune sql not loads but as noted, let's start with the gory details of what you are doing now, be it a bulk load or whatever.