Home > Oracle Database / Applications Tips > Chapter Downloads > Oracle disk I/O tuning: ATA tuning in Linux, part 1

	Oracle Tips:	EMAIL THIS

	TIPS & NEWSLETTERS TOPICS

CHAPTER DOWNLOADS Oracle disk I/O tuning: ATA tuning in Linux, part 1 Mike Ault 08.05.2004 Rating: --- (out of 5) Digg This!     StumbleUpon     Del.icio.us    The following is part of a series on the different aspects of disk I/O performance and optimization for Oracle databases. Each tip is excerpted from the not-yet-released Rampant TechPress book, "Oracle disk I/O tuning," by Mike Ault. Check back to the main series page for upcoming installments. [TABLE]

ATA tuning in Linux

You will be happy to know that Linux is specifically designed (as are other true "UNIXs", SCO not included) to not fragment hard drives. Fragmentation is reduced in Linux over Windows by usually more than 98 percent and is usually not a concern.

However, Linux takes any default drive in

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Chapter Downloads Writing single-row and multiple-row subqueries List the types of SQL subqueries Using subqueries in SQL Define SQL subqueries Oracle 11g: PL/SQL Basics Oracle 11g: Backup and recovery concepts Migrating to Oracle: Expert Secrets to Migrate from SQL Server and MySQL Oracle Database 11g SQL Tuning Upgrading to Oracle Database 11g Tuning the Oracle database with initialization parameters

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

terface settings where implemented by the developer of the ATA kernel module that interfaces to your EIDE/ATA disk drive. At the time the driver was written, no doubt the drives were inferior to what you are currently running, not to mention it may have been written with old interface drivers as well. Fear not! Linux provides the hdparm utility to reset the values for the ATA interface to take advantage of new drives and better interfaces. Thus, if you want to tune the ATA drives in Linux use hdparm. In some cases, the disk IO rate increased by nearly 500 percent (a factor of 5) over pre-tuned values by the proper application of the hdparm application parameters. The basic tuning related arguments for hdparm are:

When no flags are given, acdgkmnru is assumed.

Rate this Tip To rate tips, you must be a member of SearchOracle.com. Register now to start rating these tips. Log in if you are already a member. DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.