Re: Scalable Performace - Inserts/Updates

Is it the performance or the safety you worry about ?

Yes, the SAN on a fibre can be faster than a local disk, especially since SANs tend to come complete with battery backed buffers.

Yes, the SAN is as safe as the local disk (it must be or you wouldn't be able to run any Oracle data file on it at all).

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Joel Garry wrote in message <920ap7$o2e$1_at_nnrp1.deja.com>...



>I won't.  I've got a situation which works ok now, but eventually will

>scale.  I have the redo logs on the local disks.  However, the data

>files are on a humungo SANS.  The thing that is strange - the SANS is

>over fibre, and is quite a bit faster than the local disks.  So should

>I move them there?  My head says yes, my gut says "huh?  Network

>faster than local disk?"

>

>An Oracle Corp contractor DBA using another hardware platform to the

>same SANS couldn't be convinced to do it, is the only reason I haven't.

>Hitachi's uptime guarantee on the SANS is better than the service

>agreements with the unix vendors...

>