tuningIO - Tuning I/O Input/Output When designing a new...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Tuning I/O Input/Output When designing a new system, you should analyze I/O needs from the top down, determining what resources you will require in order to achieve the desired performance. For an existing system, you should approach I/O tuning from the bottom up: 1. Determine the number of disks on the system. 2. Determine the number of disks that are being used by Oracle. 3. Determine the type of I/Os that your system performs. 4. Ascertain whether the I/Os are going to the file system or to raw devices. 5. Determine how to spread objects over multiple disks, using either manual striping or striping software. 6. Calculate the level of performance you can expect. Analyzing I/O Requirements 1 Calculate the total throughput your application will require. Define the I/O performance target for this application by specifying the number of tps (transactions per second) the system must support. In general, disk speed tends to have the following characteristics:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/25/2010 for the course MAT 443 taught by Professor Roberts during the Winter '10 term at University of Arizona- Tucson.

Page1 / 3

tuningIO - Tuning I/O Input/Output When designing a new...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online