Why are some DBA's averse to using ASM?
We are upgrading to 11GR2 from 10G and are looking at the pros and cons of using ASM vs AIX JFS2. We are currently on HP-UX on Itanium and it's easy to guess why we are considering moving to AIX. We only have single instance databases and have no plans for using RAC. Half the DBA's in our organization are averse to using ASM citing complexity among other reasons. We asked a few other DBA's in other organizations we knew and were told that they too only use ASM for RAC and avoid it for single instance databases. I think ASM should be used for all Oracle databases esp 11G due to the obvious benefits.
I looked at the polling for ASM on this forum and see that more DBA's are now using ASM for Single Instance Databases. But then I wonder why many don't? Any comments are appreciated.
"Which Oracle DB configuration do you currently use with ASM?
Votes: 176
40% RAC database only
13% Single Instance databases only
28% More RAC databases than Single Instance database
8% More Single Instances databases than RAC databases
9% Not yet using ASM "
Edited by: user4397602 on Jun 19, 2012 10:10 PM