 | | | ASM Risk / Rewards | ASM Risk / Rewards 2007-09-04 - By Randy Johnson
Back
I'd suggest that there is enough reward in going to ASM in a single instance
server. Your most obvious benefits will be even distribution of data across
all spindles. Its like folding all your filesystems into one. You get even
distribution of data across all spindles while enjoying the benefit of
elimnating slack space for each filesystem. If you ever decide to add
another database to a single instance server you will be able to do so
without having to consider a file layout.
There are many other manageability and performance benefits but these are a
couple of my favorites. There is a bit of a learning curve but once you get
used to it you will wonder why it took you so long to make the move.
-Randy
__ __
From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]
On Behalf Of steve montgomerie
Sent: Thursday, August 30, 2007 8:00 AM
To: oracle-l@(protected)
Subject: ASM Risk / Rewards
Good day,
We're doing the PeopleSoft upgrade thing which includes an upgrade from
Oracle 9i to 10G Rel2.
Our environment will be Windows 2003 with RAC 10G.
As part of the upgrade I see from the Oracle Docs that Oracle recommends
using ASM. I've been reading researching and testing
on a smaller machine getting read for the new hardware.
I'm to the conclusion that ASM would only help with the disk rebalancing
feature. The environment is only 1 database on RAC so
provisioning does not buy me much from my point of view. Yes I understand
that ASM is RAW, like RAW or whatever. However
if I wanted to get RAW like performance then I could just use RAW.
Yes, there is a question in this rant.
Are the rewards of ASM appreciable enough for me to implement it on the new
system?
If I do ASM on RAC should I do ASM in the non clustered test environments
just to be consistent.
Do you have any feedback on your production ASM experiences?
Thanks for any feedback.
Steve
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.484 / Virus Database: 269.12.12/979 - Release Date: 8/29/2007
8:21 PM
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.485 / Virus Database: 269.13.5/988 - Release Date: 9/4/2007
9:14 AM
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1250 (See http://ows-1250.ora-code.com)">
<META content="MSHTML 6.00.6000.16525" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=875595801-05092007>I'd suggest that there is enough reward in going to
ASM
in a single instance server. Your most obvious benefits will be even
distribution of data across all spindles. Its like folding all your filesystems
into one. You get even distribution of data across all spindles while enjoying
the benefit of elimnating slack space for each filesystem. If you ever decide
to
add another database to a single instance server you will be able to do so
without having to consider a file layout.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=875595801-05092007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=875595801-05092007>There are many other manageability and performance
benefits but these are a couple of my favorites. There is a bit of a learning
curve but once you get used to it you will wonder why it took you so long to
make the move.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=875595801-05092007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=875595801-05092007> -Randy</SPAN></FONT></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] <B>On Behalf Of </B>steve
montgomerie<BR><B>Sent:</B> Thursday, August 30, 2007 8:00 AM<BR><B>To:</B>
oracle-l@(protected)<BR><B>Subject:</B> ASM Risk /
Rewards<BR></FONT><BR></DIV>
<DIV></DIV>Good day,<BR>We're doing the PeopleSoft upgrade thing which includes
an upgrade from Oracle 9i to 10G Rel2.<BR><BR>Our environment will be Windows
2003 with RAC 10G.<BR><BR>As part of the upgrade I see from the Oracle Docs
that
Oracle recommends using ASM. I've been reading researching and testing <BR>on a
smaller machine getting read for the new hardware.<BR><BR>I'm to the conclusion
that ASM would only help with the disk rebalancing feature. The environment is
only 1 database on RAC so <BR>provisioning does not buy me much from my point
of
view. Yes I understand that ASM is RAW, like RAW or whatever. However <BR>if I
wanted to get RAW like performance then I could just use RAW.<BR><BR>Yes, there
is a question in this rant.<BR><BR>Are the rewards of ASM appreciable enough
for
me to implement it on the new system?<BR><BR>If I do ASM on RAC should I do ASM
in the non clustered test environments just to be consistent. <BR><BR>Do you
have any feedback on your production ASM experiences?<BR><BR>Thanks for any
feedback.<BR><BR>Steve<BR><BR><BR><BR>
<P><FONT size=2>No virus found in this incoming message.<BR>Checked by AVG Free
Edition.<BR>Version: 7.5.484 / Virus Database: 269.12.12/979 - Release Date:
8/29/2007 8:21 PM<BR></FONT></P></BODY></HTML>
<BR>
<P><FONT SIZE=2>No virus found in this outgoing message.<BR>
Checked by AVG Free Edition.<BR>
Version: 7.5.485 / Virus Database: 269.13.5/988 - Release Date: 9/4/2007 9:14
AM<BR>
</FONT> </P>
|
|
|