RE: 10G and UFS - long write times

More testing has confirmed that the issue is there in 9i but not to the same degree

Very simply, what we are seeing is that using the test routine I showed earlier on UFS mounted local disk the results are :-

9i SAN time = (15-30s) * 2.5 = 3.30 minutes 10g San time = ((15-30s) * 14 = 6 - 9 minutes

This is on Solaris and seems to me to be repeatable on Linux but the Unix boys want me to stay with Solaris for now for ease of testing.

John

-----Original Message-----
From: Ron Rogers [mailto:RROGERS_at_galottery.org] Sent: 08 June 2006 13:14
To: oracle-l_at_freelists.org; Hallas, John, Tech Dev; F.Castillo_at_hzd.hessen.de
Subject: RE: 10G and UFS - long write times

John,
 That is exactly what I noticed when I migrated to 10G on Linux. The log waits increased while writing the archivelogs. I have 2 systems, same OS same 10g setup but one does not do archiving. The archiving system waits during a SQLLDR load and the non archivelogging does not wait. I checked Metalink at the time and it did not explain the problem. I have sence upgraded to 10g2 and the wait is still there. I does not cause a performance problem for me because the loads all occur in the quiet times.
 I have been waiting for a patch release to fix the problem. Ron

>>> "Hallas, John, Tech Dev" <John.Hallas_at_gb.vodafone.co.uk> 06/08/06
4:23 AM >>>
True Felix but that is not the point.

I wanted an easy script to recreate a problem  

It does not explain why it takes say 30 seconds on 9i and 9 minutes on 10G on boxes that should be set up the same.

I use the word should carefully as I am assured we have a very conformant build standard that applies to all servers. I cannot guarantee that myself and frankly do not have the skills nor the time to do so.  

John

--
http://www.freelists.org/webpage/oracle-l