Hi Mike,
If you are running EMC hardware, there are several utilities you can use to determine if EMC's cache is performing up to par. There are also utilities to alleviate any i/o contention that may appear if the EMC cache does not take care of i/o problems. I can't tell you exactly what they are though, the sysadmins used them, not me. I've worked in two places where we ran EMC hardware (symmetrix) and was told it should not make a difference if you follow the standard or not from an i/o point of view. However, I just couldn't get over the thought that "i/o will never be a problem".
Add to it I've heard contradicting stories from EMC support staff, in MN and here in FL. I think there is still merit to mapping all the way back into the physical controllers in the symmetrix, but it's a royal pain in the behind. When the EMC guy talked through it, it was difficult for me to follow. I still have the documentation but I couldn't tell you exactly what it meant. (I am not an SA !!) It's a lot of work for what little performance boost you may see.
If you are interested in seeing this tuning software (I'm not talking about Precise/SQL DBTuner, it's lower level than that) I'd suggest contacting your EMC support staff.
Sorry I couldn't be more specific, but I can tell you I've set up databases both ways (OFA and not) and haven't experienced huge i/o problems.
Lisa Rutland Koivu
Oracle Database Administrator
Certified Self-Important Database Deity
Slayer of Unix Administrators
Wanton Kickboxing Goddess
[EMAIL PROTECTED]
NeoMedia
2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434
Fax: 941-337-3668
www.neom.com <http://www.neom.com>
www.paperclick.com <http://www.paperclick.com>
www.qode.com <http://www.qode.com>
P a p e r C l i c k . c o m <http://www.paperclick.com/home.htm>
Enter Your PaperClick Code Here!
-----Original Message-----
From: Lanteigne, Mike [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 27, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L
Subject: OFA and SAN - Why not group all db files on its own mount
point?
Hello List,
I'm planning an upgrade of four databases on one server from 7.3.4 to 8.1.7
on Solaris. We are in the initial stages of implementing a Storage Area
Network (SAN) project, initially 10TB on EMC hardware. The database server
will use the SAN for its storage so I will have no decision on where
datafile are actually stored (those involved in a SAN implementation know
what I mean).
So... I'm looking at the OFA docs - where datafiles from different databases
are on different mount points mostly for I/O purposes e.g.:
Non SAN OFA:
md03/
oradata/
db_1/
system01
data01
control01
redoG1M1
redoG2M1
db_2/
system01
data01
control01
redoG1M1
redoG2M1
md04/
oradata/
db_1/
index01
temp01
control02
redoG1M2
redoG2M2
db_2/
index01
temp01
control02
redoG1M2
redoG2M2
........
In a SAN implementation, it seems to me that since I/O is no longer a
parameter I can control, why not group each database on its own mount point
e.g.:
md03/
oradata/
db_1/
system01
data01
index01
temp01
control01
control02
redoG1M1
redoG1M2
redoG2M1
redoG2M2
md04/
oradata/
db_2/
system01
data01
index01
temp01
control01
control02
redoG1M1
redoG1M2
redoG2M1
redoG2M2
I know it looks scary. Lets say I separate the control files on separate
mount points. In reality the SAN puts the files all over the place, making
copies on multiple volumes, so I think I'm fooling myself by thinking I'm
buying anything by using separate mount points.
Any thoughts? Anyone set up a dir structure using a SAN. Admin seems simpler
the second way.
Thanks
Mike Lanteigne
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Lanteigne, Mike
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
