RE: 10G and UFS - long write times
- From: "Hallas, John, Tech Dev" <John.Hallas@xxxxxxxxxxxxxxxxx>
- To: "Ron Rogers" <RROGERS@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>, <F.Castillo@xxxxxxxxxxxxx>
- Date: Thu, 8 Jun 2006 14:06:33 +0100
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@xxxxxxxxxxxxx]
Sent: 08 June 2006 13:14
To: oracle-l@xxxxxxxxxxxxx; Hallas, John, Tech Dev;
F.Castillo@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
