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 RAID5 when our main
problem on the database is the amount of time it takes to do our monthly
loads? Wouldn't that slow down all the inserts?
Unfortunately putting redo on dedicated disks will not be approved due to
the wasted space. I'd love to do it but...
You're probably right about not bothering to put the archive logs on the
outer portion of the disk. Thinking it over that doesn't seem necessary.
Comments from anyone else on what might profitably inhabit that valuable
disk real estate? Rollback segments perhaps? Temp? Or just not bother to
specify anything?
Jay Miller
Sr. Oracle DBA
-----Original Message-----
Sent: Saturday, September 27, 2003 4:50 AM
To: Multiple recipients of list ORACLE-L
Hi,
Since it seems that your data can be loaded again easily via night batch
load, why not consider noarchivelog mode?
SAME is better than your disk partition policy ,I think. You have
limited number of disk, seperate your limited number of disks for dedicated
redo/archive maybe is not a good idear.
And using outer part of the disk maybe become much more complicated when
raid is in use.Do you know the underlying raid policy?
Another possible solution I will consider is put redo on mirrored disk(2
disks) and everything else on raid5. This max the daily read performance and
does not affect the nightly loading.Archive log is not relavant to
performance of read and loading,unless archive process is unable to catch
the speed of redo generation.I won't put valuable disk resource to
archivelog.
Zhu Chao.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
