ࡱ> %$ @\p Joe Kuefler Ba==Qs28X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *    `Sheet1$Sheet2%Sheet3`i88WEnsure that all 3 control files are on different disks (as long as we have >= 3 disks).KEEF-02'Keep DATA and INDEX on different disks.KEEF-03OBreak NH_DATA01 across several disks (even when NOT hitting the 32G file limit)KEEF-04Break NH_DATA02 across several disks (even when NOT hitting the 32G file limit). Not sure if we care that NH_DATA01 and NH_DATA02 are on the same disk.KEEF-05\Break NH_INDEX across several disks (as long as we have enough disks to not violate KEEF-02)KEEF-060Keep TEMP away from DATA and INDEX (if possible)KEEF-07(Ignore where NH_HOME and ORACLE_HOME are KEATS-001 KEATS-002;Archive logs should be on different disk than any redo logs KEATS-003OWhat happened to NH_USERS? OK it's not a "rule" but it's not in the a-i block. KEATS-004Redo logs and Archive logs should not share a disk with tablespaces (they'd be better off buying some cheap tiny drives (2GB) for the Redo logs) KEATS-0054Keep NH_USERS separate from the DATA and INDEX disks KEATS-006Keep INDEX on it's own disk KEATS-007$Definitely keep NH_TEMP on it's own. KEATS-008I was told by Sanjay to keep ORACLE_HOME on a different disk from the DB. I've done this in performance testing whenever possible. KEATS-009pWhat out for rule "KEEF-01"...what happens if you're striping to one logical volume? Does createDb handle this? KEATS-010How do we handle striped disks? KEATS-012you should treat FE and BE differently...on a FE the DATA 01/2 tablespaces are unused, so if you keep the same rules for both you will put these on some of the largest disks. KEATS-013lhow do you handle the situation where a customer has a bunch of 18GB disks but needs a 20GB DATA01 datafile? KEATS-014if you are going to start splitting datafiles (even before the 32 GB limit) b/c of "extra" disks, then I'd recommend splitting them one at a time (just INDEX and DATA01/2) instead of breaking one into many pieces first. For example, if you have 4 "extra" disks, then split INDEX and DATA01/2 into 2 pieces first...then make the biggest of the three into 3 pieces. Of course, I would do this AFTER everything else is on its own disk. KEVILLE-01Check during db creation that the stripe width matches our db block size, if they are using striping, if not ask if they want to continue. KEVILLE-02Check the spindle speeds of the disks they are installing on and try to match tablespaces that cross disks to same speed disks(?)RAVI-01System, redo and archive locations should be on different non stripped individual disk if possible. They should not be place along with other files if possible. Also they should be placed on the smallest files if possible RAVI-02FThe two redo s and the archive locations should be on different disks RAVI-04cThe index and data1 and data2 should be on different disks. (possibly even different raid arrays.) RAVI-05SWe need to split tablespace into one or more files based on a max file limit that is specified depending on the tablespace using the below table. That is for the index tablespace this limit is 10GB. For temp it is 100MB etc. The reason for this rule is to allow us to exploit many individual disks and spread IO without the need for RAID. RAVI-06xWe need to allocate the index, data1, data2 starting from the largest disk to the smallest disk in the order specified. RAVI-076The system location must be on one and only one disk. We should have 4 disks for redo logs as follows: disk 1: redo1a, redo3a disk 2: redo1b, redo3b disk 3: redo2a, redo4a disk 4: redo2b, redo4bKEEF-01, RAVI-03: r 5u :  @  $  dMbP?_*+%M: NEC1800 TCPIP\_ odXLetter (8 1/2 x 11 in)NEC SuperScript 1800 PCL6LPT1:8 8 ''''"dX??U} } IC      7               6                    ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5<@>@7 @ :%  dMbP?_*+%"??U>@7 @ A&  dMbP?_*+%"??U>@7 Oh+'0HPdx  Joe Kuefler Joe KueflerMicrosoft Excel@!ȟ@y}ߙ@ݟ՜.+,0 PXp x Ridgeware, Inc. Sheet1Sheet2Sheet3  Worksheets  !"#Root Entry FWorkbook&SummaryInformation(DocumentSummaryInformation8