HP ProLiant 3000 DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Ser - Page 16

Partitioning

Get HP ProLiant 3000 PDF manuals and user guides View all HP ProLiant 3000 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 16 highlights

Page 14 DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Servers you have 14 disks attached to one controller, you will create 14 arrays of one disk each for RAID-0 or 7 arrays of two disks each for RAID-1.) The RAID level is specified when creating the logical disk. The logical disk should take up all the space available on each array. When all logical drives have been created, you will need to split the logical drives into partitions. This is done through the Windows NT Disk Administrator. Figure 9 displays the Windows NT Disk Administrator for logical disks 4-8 in the TPC-D example. In this example, there are forty logical disks (one per physical disk), each having eighteen partitions. Each partition is created by selecting the disk and Partition - Create Logical. Figure 9: Disk Administrator Partitioning The ability to partition tables and indexes in Oracle 8 allows for a more granular table/index layout, better management of table and disk storage and increased DSS and I/O performance. In a DSS system, performance can be improved by reducing full table and index scans to partition scans. As stated above, partitioning and disk layout go hand in hand when developing and tuning a DSS system. When setting up partitions in Oracle8, you will need to consider the following. © 1998 Compaq Computer Corporation, All Rights Reserved Doc No ECG156/0398

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
Page
14
DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Servers
1998 Compaq Computer Corporation, All Rights Reserved
Doc No ECG156/0398
you have 14 disks attached to one controller, you will create 14 arrays of one disk each for
RAID-0 or 7 arrays of two disks each for RAID-1.)
The RAID level is specified when creating
the logical disk.
The logical disk should take up all the space available on each array.
When all
logical drives have been created, you will need to
split the logical drives into partitions.
This is done through the Windows NT Disk
Administrator.
Figure 9 displays the Windows NT Disk Administrator for logical disks 4-8 in
the TPC-D example.
In this example, there are forty logical disks (one per physical disk), each
having eighteen partitions.
Each partition is created by selecting the disk and Partition – Create
Logical.
Figure 9:
Disk Administrator
Partitioning
The ability to partition tables and indexes in Oracle 8 allows for a more granular table/index
layout, better management of table and disk storage and increased DSS and I/O performance.
In
a DSS system, performance can be improved by reducing full table and index scans to partition
scans.
As stated above, partitioning and disk layout go hand in hand when developing and tuning a DSS
system.
When setting up partitions in Oracle8, you will need to consider the following.