ASM # of Files
Date: Thu, 15 May 2008 14:15:32 -0400
I will be setting up several databases that will be utilizing 10g ASM on Solaris 10 - some RAC, some non-RAC. I am blessed to be given a fairly clean SAN for this purpose. However, one limitation has been placed on me: the size of the files presented to ASM will be limited to 33G due to DR requirements. While considering how large the DW database may become, I began to wonder about ASM performance with the 33G file size limitation.
I can't find the limit to the total number of files ASM can manage. The only limitation I found was that a diskgroup is limited to 10k (or was it 1k?) files - probably more than I will manage in the next few years for this implementation.
What is the largest number of files you have in ASM (regardless of size)?
Have you encountered a performance issue due to the number of files ASM is managing?
If so, how did you determine that ASM was the culprit?
If there is some evidence that ASM performance declines after a number of files, I could probably assemble resources for a test.
All suggestions, anecdotes, links to documentation I may have missed, and witty comments are welcomed.
Oracle Database Administrator
Starwood Vacation Ownership
Orlando, FL, USA
This electronic message transmission contains information from the Company that may be proprietary, confidential and/or privileged. The information is intended only for the use of the individual(s) or entity named above. If you are not the intended recipient, be aware that any disclosure, copying or distribution or use of the contents of this information is prohibited. If you have received this electronic transmission in error, please notify the sender immediately by replying to the address listed in the "From:" field.Received on Thu May 15 2008 - 13:15:32 CDT