Re: Temp-Contention

io wrote:
> 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

What version of Oracle with what operating system on what hardware?

Assuming 10g run this query:

SELECT pname, pval1
FROM aux_stats$
WHERE sname = 'SYSSTATS_MAIN';

and post the result.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org