Skip to Main Content
Troubleshooting Oracle Performance, Second Edition
book

Troubleshooting Oracle Performance, Second Edition

by Christian Antognini
June 2014
Intermediate to advanced content levelIntermediate to advanced
740 pages
23h 59m
English
Apress
Content preview from Troubleshooting Oracle Performance, Second Edition

CHAPTER 15

image

Beyond Data Access and Join Optimization

The optimization of data accesses and joins must be performed before considering the advanced optimization techniques presented in this chapter. In fact, the optimization techniques described here are intended only to further improve performance when it isn’t possible to achieve it otherwise. In other words, you should fix the basics first, and then, if the performance is still not acceptable, you can consider special means.

This chapter describes how materialized views, result caches, parallel processing, direct-path inserts, row prefetching, and the array interface work and how they can be ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Troubleshooting Oracle Performance

Troubleshooting Oracle Performance

Christian Antognini
Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning

Richmond Shee, Kirtikumar Deshpande, K Gopalakrishnan
Expert Oracle Exadata, Second Edition

Expert Oracle Exadata, Second Edition

Martin Bach, Karl Arao, Andy Colvin, Frits Hoogland, Randy Johnson, Kerry Osborne, Tanel Poder

Publisher Resources

ISBN: 9781430257585Purchase book