If you can stripe at 64K do so, but I only think Pyramids can
Steve
Date: 1/30/96 9:03 PM
To: Steve Lemme
From: ORACLE database mailing list.
Hi!
We are setting up a large database. We want to use Operating System
stripping to improve performance. Each 2Gb disk will be striped on 5 disks.
The database will be around 100Gb. Most of the tables will be 30Mg. For
large databases, Oracle recommends a DB_BLOCK_SIZE of 8K and a large
DB_FILE_MULTIBLOCK_READ_COUNT (32 for example).
1 - What do you think would be the optimal size of each stripe? 64K? 512K?
1Mg? ...
2 - How does your choice impact on parallel query for a 30Mg table spread
on 5 disks ?
TIA
- RFC822 Header Follows ------------------
Received: by chdqm2.sps.mot.com with SMTP;30 Jan 1996 21:03:43 +0530
Received: from uunet!CCVM.SUNYSB.EDU by motsps.sps.mot.com
(4.1/SMI-4.1/Email-2.1)
id AA25168 for Steve_Lemme_at_CHDQM2; Tue, 30 Jan 96 21:02:57 MST
Received: from uunet.UUCP by spsgate.sps.mot.com (4.1/SMI-4.1/Email 2.1
10/25/93)
id AA00677 for Steve_Lemme_at_CHDQM2.SPS.MOT.COM; Tue, 30 Jan 96 17:22:15 MST
Received: from ccvm.sunysb.edu by relay1.UU.NET with SMTP
id QQaauy07881; Tue, 30 Jan 1996 19:00:00 -0500 (EST)
Message-Id: <QQaauy07881.199601310000_at_relay1.UU.NET>
Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3)
with BSMTP id 9922; Tue, 30 Jan 96 18:06:29 EST
Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV_at_SBCCVM) by CCVM.SUNYSB.EDU
(LMail V1.2a/1.8a) with BSMTP id 0123; Tue, 30 Jan 1996 18:06:19 -0500
Date: Tue, 30 Jan 1996 17:27:57 EST
Reply-To: "ORACLE database mailing list."
<ccvm.sunysb.edu!ORACLE-L_at_uunet.uucp>
Sender: "ORACLE database mailing list." <ccvm.sunysb.edu!ORACLE-L_at_uunet.uucp>
From: Regent Roberge <TELEGLOBE.CA!RRoberge_at_uunet.uucp>
Subject: Operating System stripping and Parallel Query Option
X-To: ORACLE-L_at_CCVM.SUNYSB.EDU
To: Multiple recipients of list ORACLE-L <ccvm.sunysb.edu!ORACLE-L_at_uunet.uucp>
Received on Wed Jan 31 1996 - 11:20:43 CST