| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 11 disks to build a DB, suggestions
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). Received on Tue Jul 03 2001 - 04:38:07 CDT
 |
 |