RE: Physical Design Question

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Thu, 17 Jul 2003 15:00:26 -0400
Message-Id: <25946.338299@fatcity.com>

This is a multi-part message in MIME format.

------_=_NextPart_001_01C34C95.AEC46D14
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dave,
=20

One other item that you did not mention that could impact you, are = the block size of each database the same? I know that on HP with an = Oracle release before 9i the block sizes all have to be the same. =20

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA=20

-----Original Message-----
From: Mercadante, Thomas F [mailto:NDATFM_at_labor.state.ny.us] Sent: Thursday, July 17, 2003 3:34 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Physical Design Question

David,
=20
You don't say but, I am assuming that all your databases are at the same = Oracle Release level. If this is the case, I would create one Oracle = home for now - you can always create a new Oracle Home when you start = considering migrating each individual database to a newer release. =20
You didn't say if each DB has different access loads, so assuming all = are the same, I would share all disks with all DB's. It will allow you = to better blend all db's on the box - provide the best throughput = possible.
=20
That's what I would do, unless there are some specific business reasons = to not do this (like contractual stuff about availabilty for one = application that the other does not have). =20
Hope this helps.

Tom Mercadante=20
Oracle Certified Professional=20

-----Original Message-----
From: David Wagoner [mailto:dwagoner_at_arsenaldigital.com] Sent: Thursday, July 17, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L Subject: Physical Design Question

Here's my situation:=20

Damagement wants us to move 4 small production DBs to one server to save = on licensing costs. Server is a Sun E4500, 4 CPUs, 8 GB RAM. There is = a pair of internal disks that are mirrored with enough room for Solaris, = swap, and 1 Oracle Home. There are 3 A1000 disk arrays (12 x 18 GB = drives each), all set to RAID 1+0 using the S.A.M.E. approach.

Questions:=20

Should I use a separate Oracle Home for each DB? =20

Pros: --Allows upgrade/patching of 1 DB at a time without = affecting others (some are home-grown, some are 3rd party). =20

        Cons:  --Takes up more space, but space is not a major concern.=20
                       --I'll have to put some Oracle Homes on the =

A1000s with the data files (i.e., concerns about disk contention).

                       --Requires applying multiple upgrades/patches=20

2. Should I put 1 DB per A1000? (Actually, 1 A1000 would hold 2 of the = least active DBs.)=20

Pros: --Easier to determine performance problems b/c each DB is = isolated on 1 A1000.=20

                      --If one controller dies, it only affects 1 DB.=20

        Cons:  --Only get throughput of 1 controller; could use 3 =

controllers if data files spread across 3 A1000s.=20

Anyone with experience doing this, please share your tips, tricks, and = gotchas!=20

Best regards,=20

David B. Wagoner=20
Database Administrator=20

------_=_NextPart_001_01C34C95.AEC46D14
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>Physical Design Question</TITLE>

<META content=3D"MSHTML 6.00.2800.1141" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D927215918-17072003><FONT face=3DArial color=3D#0000ff =

size=3D2>Dave,</FONT></SPAN></DIV>
<DIV><SPAN class=3D927215918-17072003><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D927215918-17072003>    <FONT =
face=3DArial=20
color=3D#0000ff size=3D2>One other item that you did not mention that = could impact=20
you, are the block size of each database the same?  I know that on = HP with=20
an Oracle release before 9i the block sizes all have to be the=20 same.</FONT></SPAN></DIV>
<DIV> </DIV>
<P><FONT size=3D2>Dick Goulet<BR>Senior Oracle DBA<BR>Oracle Certified =
8i DBA=20
</FONT></P>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Mercadante, Thomas F =

[mailto:NDATFM_at_labor.state.ny.us]<BR><B>Sent:</B> Thursday, July 17, = 2003 3:34=20
PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> = RE:=20
Physical Design Question<BR><BR></FONT></DIV>
<DIV><SPAN class=3D494542318-17072003><FONT face=3DArial color=3D#0000ff =

