Well most SANS's today offer throughput and caching at levels 5 to 10
times (and beyond w/fibre) better than so called local disks. Right
there it would be hard to justify the use of so called "locals". There
are some reasons for putting portions of a database on locals such as
maybe redo, temp, undo, etc but, even then there are ways to deal with
that.
I guess solid-state disks/devices (which are hugely expensive and not
practical for the entire database) would out perform SAN but, I'm sure
that's not what your ADMIN person is considering. I'd be more curious as
to what THEIR thought process is for moving OFF the SAN? I'd say SHOW
ME your logic/spec's for considering such a move.
M
>>> "Perumal Jai "
<oracledba-ezmlmshield-x62725502.[Email address protected] 03/31/05 2:09
PM >>>
Dear folks,
As we all know Oracle is an I/O intensive database and
using the
SAN solutions from many vendors like EMC, HP etc offers better I/O
throughput, reliability and availability than using straight local
disks.
The SAN solutions comes with hardware level mirroring and striping,
dual
fiber channel controllers, better backbone and chassis design and
internal
cache which offers better I/O throughput than local disks. In our site
the
Unix admin wanted to move the Oracle financials production database
from a
EMC SAN architecture to local disks (sounds crazy right !!! ). I
explained
to them the benefits of SAN solution over local disks but was not able
to
make an impact. I wanted something in writing so I can show them the
benefits of SAN over local disks, I was wondering if anyone of you has
any
white papers or relevant document which can explain the benefits of
SAN
solution to local disks for Oracle databases, if so could you please
email
it to me.
Thanks & Regards
Jai
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page