Tuning Oracle with RAM

Most Oracle professionals recognize the huge benefits of RAM data caching, a techniques that can improve data access speeds by up to 300x when compared to platter-based disk. RAM can also support blistering table insert speeds of over a half million rows per second. 

For complete details, see my master book "Oracle Tuning: The Definitive Reference":

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

The web site www.statspackanalyzer.com is a great way to see if your Oracle database is I/O-bound and you can simply paste-in a STATSPACK or AWR report and see a detailed I/O analysis.

www.statspackanalyzer.com

Oracle's Time Ten tool is the latest data caching approach in Oracle, but there are several major approaches to RAM data caching today:

Solid State Disk data caching - RAM-SAN can hypercharge an I/O-bound Oracle database overnight, speeding-up I/O operations. See the book "Oracle Solid State Disk Tuning: High Performance Oracle Tuning with RAM disk" for benchmarks and tips on using SSD.

Large RAM Buffer Data Caching - Many Oracle professionals choose to use a very large db_cache_size, and most of the recent world-record TPC benchmarks use Oracle data buffers in excess of 50 gigabytes, and one Oracle benchmark that used over a terabyte of RAM. For details, see the book "Database Benchmarking: Practical methods for Oracle":

Click below to read details about how the prudent application of RAM can make Oracle I/O hundreds of times faster:

http://www.dba-oracle.com/t_times_ten_data_caching.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 misison-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