Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 10g using SAN

Re: Oracle 10g using SAN

From: Thomas Hucke <thomas.hucke_at_spb.de>
Date: 15 Nov 2005 00:40:08 -0800
Message-ID: <1132044008.634083.248130@f14g2000cwb.googlegroups.com>


JW wrote:
> Do you mean I need to set up 3 LUN ? one for data, one for index and
> one for redo log and archivelog ?
>
> I thought one LUN can be partitioned into 3 logical drives or volumes.
> The LUN will be spreaded across all physical drives, hencing improving
> disk I/O.
>
> The EMC guys will be coming for a meeting. I want to have some
> background before it.
>
> Thanks.
>
> JW
>
> On Sun, 13 Nov 2005 23:17:06 -0800, DA Morgan <damorgan_at_psoug.org>
> wrote:
>
> >JW wrote:
> >
> >> How about the data and index files, can I put them in one logical
> >> volume (LUN) ?
> >
> >You shouldn't want to. This will just hurt performance. Not because
> >I am suggesting you separate data and indexes, that is nonsense, but
> >because one LUN is a really bad idea.
> >
> >Ask EMC to teach you what you need to know about storage optimization.

I´m with DA in this point.
You need at least 2 LUNs per database:

You do not need to consider any other storage optimization like mirroring and striping. That would be done better by your storage system.

Some storage vendors recommend to use more than only one LUN/volume to avoid any I/O per LUN limitation of the operatin system. Received on Tue Nov 15 2005 - 02:40:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US