| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: hard disk configuration question
Resending the email (it bounced back with a "locking" problem) at fatcity.
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
----- Forwarded by CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group on
19/12/2001 11:48 AM -----
CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group 19/12/2001 11:07 AM
Where are you putting the RDBMS and application code ? Best mirror the two
internal disks and put the RDBMS and application code there.
You could also consider putting your Redo Logs --- particularly if you have
a RAID-5
array, it would definitely be better to put your Redo Logs on mirrored
disks seperate
from the database files.
How naive and honest the engineer was ....
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
"Steve McClure" <smcclure_at_usscript.com> 19/12/2001 10:25 AM Sent by: root_at_fatcity.com
Well we had our meeting with the Hitachi Sales "critter", and engineer. I
discovered that they were trying to push a 5 disk raid array and one hot
spare at us, because my IT director was really trying to squeeze them on
the
price of my 10 18GB disk configuration. After the sales guy and engineer
went on about how their 4 separate IO paths would make our raid 5 perform
as
well as any mirrored pair, I got to ask a few questions. Well it turns out
that their RAID performs that well with extra large database block sizes.
When I pointed out that we currently have a block size of 2k(I didn't build
the db), and would be rebuilding the database on the new platform with 8k
blocks, he said that "with a small block size like 8k you will really get
the best performance out of mirrors or a 1+0". I am sure the sales guy
kicked him under the table ;-).
The end result is this. We will probably go with the 6 36 GB DISKS. It
flat out comes down to the cost of the whole system is just a little over
budget, and the drives are where the adjustment gets made. I suspect that
I
will have much less trouble getting a few extra disks once the system is in
the building. I may also mess with things a bit and configure a 1+0 and a
mirrored pair.
So after that discussion, and all your helpful input I still have two questions.
First what use are the two internal drives that aren't in the disk array? Someone suggested to "WRT" them, and I am not familiar with that term. Again I am not sure I want to mirror them, and if they aren't redundant how useful can they really be?
Second. If an 8k database block size is tiny, what is a large database block size? 8k is as large as I can go without raw file systems, isn't it?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: smcclure_at_usscript.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: hemantchitale_at_charteredsemi.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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). Received on Tue Dec 18 2001 - 22:17:59 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |