The Oracle 11G Performance Tuning

In today's Internet-centric economy, too many organizations respond to Oracle performance problems by throwing money at these problems by buying larger and more expensive computers or by hiring expert consultants. But there's a lot you can do on your own to increase dramatically the performance of your existing system. Whatever version of Oracle you're running from Version 10g to Oracle 11g, proper tuning can save your organization a huge amount of money in additional equipment, extra memory, and hardware upgrades. The first edition of Oracle 11g Performance Tuning became a classic for programmers, managers, database administrators, system administrators, and anyone who cares about improving the performance of an Oracle database system.

Oracle 11g Performance Tuning is a must-have reference guide for all Oracle professionals. It provides much-needed information on best practices, tips, and techniques in debugging and tuning of the Oracle 11g database. It will bring you the insider information that you can't get anywhere else. It is a book for people who administer the operation of an Oracle Database system. Referred to as database administrators (DBAs), they are responsible for creating Oracle Database, ensuring its smooth operation, and monitoring its use.

  1. Getting Started with Oracle Architecture
  2. Designing and Developing for Performance
  3. Performance Improvement Methods
  4. Configuring a Database for Performance
  5. Automatic Performance Statistics
  6. Automatic Performance Diagnostics
  7. Configuring and Using Memory
  8. I/O Configuration and Design
  9. Managing Operating System Resources
  10. Instance Tuning Using Performance Views
  11. The Query Optimizer
  12. Using Explain Plan
  13. Managing Optimizer Statistics
  14. Using Indexes and Clusters
  15. Using SQL Plan Management
  16. SQL Tuning Overview
  17. Automatic SQL Tuning
  18. SQL Access Advisor
  19. Using Optimizer Hints
  20. Using Plan Stability
  21. Using Application Tracing Tools