RE: Diskgroups for redo, controlfiles, and temp?
Date: Wed, 7 May 2014 14:56:28 +0000
Message-ID: <1AFD62082EEAF0448EF1815139687F131F76AE19_at_NC2PWEX504.us.ad.lfg.com>
I don't think that simply splitting these out will cause a performance improvement unless the back-end disks supporting the disk groups are physically separated, tiered, or of the SSD variety. Putting all your files into different containers (disk groups) with the containers all being on the same aggregate gains you nothing in performance.
We split ours out into DATA, CTL, ARCH, REDO, and TEMP though because we utilize snap technology. REDO and TEMP and shared if we have multiple databases on the machine/cluster. DATA, CTL, and ARCH will be dedicated to a each database.
Chris..
Chris Ruel * Oracle Database Administrator cruel_at_lfg.com * Desk:317.759.2172 * Cell 317.523.8482
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Herring, David
Sent: Wednesday, May 07, 2014 10:32 AM
To: oracle-l_at_freelists.org
Subject: Diskgroups for redo, controlfiles, and temp?
Folks,
Has anyone ever run into blogs that have demostrated large performance gains, when on a SAN, by splitting out redo, controlfiles, and temp onto their own diskgroups? I don't recall ever seeing this as a best practice and in this periodic discussion brought up to our group I believe has agreed. I'm getting pressure from an outside resource to split out these file types for performance reasons yet haven't received anything specific to explain why and the arguments presented have been high level and similar to arguments from long ago on older hardware.
Dave Herring
--
http://www.freelists.org/webpage/oracle-l
Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 07 2014 - 16:56:28 CEST