 |
|
Oracle Tips by Burleson |
Disk I/O Tuning
Chapter 2:
Disk
Interfaces
- Serial ATA:
Often abbreviated SATA or S-ATA, it is an evolution of the
Parallel ATA interface. Serial ATA is a serial link -- a single
cable with a minimum of four wires used to create a
point-to-point connection between devices. Transfer rates for
Serial ATA begin at 150Mbps. One of the main design advantages
of Serial ATA is that it has thinner serial cables that
facilitate more efficient airflow inside a form factor and also
allow for smaller chassis designs. In contrast, IDE cables used
in parallel ATA systems are bulkier than Serial ATA cables and
can only extend to 40cm long, while Serial ATA cables can extend
up to one meter.
Serial ATA supports all modern ATA and ATAPI devices (ATAPI is short
for Attachment Packet Interface, an extension to EIDE (also called
ATA-2) that enables the interface to support CD-ROM players and tape
drives. The major limitation to SATA is that it only supports one
device per cable. The differences between ATA and SATA are shown in
the following diagram. Essentially ATA allows two devices per ATA
connector that are configured in a standard Master-Slave setup,
while SATA only allows a single device per connector. ATA allows up
to 66 Mbits/sec per connector while SATA allows 150.
Figure 2-1:
Comparison of ATA and SATA Interfaces
The above text is
an excerpt from:
Oracle Disk I/O Tuning
Disk IO Performance & Optimization for Oracle
Databases
ISBN
0-9745993-4-4
by Mike Ault
Oracle Consulting
Services
Burleson
Oracle Consulting offers Senior Oracle consultants which are available for all
areas of Oracle support. Common Oracle consulting support activities include
short-term Oracle tuning, Oracle database troubleshooting, Oracle9i and
Oracle10g migration,
Oracle9iAS App Server
consulting, Oracle design reviews and
Oracle requirements evaluation support. Oracle support and Oracle consulting
services are priced by the hour, so you only pay for what you need. These
one-time Oracle consulting services commonly include:
-
Answering
questions from your Oracle DBA technical staff
-
Repairing down
production Oracle database systems
-
One-time
Oracle tuning evaluation
-
Guru support
for your Oracle DBA
-
Installation
of Oracle application packages
For more
information, please visit
www.praetoriate.com or email
info@remote-dba.net.
|
