Home > Oracle Database / Applications Tips > Chapter Downloads > Oracle disk I/O tuning: Tuning the SCSI interface in Windows

	Oracle Tips:	EMAIL THIS

	TIPS & NEWSLETTERS TOPICS

CHAPTER DOWNLOADS Oracle disk I/O tuning: Tuning the SCSI interface in Windows Mike Ault 08.16.2004 Rating: -2.50- (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]

Tuning the SCSI interface in Windows

There are two ways to change the SCSI settings for a Windows SCSI system. The first is during the install of the driver or during a reboot, usually the system will provide you with a way to get into the SCSI configuration utility when it starts up. The second is via registry edit. Registry edit is a frightening method to do anything in Windows, one wrong entry could result in your system not starting properly or in data corruption or loss. Now that I've scared you, let's discuss the registry edit method for adjusting your SCSI interface.

The items which can be tuned in Windows are located in (or added to) the registry key: Where the "aic78xx" is replaced with the name of your controllers driver. The values that can be edited will usually have to be added as values: These values are added by using the following procedure:

1. Click on the Start button.
2. Select the Run menu item.
3. In the Run dialog box, enter the appropriate registry editor name (may be regedit32 or just regedit).
4. Press the Enter key.
5. Open the registry list to the appropriate location, for example:
6. If the keys (Parameters and Device) listed above do not exist, you will have to add them by right clicking on the driver name and selecting the proper drop-down boxes. See Figure 3-1.
   
   [IMAGE]
   F
   
   To continue reading for free, register below or login

   Requires Membership to View

   To gain access to this and all member only content, please provide the following information (all fields required):

   Email Address:
   Create Password:
   Confirm Password:
   
   
   
   
   

   By joining SearchOracle.com you agree to receive email updates from the TechTarget network of sites, including updates on new content, magazine or event notifications, new site launches and market research surveys. Please verify all information and selections above. You may unsubscribe at any time from one or more of the services you have selected by editing your profile or unsubscribing via email.
   
   TechTarget cares about your privacy. Read our Privacy Policy
   To read more you must become a member of SearchOracle.com

   As an existing member of the TechTarget network please provide your password to activate your account (Forgot your password?):

   Password:
   
   

   By joining SearchOracle.com you agree to receive email updates from the TechTarget network of sites, including updates on new content, magazine or event notifications, new site launches and market research surveys. Please verify all information and selections above. You may unsubscribe at any time from one or more of the services you have selected by editing your profile or unsubscribing via email.
   
   TechTarget cares about your privacy. Read our Privacy Policy
   
   
   

   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

   
   
   igure 3-1: Adding a Key

7. To add a specific host adapter append Device with its indicator, device zero would be Device0. If the number is not specified the configuration information applies to all SCSI family host devices.
8. Right click on the Device key.
9. Select Add Value from the Edit menu. In the Value Name edit box, enter one of the valid parameter values. Make sure to enter the appropriate data type for the value and make sure you use the proper case exactly as they are specified. Repeat 8 and 9 for all additional keys. See Figure 3-2.
   
   [IMAGE]
   Figure 3-2: Adding Values to the Device Key

   There are additional device specific parameters that can also be modified or added. These are: These are added to a new parameter added at the device level called DeviceParameters, which is a string value. The parameters are added as a space separated list. See Figure 3-3.
   
   [IMAGE]
   Figure 3-3: Device DriverParameters Value

   You need to look at your adapter manual (you may have to download a copy from the device manufacturer's website) for the parameters that can be added or modified for your adapter.

   Click to buy the book, "Oracle disk I/O tuning," by Mike Ault.

   ---

   About the author

   Mike Ault is a SearchOracle.com expert and a senior Oracle consultant with Burleson Consulting, and one of the leading names in Oracle technology. The author of more than 20 Oracle books and hundreds of articles in national publications, Mike Ault has five Oracle Masters Certificates and was the first popular Oracle author with his landmark book "Oracle7 administration and management." Mike also wrote several of the "Exam Cram" books, and enjoys a reputation as a leading author and Oracle consultant. Ask Mike a question today!

   
   

   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.