Parida Rajeev A. The Oracle 11g Performance Tuning

Монография
University Science Press, 2017. - 524 с.Книга под названием «The Oracle 11g Performance Tuning» предназначена для людей, которые занимаются эксплуатацией, обслуживанием и производительностью базы данных Oracle. Реализация решений по настройке с использованием проверенной методологии, описанной в книге, дает пошаговые практические советы по устранению узких мест, минимизации простоев и повышению общей производительности системы.
The Oracle 11g Performance Tuning является обязательным справочным руководством для всех специалистов Oracle. Он предоставляет столь необходимую информацию о лучших практиках, советах и методах отладки и настройки базы данных Oracle 11g. Она даст вам инсайдерскую информацию, которую вы не сможете получить нигде. Это книга для людей, которые управляют работой системы базы данных Oracle. Называемые администраторами баз данных (DBA), они несут ответственность за создание базы данных Oracle, обеспечение ее бесперебойной работы и мониторинг ее использования.The book titled The Oracle 11g Performance Tuning is an aid for the people who are involved in the operation, maintenance, and performance of Oracle database. Implementing tuning solutions using the proven methodology found inside the book gives a step-by-step practical advice for removing bottlenecks, minimizing downtime and increasing overall system performance.
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.Purpose of this book:
My main purpose is to give you a foundation for using, the Oracle database effectively and efficiently. Therefore, I wrote with these principles in mind:
• I have tried to concentrate on the most important Oracle 11g performance tuning issues. Every topic provides a comprehensive but concise discussion of how Oracle 11g handles a tuning issue and the repercussions of that action.
• One of the first decisions I made was to concentrate on principles rather than syntax. There simply isn’t room for myriad syntax diagrams and examples in this book.
• I have tried to make this an ideal first Oracle 11g tuning book for a wide spectrum of Oracle users but not the last you will very likely have to refer to Oracle documentation or other, more specific books for more details about using Oracle 11g tuning. However, I hope this book will act as information from other sources and put it to the best use.This book is the result of over 14 years of experience with Oracle and other databases. I have tried to apply that experience as best I can here.Who this book is forThis book is an aid for people responsible for the operation, maintenance, and performance of Oracle database. This book describes detailed ways to enhance Oracle performance by writing and tuning SQL properly, using performance tools, and optimizing instance performance. It also explains how to create an initial database for good performance and includes performance-related reference information. This book could be useful for database administrators, application designers, and programmers.Getting Started with Oracle Architecture
Designing and Developing for Performance
Performance Improvement Methods
Configuring a Database for Performance
Automatic Performance Statistics
Automatic Performance Diagnostics
Configuring and Using Memory
I/O Configuration and Design
Managing Operating System Resources
Instance Tuning Using Performance Views
The Query Optimizer
Using Explain Plan
Managing Optimizer Statistics
Using Indexes and Clusters
Using SQL Plan Management
SQL Tuning Overview
Automatic SQL Tuning
SQL Access Advisor
Using Optimizer Hints
Using Plan Stability
Using Application Tracing Tools