RE: ASM # of Files
- From: <krish.hariharan@xxxxxxxxxxxx>
- To: <Lisa.Koivu@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 15 May 2008 14:01:08 -0600
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Koivu, Lisa
Sent: Thursday, May 15, 2008 12:16 PM
To: oracle-l@xxxxxxxxxxxxx
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.
Other related posts:
