RE: 11 disks to build a DB, suggestions

Hi Rahul, and Yosi

I misunderstood you Rahul I'm sorry, you need both redo logs (log01 and log02, these are different redo goups and not different members of the same group, as I thought) (Yosi is right about this, off course)

Now according to this information, I'll be still consistent with my first mail. I would place redo logs (both groups) in a dedicated disk over Raw Devices.
Of course, after the application starts running I would take performance statistics in order to verify that disk I/O is balanced and that there isn't a spot disk (I mean a disk that gets too much I/O).

"> also, do u have to make ALL of a disk as RAW or can i make only a part of
> the disk as RAW ? "

Yes, you can have for example redo logs and some datafiles as raw and the others over FS.

greetings
DC

• Original Message ----- To: <dcutrone_at_afip.gov.ar> Sent: Thursday, July 05, 2001 12:55 AM

> Diego, thanks for the reply...
>
> D1 is "almost" dedicated..as after the first load... that partitioned will
> be used
> rarely....
>
> another question.......can i have only one logfile ??? or oracle requires
> minimum of 2 ?
> also, do u have to make ALL of a disk as RAW or can i make only a part of
> the disk as RAW ?
>
> Regards
>
> Rahul
>
>
> > ----------
> > From: Diego Cutrone[SMTP:dcutrone_at_afip.gov.ar]
> > Reply To: ORACLE-L_at_fatcity.com
> > Sent: Wednesday, July 04, 2001 4:06 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: 11 disks to build a DB, suggestions
> >
> > Hi Rahul,
> > Here's what I think.
> > I would eliminate log02 , because redo log files are already
mirrored
> > (D1 is mirrored right?)
> > Another recomendation is to use RAW for the redo logs.
> > By eliminating log02, and according to your load "(600,000 rows
using
> > sql*loader) every night", I think
> > you are going to improve performance a lot.
> > If you can't use RAW for the REDO, at least try to use aync I/O or
> > direct I/O on these filesystems.
> > I would create only one control file mirrored by hardware too.
> > Also if your internal disks are faster than the external ones, I
would
> > place redo logs over the faster disks. And
> > I'd leave D1 dedicated to redo logs in order to eliminate seek
times.
> >
> > please someone correct me if I'm wrong
> >
> > hope it helps
> > greetings
> > Diego
> >
> >
> >
> >
> > ----- Original Message -----
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Sent: Tuesday, July 03, 2001 7:25 AM
> >
> >
> > > List,
> > > i have been given 11 Hdisks (36GB each) to build a database (816)
> > > the DB involves heavy loads (600,000 rows using sql*loader) every
night.
> > >
> > > three drives are internal and the rest are external.
> > >
> > > main table involved is SALES , which i have partitioned by year 2000,
> > 2001
> > > and a scratch
> > > partitioned to hold any other years sales data (which i will split
> > later)
> > >
> > > the DB will be running in NOARCHIVELOG, to provide some guard against
> > > failure i plan
> > > to mirror (1:1) 4 drives, which leaves me with 7 drives to use.
> > >
> > > D1 to D4 are mirrored. D5,D6,D7 are NOT mirrored
> > >
> > > D1 -> log01 + SALES DATA FOR 2000 (keeping this partition with the
log
> > > because 2000 sales data wil not be queried often)
> > >
> > > D2 -> DATA1 + DATA2 + SALES DATA FOR 2001
> > >
> > > D3 -> SALES SCRATCH + log02 ( this scratch partition will be used when
> > rows
> > > for year 2002 starts coming in)
> > >
> > > D4 -> DATA3 + DATA4 + SYSTEM
> > >
> > > D5 -> RBS01 + USER_TEMP + INDEX01
> > >
> > > D6 -> RBS-2 + INDEX02 + TEMP_TABLES
> > >
> > > D7 -> solaris system + oracle engine.
> > >
> > > would really appreciate if someone could review this config , and
> > suggest
> > > improvements.
> > >
> > > Regards
> > >
> > > Rahul
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Rahul
> > > INET: rahul_at_ratelindo.co.id
> > >
> > > 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).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Diego Cutrone
> > INET: dcutrone_at_afip.gov.ar
> >
> > 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).
> >

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Diego Cutrone
  INET: dcutrone_at_afip.gov.ar

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