RE: ASM Risk / Rewards

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of steve montgomerie
Sent: Thursday, August 30, 2007 8:00 AM
To: oracle-l_at_freelists.org
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  

--
http://www.freelists.org/webpage/oracle-l