RE: 10G and UFS - long write times

We have Production 10.2.0.1 running on a Sun F15K and EMC DMX. We unbuffered the redo log mounts, but other than that, we have not drilled down to a deeper level yet. Something to keep my eye on, though. For what it is worth, write times are not at the top of our list at the moment.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala Sent: Thursday, June 08, 2006 8:29 AM
To: John.Hallas_at_gb.vodafone.co.uk
Cc: Ron Rogers; oracle-l_at_freelists.org; F.Castillo_at_hzd.hessen.de Subject: Re: 10G and UFS - long write times

On 06/08/2006 09:06:33 AM, Hallas, John, Tech Dev wrote:
> 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

This is extremely worrisome to me. The company that I work for has a bunch of 9i databases and a sandbox to test 10G. As we are primarily DW place, writes weren't tested yet. How many people here have implemented 10GR2 in production and is there a consensus about the problem with the speed of writing to the database? I'll search Metalink later.

--
Mladen Gogala
http://www.mgogala.com

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


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