RE: 11 disks to build a DB, suggestions

Diego,

I think log02 is not a redundant log01, I'm pretty sure it's the second redo log group, without which it will be pretty difficult to run the database :-). Maybe Rahul shouldn't delete it.

Yosi

> -----Original Message-----
> From: Diego Cutrone [mailto:dcutrone_at_afip.gov.ar]
> Sent: Tuesday, July 03, 2001 5:06 PM
> 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: 
  INET: Yosi_at_comhill.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).