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

io wrote:
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@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On 22 Mai, 20:20, DA Morgan <damor... (AT) psoug (DOT) org> wrote:
Sorry about the incomplete informations, we run 9.2.0.6 64Bit on AIX5
using JFS and JFS2 filesystem on PowerPC. Best regards,
Ingo

io wrote:
I can't imagine anything, normal, that could slow down your system
that much. I'd suggest you start off applying the latest patches to
your system, you are several years behind, but don't really expect
that it will solve the problem.

Have you isolated whether similar reads done in the O/S are similarly
slow or whether it is just those executed by Oracle?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

DA Morgan wrote:
You can query V$SEGMENT_STATISTICS to see which segments are most
actively used in this tablespace. You may want to isolate your hotspots.

HTH,
Brian


--
================================================== =================

Brian Peasland
dba (AT) nospam (DOT) peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

--
Posted via a free Usenet account from http://www.teranews.com