On 22 Mai, 20:20, DA Morgan <damor..._at_psoug.org> wrote:
> 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
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Sorry about the incomplete informations, we run 9.2.0.6 64Bit on AIX5
using JFS and JFS2 filesystem on PowerPC. Best regards,
Ingo
Received on Wed May 23 2007 - 02:01:40 CDT
