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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).