Oracle Load Tuning in PX8.1

reddysrc · Post by **reddysrc** » Thu Jul 02, 2009 4:01 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Jul 02, 2009 5:44 pm

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

chulett · Post by **chulett** » Thu Jul 02, 2009 5:58 pm

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.