Donald K. Burleson
Oracle Masters Program
In my incarnation as a sysop on
the DBAPipeline at www.revealnet.com and the lazydba and Metalink
forums I assist with, I answer newbie questions on a daily basis
that can usually be answered by looking at the manuals. Don’t waste
support analysts’ (and my) time by asking us questions that you can
answer yourself. Besides, I have found I learn better if I look it
up rather than have someone tell me; I’m sure you have had the same
experience. If you ask a question that is easily looked up in Oracle
manuals, I may answer “RTFM,” which stands for "Read the f******
Oracle Disk Layout
If you’ve read up to this point, you should realize that disk layout
is critical to efficient operation of Oracle systems. There are
several questions you need to answer when designing your disk
* What are the sizes of, and available space on, the disks or arrays
to be used with Oracle?
* Is this disk or array used for other non-Oracle applications?
* Has the disk been defragmented (if needed)?
* Is this a raw device (if UNIX)?
* What is the speed of the disk or disks in the array; or what is
the I/O saturation point of the controller channel?
* Is this a RAM or an optical disk?
Let’s look at each of these questions to determine how the answers
This is an
excerpt by Mike Ault’s book “Oracle
Administration & Management”. If you want more current Oracle tips
by Mike Ault, check out his new book “Mike
Ault’s Oracle Internals Monitoring & Tuning Scripts” or
Ault’s Oracle Scripts Download.
Copyright © 1996 - 2014 by
Burleson. All rights reserved.
Oracle® is the registered trademark
of Oracle Corporation.