size=3D2>David,</FONT></SPAN></DIV>
<DIV><SPAN class=3D494542318-17072003><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D494542318-17072003><FONT face=3DArial color=3D#0000ff =
size=3D2>You=20
don't say but, I am assuming that all your databases are at the same = Oracle=20
Release level.  If this is the case, I would create one Oracle home = for now=20
- you can always create a new Oracle Home when you start considering = migrating=20
each individual database to a newer release.</FONT></SPAN></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV>
<DIV><SPAN class=3D494542318-17072003><FONT face=3DArial color=3D#0000ff =
size=3D2>You=20
didn't say if each DB has different access loads, so assuming all are = the=20
same, I would share all disks with all DB's.  It will allow = you to=20
better blend all db's on the box - provide the best throughput=20 possible.</FONT></SPAN></DIV>
<DIV><SPAN class=3D494542318-17072003><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D494542318-17072003><FONT face=3DArial color=3D#0000ff =
size=3D2>That's=20
what I would do, unless there are some specific business reasons to not = do this=20
(like contractual stuff about availabilty for one application that the = other=20
does not have).</FONT></SPAN></DIV>
<DIV><SPAN class=3D494542318-17072003><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D494542318-17072003><FONT face=3DArial color=3D#0000ff =
size=3D2>Hope=20
this helps.</FONT></SPAN></DIV>
<P><FONT face=3DArial size=3D2>Tom Mercadante</FONT> <BR><FONT =
face=3DArial=20
size=3D2>Oracle Certified Professional</FONT> </P>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
  <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT = face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> David Wagoner=20   [mailto:dwagoner_at_arsenaldigital.com]<BR><B>Sent:</B> Thursday, July = 17, 2003=20
  2:59 PM<BR><B>To:</B> Multiple recipients of list = ORACLE-L<BR><B>Subject:</B>=20
  Physical Design Question<BR><BR></FONT></DIV>   <P><FONT face=3DArial size=3D2>Here's my situation:</FONT> </P>   <P><FONT face=3DArial size=3D2>Damagement wants us to move 4 small = production DBs=20
  to one server to save on licensing costs.  Server is a Sun E4500, = 4 CPUs,=20
  8 GB RAM.  There is a pair of internal disks that are mirrored = with=20
  enough room for Solaris, swap, and 1 Oracle Home.  There are 3 = A1000 disk=20
  arrays (12 x 18 GB drives each), all set to RAID 1+0 using the = S.A.M.E.=20
  approach.</FONT></P>
  <P><FONT face=3DArial size=3D2>Questions:</FONT> </P>   <P><FONT face=3DArial size=3D2>1.  Should I use a separate Oracle = Home for=20
  each DB?  </FONT></P>
  <P>        <FONT face=3DArial=20   size=3D2>Pros:   --Allows upgrade/patching of 1 DB at a time = without=20
  affecting others (some are home-grown, some are 3rd party).  =
</FONT></P>

  <P>        <FONT face=3DArial=20   size=3D2>Cons:  --Takes up more space, but space is not a major = concern.=20
  </FONT><BR><FONT face=3DArial=20
  =
size=3D2>          &nbs= p;           =20   --I'll have to put some Oracle Homes on the A1000s with the data files = (i.e.,=20
  concerns about disk contention).</FONT></P>   <P><FONT face=3DArial=20
  =
size=3D2>          &nbs= p;           =20   --Requires applying multiple upgrades/patches</FONT> </P><BR>   <P><FONT face=3DArial size=3D2>2.  Should I put 1 DB per A1000? = (Actually, 1=20
  A1000 would hold 2 of the least active DBs.)</FONT> </P>   <P>        <FONT face=3DArial=20   size=3D2>Pros:  --Easier to determine performance problems b/c = each DB is=20
  isolated on 1 A1000.</FONT> <BR><FONT face=3DArial=20   =
size=3D2>          &nbs= p;          =20   --If one controller dies, it only affects 1 DB.</FONT> </P>   <P>        <FONT face=3DArial=20   size=3D2>Cons:  --Only get throughput of 1 controller; could use = 3=20
  controllers if data files spread across 3 A1000s. </FONT></P><BR>   <P><FONT face=3DArial size=3D2>Anyone with experience doing this, = please share=20
  your tips, tricks, and gotchas!</FONT> </P><BR>   <P><FONT face=3DArial size=3D2>Best regards,</FONT> </P> Received on Thu Jul 17 2003 - 14:00:26 CDT