RE: Reality check for filesystem/disk layout

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: JayMiller_at_tdwaterhouse.com

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: 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).