RE: ASM Risk / Rewards
- From: "Randy Johnson" <oraclelist@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 4 Sep 2007 21:05:59 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of steve montgomerie
Sent: Thursday, August 30, 2007 8:00 AM
To: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
