Re: file layout preference

--0-1477171087-977234880=:19313
Content-Type: text/plain; charset=us-ascii

 With only three disks, #1 is probably your best bet.

  Kate Monro <KMonro_at_extend.com> wrote: I only have 3 sets of mirrored disks available (have to be mirrored). What would be the best set-up for a single purpose application averaging about 100 hits per second, equal read & writes, Sun E250 dual processor? I'm guessing #1 so that I have a bit of leeway with IO balancing - any comments?

• 1GB RAM if possible (get all data in the buffer cache)
• minimal indexing
• use locally managed table spaces to minimize io contention with SYSTEM
• temp & users aren't used much if at all

#1 disks mirrored only
db1 os, software, archived logs
db2 indexes, system, online redo logs
db3 data, rbs, temp, users

#2 db1 mirrored, db2 is 4 disks striped and mirrored db1 os, software, archived logs
db2 data, indexes, system, rbs, online redo logs, temp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kate Monro
INET: KMonro_at_extend.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).


---------------------------------
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
--0-1477171087-977234880=:19313
Content-Type: text/html; charset=us-ascii



<P> With only three disks, #1 is probably your best bet.<BR>

<P>&nbsp; <B><I>Kate Monro &lt;KMonro_at_extend.com&gt;</I></B> wrote: <BR>

<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">I only have 3 sets of mirrored disks available (have to be mirrored). What<BR>would be the best set-up for a single purpose application averaging about<BR>100 hits per second, equal read &amp; writes, Sun E250 dual processor? <BR>I'm guessing #1 so that I have a bit of leeway with IO balancing - any<BR>comments?<BR><BR>- 1GB RAM if possible (get all data in the buffer cache)<BR>- minimal indexing<BR>- use locally managed table spaces to minimize io contention with SYSTEM<BR>- temp &amp; users aren't used much if at all<BR><BR>#1 disks mirrored only<BR>db1 os, software, archived logs<BR>db2 indexes, system, online redo logs<BR>db3 data, rbs, temp, users<BR><BR>#2 db1 mirrored, db2 is 4 disks striped and mirrored<BR>db1 os, software, archived logs<BR>db2 data, indexes, system, rbs, online redo logs, temp<BR><BR><BR><BR><BR><BR>-- <BR>Please see the official ORACLE-L FAQ: http://www.orafaq.com!

<BR>-- <BR>Author: Kate Monro<BR>INET: KMonro_at_extend.com<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br>

<a href="http://shopping.yahoo.com/">Yahoo! Shopping</a> - 

Thousands of Stores. Millions of Products.