RE: Diskgroups for redo, controlfiles, and temp?

  • From: "Ruel, Chris" <Chris.Ruel@xxxxxxx>
  • To: "HerringD@xxxxxxx" <HerringD@xxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 7 May 2014 14:56:28 +0000

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@xxxxxxx * Desk:317.759.2172 * Cell 317.523.8482


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Herring, David
Sent: Wednesday, May 07, 2014 10:32 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//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.**

--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2014