This database is required to be 7x24 so we have to run in archivelog mode
(no cold backups).
My concern with SAME is that we may very well end up with a lot of io
contention when we're having large data loads and large sorts happening at
the same time. And would you really put data files on
Hi April,
A few years ago in London for a large finance group a colleague and I
did a similar job where we used veritas on sun 4500 and 5200 storedge
arrays to specify which parts of the physical discs were used so we
could control physical locations. We had similar constraints, huge
amounts of
have the luxury of moving a 300G database to a new box that's being
built and choosing the specifications, disk layout, striping, etc.
After spending
the morning poring over Cary Millsap's wonderful VLDB paper this is
what
we're thinking of but I'd appreciate any comments.
One
Title: Message
We
have the luxury of moving a 300G database to a new box that's being built and
choosing the specifications, disk layout, striping, etc. After
spendingthe morning poring over Cary Millsap's wonderful VLDB paper
this is what we're thinking of but I'd appreciate any
comments
for filesystem/disk layout
We
have the luxury of moving a 300G database to a new box that's being built and
choosing the specifications, disk layout, striping, etc. After
spendingthe morning poring over Cary Millsap's wonderful VLDB
paper this is what we're thinking of but I'd appreciate
of moving a 300G database to a new box that's being built
and choosing the specifications, disk layout, striping, etc. After spending
the morning poring over Cary Millsap's wonderful VLDB paper this is what
we're thinking of but I'd appreciate any comments.
One of my main goals going
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mladen Gogala
Sent: Friday, September 26, 2003 3:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Reality check for filesystem/disk layout
Can you remind me, what is readahead good for on redo files?
I believe
Jay,
I'd like to see (for my enlightenment) a brief rationale for your
decisions, if you have time. Thanks!
--- [EMAIL PROTECTED] wrote:
We have the luxury of moving a 300G database to a new box that's
being built
and choosing the specifications, disk layout, striping, etc. After
spending
- From: Paul
Baumgartel [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 26, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Subject: Re: Reality check for filesystem/disk layout
Jay,
I'd like to see (for my enlightenment) a brief rationale for
your decisions, if you have
recipients of list ORACLE-L
Jay,
I'd like to see (for my enlightenment) a brief rationale for your decisions,
if you have time. Thanks!
--- [EMAIL PROTECTED] wrote:
We have the luxury of moving a 300G database to a new box that's being
built and choosing the specifications, disk layout
Title: RE: Deleting files on w2k
Hi,
We have to performance benchmark test for our application .
We have to check only scalibiliy and performance and not much concern for
reliablity.
We have 10 36G hard disks(Fiber Channel array) and 2 18G(Internal boot
disks).4 400MHZ cpu's
Expected
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
Hi,
We have to do benchmarks tests(scalability,performance) for our product and
have machine with following
configuration..We dont have experience for large size databases layout.
It will be greatly appreciated if someone points out from his experience:
1) Which raid level to use for which
To: Multiple recipients of list ORACLE-L
Harvinder.Si[EMAIL PROTECTED]
ngh cc:
@MetraTech.coSubject: DISK LAYOUT
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
decided that the
22-disk layout just doesn't work for us. With only two 4-way stripe sets,
we get vastly superior I/O thruput that more than compensates for any
contention on any of the stripes.
Yes, yes, I understand that with mirroring the total drive count is 16. But
since this is only a volatile
: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
After many DB copies, loads, reloads, upgrades, etc., I've decided that the
22-disk layout just doesn't work for us. With only two 4-way stripe sets,
we get vastly superior I/O thruput that more than compensates for any
contention on any of the stripes.
Yes, yes, I understand
:
@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
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
detailing preferred file layouts based on different number of disks --
e.g. 4 disks try this, with 5 disks try that.
Does that ring a bell?
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
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: http://www.orafaq.com
--
Author: Steven Hovington
INET: [EMAIL PROTECTED]
Fat City Network Services--
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:
Hi,
I'm encuntering a relatively high iowait percentage
when my hot backups are running. The platform is Sun
(E420 2cpu running SunOS 5.7) with an A1000 disk array
(8 9Gb drives, hardware Raid-5). The array is one
volume and all DB components (redo, archive, data,
index, system, etc.) are on the
1. depends on the stripe width, data may be on one or many drives, parity
will always get written to all.
2. I believe your performance will be better; you have 6 drives for data,
and 4 for archive/redo. That equates to 12 drives over the previous 8.
However, you were using all eight for
Isn't it 3 drives for data, not 6, because of the
mirroring? I agree, mirroring the extra 4 (9Gb) drives
isn't necessary because this can be accomplished via
the DB config.
Veritas is also being used on the existing array and
the sys admin seems to think that we've got extra
overhead for that on
Hi Walter,
It looks like you're having a bottleneck on your
controller during a hot backup. This is a result of
(1) reading the data then (2) writing the data and
compressing the data within the same controller.
To answer your questions:
1. During RAID 5, all your disks are being written to
and
Hi
Which Unix command is used to see disk layout in sun cluster and veritas
cluster on sun solaris?
Thanks in advance.
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official
PROTECTED]]Sent: Monday, July 02, 2001 7:31
PMTo: Multiple recipients of list ORACLE-LSubject: Disk
layout for datafiles
I found and then lost a Metalink
document about laying out datafiles underfive or seven mount points.
Does anyone have a link to this note, or any regarding dataf
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
I found and then lost a Metalink document about laying out datafiles
underfive or seven mount points. Does anyone have a link to this note, or
any regarding datafile naming conventions/path layouts for unix/sun?
Thanks, Linda
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
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
44 matches
Mail list logo