Oracle tables and index segregation

What are the I/O benefits of segregating Oracle tables and indexes onto separate disk spindles?  This is a "big" question because it touches Oracle DBA best practices, Simplified DBA management, and Oracle performance reporting.  There are many misunderstanding and myths, and this topic deserved an in-depth answer.

The perils of very-large Oracle disks has made it increasing difficult, and why disk contention is unavoidable because of the limitations of the ancient 50 year-old technology which relies on metal platters coated with magnetic media.  The speed of super-large Oracle disks (over 500 gig) are constrained by the speed of the read-write heads and platter RPM (today's platters cannot spin faster because they become aerodynamic).

Myths about separating tables and indexes

With all of the layers that we see within Oracle I/O sub-systems, it's no wonder that many myths have arisen. A few years ago, someone even published that the whole concept of reducing I/O contention by segregating tables and index on separate physical devices was a myth.

Click below to read more about separating Oracle indexes and tables:

http://www.dba-oracle.com/t_segregate_tables_indexes_separate_disks_data_files.htm

For complete details on Oracle I/O management, see my book "Oracle Tuning: The Definitive Reference":

http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm

*****************************************

Is your Database Healthy?

Oracle is the worlds most complex and robust database and there are hundreds of sub-optimal setting that can cripple your database performance.

BC has a great Oracle health check where we identify all database bottlenecks to ensure that your mission-critical system is running at optimal speeds.

Just call 800-766-1884 to schedule your health check.

*****************************************

Need Oracle Training?

The very best Oracle training comes from Burleson Consulting, where you get an on-site visit by an experienced Oracle expert and author.  Whether it's one-on-one mentoring or getting a customized on-site Oracle training class, there is no substitute for BC Oracle training.  Just call me at 800-766-1884 for details, and check-out our on-site Oracle training catalog:

http://www.dba-oracle.com/bc-catalog.pdf