ASM questions
Hi All,
I had a couple of ASM questions.
1) Does ASM really readuce the storage requirements for a database? What I mean to ask is...that is it true that if your db is 100gb under lets say ASSM. If you convert you db to ASM, will it reduce it to lets say 85Gb?
2) Does ASM automatically de-fragment/coelesce your tablespaces/tables?
3) Are there any benchmarks for ASM vs ASSM as far as performance and storage optimization is concerned? If no benchmarks, what has been the experience of people using ASM on PROD enviorments.
Thanks in advance
When in doubt ...go to the basics!!