Call (800) 766-1884 for Oracle support & training
Free Oracle Tips

Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance

Free Oracle Tips



BC Oracle tuning

Oracle training

Oracle support

Remote Oracle



  Oracle Tips by Burleson

Bandwidth and Oracle I/O

It should not be a surprise that the vast majority of Oracle databases are I/O centric, serving-up billions of bytes of information to the application layer.  Even with the rapidly-falling costs of RAM, large Oracle databases may perform millions of disk reads per minute, and the I/O subsystem is the source of system-wide bottlenecks.

Over the past decade, Oracle has developed sophisticated caching mechanisms to minimize disk I/O, but managing I/O throughput remains a major issue. There are several non-Oracle components that are used to optimize data-centric applications:

Operating Systems – The RedHat Linux4.0 operating system is specifically optimized for use by Oracle database, with special attention to the I/O drivers.

Hardware – Several vendors now offer servers that are architected to maximize I/O throughput.  For example, the UNISS ES-7000 series of servers use Non Uniform Memory Access(NUMA) to achieve optimal I/O in a data-centric environment.

Solid-state Disk (SSD)SSD, one of the greatest tools for achieving high data concurrency, is RAM disk that allows high bandwidth and data transfer rates that are an order of magnitude faster than the old-fashioned spinning platter devices.

Preventing disk I/O bottlenecks has always been one of the central tasks of the Oracle Database Administrator (DBA).  By definition, almost all Oracle databases are I/O intensive and minimizing the expensive physical disk I/O has always been a major priority to ensure acceptable performance. The only exceptions are scientific applications such as Laboratory Information Management Systems (LIMS), which read a small data set and perform CPU-intensive calculations.



The above book excerpt is from:

Oracle RAC & Tuning with Solid State Disk

Expert Secrets for High Performance Clustered Grid Computing

ISBN 0-9761573-5-7

Donald K. Burleson & Mike Ault


Oracle performance tuning software 

Oracle performance tuning book


Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel
Oracle training & performance tuning books



Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. 

Hit Counter