RE: Diskgroups for redo, controlfiles, and temp?

From: "Herring, David" <HerringD@xxxxxxx>
To: "Ruel, Chris" <Chris.Ruel@xxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 7 May 2014 10:00:58 -0500

Chris, good point about doing snaps and having separate diskgroups.

Dave Herring

-----Original Message-----
From: Ruel, Chris [mailto:Chris.Ruel@xxxxxxx] 
Sent: Wednesday, May 07, 2014 9:56 AM
To: Herring, David; oracle-l@xxxxxxxxxxxxx
Subject: RE: Diskgroups for redo, controlfiles, and temp?

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

References:
- Diskgroups for redo, controlfiles, and temp?
  - From: Herring, David
- RE: Diskgroups for redo, controlfiles, and temp?
  - From: Ruel, Chris

RE: Diskgroups for redo, controlfiles, and temp?

Other related posts: