Temp-Contention

Hi,
we are running a load job with a parallel degree of 8 on a machine
with 4 processors each with two cores. Running statspack I've found
out, that we see average read time of 775.1ms whereas the average
write time is 3 ms on our temp tablespace. Doing roundabout 70,000
reads this seems to slow down the load process heavily.
Looking at the tablespace, that consists from 20 files I can see, that
the read activities are located on certain files...


Anyone any ideas how to further investigate or to solve this?

Best regards,
Ingo

.

Relevant Pages
Loading