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