RE: ASM # of Files

My experience is with building using LUNS that are roughly 45G in size and saw the database grow from 0 to about 20TB in a span of about 4 months while at the same time supporting the application and queries. So my experience is that ASM handles this extremely well although a lot of LUNS from what I understand can affect boot times (boot with reconfig, IIRC). I can't remember how many devices there were but it was a whole lot of them and neither the OS nor ASM was particularly affected by it (a bit of head in the sand approach since there were no effects that were perceptible). Since your horizon is a few years I would think this should be ok since swapping out devices from under the disk groups is not difficult either which I have done to move from 45G to 200G devices of a different kind.  

-Krish
 

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Koivu, Lisa
Sent: Thursday, May 15, 2008 12:16 PM
To: oracle-l_at_freelists.org
Subject: ASM # of Files  

Hola Amigos,  

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.  

Thanks!  

Lisa Koivu

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.

--

http://www.freelists.org/webpage/oracle-l Received on Thu May 15 2008 - 15:01:08 CDT