Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Database Server Disk Configuration

For medium and large implementations the database should be configured for high performance throughput. In particular database performance is significantly affected by the way that the database server disks are configured. Organisations requiring this size of server will generally have their own database administrators who are familiar with this level of planning, however, for clarity the following shows a typical disk configuration:

Disk Group 1

8 x 300 GB in RAID5 configuration (Used for Oracle Data Tablespace)  Format the stripe with a block size that is optimal for data throughput. (typically 4Kb)

Disk Group 2

4 x 146 GB in RAID 1+0 configuration (Used for Oracle Redo) Format the mirror with a block size of 512 bytes. 2 redo groups multiplexed

Disk Group 3

2 * 146 GB in RAID 1+0 configuration (Used for Oracle Undo) Format the mirror with 4Kb block size

Specification for a minimal installation or testing platform

With 8 * 146Gb drives in a Raid 5 configuration, there is approximately 800GB of usable space. The server disks should be configured as a RAID 5 array and partitioned as follows:

Partition

Approx. Size

Purpose

Mount point

1

20 GB

Operating System


2

20 GB

Paging


3

400 GB

Database files

/u01 or c:/u01

Referred to below as $database

4

200 GB

Application installations and file data

/u02 or c:/u02

Referred to below as $app

5

100 GB

Archive Log space

/archive or c:/archive

Notes: All file system path names are written using a forward slash ‘/’ directory separator. On Windows forward and back slashes are considered to be equivalent, though there are still a few areas where back slashes must be used.

Specification for a medium installation

 Three Disk groups will have the following usable space:

Disk Group

Nbr Drives

Raid

Approx Usable Space

Disk Group 1

8 * 300GB

5 (7+1)

1900GB

Disk Group 2

4 * 146GB

1+0

270GB

Disk Group 3

2 * 146GB

1+0

135GB

Disk Group 1

With 8 * 300Gb drives in a Raid 5 configuration, there is approximately 1900GB of usable space. The server disks should partitioned as follows:

Partition

Approx. Size

Purpose

Mount point

1

20 GB

Operating System


2

20 GB

Paging


3

1400 GB

Database files

/u01 or c:/u01

Referred to below as $database

4

200 GB

Application installations and file data

/u02 or c:/u02

Referred to below as $app

5

100GB

Archive Log

/archive or C:/archive

Disk Group 2

With 4 * 146Gb drives in a Raid 1+0 configuration, there is approximately 270GB of usable space. The server disks should be partitioned as follows:

Partition

Approx. Size

Purpose

Mount point

1

200 GB

Oracle Redo

/redo1

2

200 GB

Oracle Redo

/redo2

Disk Group 3

With 2 * 146Gb drives in a Raid 1+0 configuration, there is approximately 135GB of usable space. The server disks should be partitioned as follows:

Partition

Approx. Size

Purpose

Mount point

1

130 GB

Oracle Undo

/undo

  • No labels