Well I think it's time for you to start reading papers discussing OFA
(Optimal Flexible Architecture).
http://technet.oracle.com/doc/oracle8i_816/linux_816/unixdoc/a82848/a82846/a
ppa_ofa.htm
The above link is for the LINUX OFA document, but the concepts are the same,
and you will probably find
http://technet.oracle.com/deploy/performance/pdf/opt_storage_conf.pdf
Harvinder
Singh
Hi Harvinder,
If I were you I would
- put OS and Oracle executables on a RAID1 volume with minimal raid block size
- put redo log files in chess order on two dedicated RAID1 volumes (the odd redo
groups locate on
the first volume and the even redo groups locate on the second RAID1 volume). It
: RE: Disk Layout Document
I believe the Oracle DBA Handbook by Kevin Loney has that...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
:32 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Disk Layout Document
I believe the Oracle DBA Handbook by Kevin Loney has that...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Larry Elkins
INET: [EMAIL PROTECTED]
Fat City
PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Disk Layout Document
I believe the Oracle DBA Handbook by Kevin Loney has that...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
Fat City Network
:
@gmd.fujitsu.Subject: RE: Disk Layout Document
com
Sent by: root
To: Multiple recipients of list
ORACLE-L
kimberly.smi[EMAIL PROTECTED]
th cc:
@gmd.fujitsu.Subject: RE: Disk Layout
Document
com
Sent by: root
I believe the Oracle DBA Handbook by Kevin Loney has that...
-Original Message-
Sent: Wednesday, November 14, 2001 3:45 PM
To: Multiple recipients of list ORACLE-L
Listers,
Okay, I've been googling for about an hour now and can't find it. It seems
like I remember seeing a white paper,
: '[EMAIL PROTECTED]'
Subject: RE: Disk Layout Document
I believe the Oracle DBA Handbook by Kevin Loney has that...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Larry Elkins
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
Larry,
There is some discussion of this in the Designing and Tuning for
Performance docs at:
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76992/ch20_io.htm#11672
URL will probably wrap. I'm sure this isn't exactly what you want, but
its a good start.
Scott
dba handbook -- Kevin had a section on you should have 22 disks, then
no, 17, then no 9..
--- Larry Elkins [EMAIL PROTECTED] wrote:
Listers,
Okay, I've been googling for about an hour now and can't find it. It
seems
like I remember seeing a white paper, note, or some sort of reference
:32 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Disk Layout Document
I believe the Oracle DBA Handbook by Kevin Loney has that...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Larry Elkins
INET: [EMAIL PROTECTED]
Fat City
From: Steven Hovington [EMAIL PROTECTED]
Date: Wed, 3 Oct 2001 14:33:52 +0100
Subject: Disk layout
Could anyone please point me towards documentation which discusses optimum
disk layouts for Oracle databases.
Some other useful sources:
http://www.ipass.net/~davesisk/oont_config_bpft.htm
DBA Handbook if I remember had a nice section on disk layouts starting out
with preferred and scaled down.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978)
It's real easy, pay close attention...
Put every Oracle object on it's own disk drive and
controller. If your table is too huge and you must use
more than one disk drive, then make sure that each
disk drive has it's own disk bus. Larry will then come
to your site and run benchmark testing and
encoded content removed -- binaries not allowed by ListGuru
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender
Here's a good one:
http://www.quest.com/whitepapers/Raid1.pdf
Steven Hovington wrote:
Could anyone please point me towards documentation which discusses optimum
disk layouts for Oracle databases.
Thanks in advcance.
Steven.
--
Please see the official ORACLE-L FAQ:
It's
called the Optimal Flexible Architecture, or OFA (pronounced "ofa"). A Google
search brings up lots of resources onit:
http://www.google.com/search?q=Optimal+Flexible+Architecturehl=xx-borklr=lang_en
g
-Original Message-From: Hagedorn, Linda
[mailto:[EMAIL
03,
2001 4:50 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Disk layout for
datafiles
It's called the Optimal Flexible Architecture, or OFA
(pronounced "ofa"). A Google search brings up lots of resources
onit:
http://www.google.com/search?q=Optimal+Flexible
I
thought OFA was short for Oh Freakin Eh
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 03, 2001 1:06
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Disk layout for datafiles
Pronounced "ofa?" I've always
ORACLE-LSubject: RE:
Disk layout for datafiles
Pronounced "ofa?" I've always pronounced it "Oh Eff Ay."
Does
this
say something about my certification? Or is it a 9i thing?
:-)
I
need a job. Pronounced "job."
Yosi
-Original
Search
under "OFA" or "Optimal Flexible Architecture" for a wealth of information.
-Original Message-From: Hagedorn, Linda
[mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 2:31
PMTo: Multiple recipients of list ORACLE-LSubject: Disk
layout for datafiles
I found
Thank
you Ross.
-Original Message-From: Mohan, Ross
[mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 12:25
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Disk layout for datafiles
Search under "OFA" or "Optimal Flexible Architectur
24 matches
Mail list logo