Re: What do others do for database file mounts
Date: Fri, 13 Feb 2015 13:44:23 -0500
Message-ID: <54DE4607.1040907_at_yahoo.com>
On 02/13/2015 12:13 PM, Cohen, Andrew M. wrote:
>
> Hello List,
>
> We are moving to Fibre Channel connections with all of our storage on
> a Net App storage unit. One of the questions we got from our system
> admins was if we could limit the number of mounts that they provide us
> for out datafiles. With the newer disk technology that we all use, is
> it still important to segregate mounts for redo, CFs, datafiles,
> Archive logs, etc? I know Oracle stands firm that best practices are
> to segregate these files into separate mounts. I’m wondering what
> others do and if there is a compelling reason to continue this practice?
>
> Thanks,
>
> Andy
>
If you talk about performance, LUN presented by a SAN contraption like
NetApp filer is not a single disk and doesn't behave like one, either.
It is just an amount of storage cut from the available storage pool.
With thin provisioning it may be allocate on the fly. Personally, I
usually put all of the files on the single mount, if at all possible. It
saves me some pain and grief when doing snapshots.
The most important questions are the questions about the FC throughput:
do you have brand new 16GB FC HBA cards, is by any chance a dual
connection card and what kind of throughput can you get from your NetApp
filer? If you have a 5TB LUN, it will be very easy to snap it, and the
performance will depend on the number of IOPS that your filer is able to
support. NetApp filers are very sophisticated devices and come with
significant cache, command queueing and many other characteristics. What
NetApp licenses will you have and how many filers will you have? There
are things lilke "FlexClone", "SnapMirror" and "SnapVault" licenses?
Will you have unified on-command manager, the artist formerly known as
DFM? Also, NetApp filer can provide you significant savings with the
Oracle licensing.
Regards,
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 13 2015 - 19:44:23 CET