Re: Temp-Contention

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Wed, 23 May 2007 11:39:21 -0500
Message-ID: <46546201$0$13928$88260bb3@free.teranews.com>

DA Morgan 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?

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.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

Received on Wed May 23 2007 - 11:39:21 CDT