SUMMARY: E 450, oracle, cluster size etc

From: <przemolicc_at_poczta.fm>
Date: Wed May 23 2001 - 05:07:44 EDT
Oryginal question at the end. Thanks for the answers from:
Stephen Boronski
hmnguyen@verizongni.com
Kevin Buterbaugh

In general:
- you will get the best performance if your UFS block size matches the
  Oracle block size.
- Based on your disk layout, data chunk are going
  to read/write across all three disks. Because of several disks arm are
  doing I/O, this already given your system better in performance.

I will stick with default options of newfs.

przemol

=================================================================

Subject:  E 450, oracle, cluster size etc


We have E 450 with 2 internal expansion kits. We are going to install
Oracle 8i on it. My configuration of disks is as follow
(I removed configuration of root and swap):
d8: Mirror
    Submirror 0: d6
      State: Okay
    Submirror 1: d7
      State: Okay
    Pass: 1
    Read option: roundrobin (default)
    Write option: parallel (default)
    Size: 105492256 blocks

d6: Submirror of d8
    State: Okay
    Hot spare pool: hsp001
    Size: 105492256 blocks
    Stripe 0: (interlace: 32 blocks)
        Device              Start Block  Dbase State        Hot Spare
        c3t0d0s0                   0     No    Okay
        c3t2d0s0                4712     No    Okay
        c3t3d0s0                4712     No    Okay


d7: Submirror of d8
    State: Okay
    Hot spare pool: hsp001
    Size: 105492256 blocks
    Stripe 0: (interlace: 32 blocks)
        Device              Start Block  Dbase State        Hot Spare
        c5t0d0s0                   0     No    Okay
        c5t2d0s0                4712     No    Okay
        c5t3d0s0                4712     No    Okay

Our oracle admin has decided that oracle block size is going to be 16 kB.
Most of database files will be put on d8 filesystem.
What are the most optimized parameters (for newfs or mkfs) which should be
used
during creating filesystem on d8 ?
Received on Wed May 23 10:07:44 2001

This archive was generated by hypermail 2.1.8 : Wed Mar 23 2016 - 16:24:55 EDT