Re: Oracle and SAN

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 21 Jul 2005 15:03:15 -0700
Message-ID: <1121983398.88792@yasure>

marist89 wrote:

>>From your perspective a SAN is nothing more than a bunch of disks

> connected to a computer. Just like a traditional direct-attach disk
> array. The only difference is you are connecting to the disk via Fibre
> vs. SCSI. You can configure a SAN just as poorly as you can configure
> a direct-attached disk array.
>
> Usually the difficulty with Oracle on SAN's is the storage
> administrators don't understand what the database host needs. They'll
> share your disk with the email server. When your server is doing very
> little I/O you'll be getting service times in the 40's.
>
> They'll give you 6 physical disks in a RAID 5 filesystem but present it
> as 8 LUNs so you think you have 8 RAID 5 filesystems.
>
> They'll tell you they have hardware RAID and lots of cache so RAID 5 is
> as fast enough for your redo logs.

And a DBA that suffers that nonsense deserves what they get: Pain.

Yes I know in the real world this type of idiocy is imposed on DBAs. But DBAs need to wake up, smell the coffee, and start insisting before accepting jobs the ability to control their own environment. If you don't demand control of storage and o/s parameters you are signing on the dotted line that says masochist.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Thu Jul 21 2005 - 17:03:15 CDT