Book description
Shifting your Oracle Database into top gear takes a lot of know-how and fine-tuning ability. The 80+ recipes in this Cookbook will give you those skills along with the ability to troubleshoot if things starts running slowly.
- Learn the right techniques to achieve best performance from the Oracle Database
- Avoid common myths and pitfalls that slow down the database
- Diagnose problems when they arise and employ tricks to prevent them
- Explore various aspects that affect performance, from application design to system tuning
In Detail
Oracle's Database offers great performance, scalability, and many features for DBAs and developers. Due to a wide choice of technologies, successful applications are good candidates to run into performance issues and when a problem arises it's very difficult to identify the cause and the right solution to the problem.
The Oracle Database 11g R2 Performance Tuning Cookbook helps DBAs and developers to understand every aspect of Oracle Database that can affect performance. You will be guided through implementing the correct solution in a proactive way before problems arise, and how to diagnose issues on your Oracle database-based solutions.
This fast-paced book offers solutions starting from application design and development, through the implementation of well-performing applications, to the details of deployment and delivering best-performance databases.
With this book you will quickly learn to apply the right methodology to tune the performance of an Oracle Database, and to optimize application design and SQL and PL/SQL code. By following the real-world examples you will see how to store your data in correct structures and access and manipulate them at a lightning speed. You will learn to speed up sort operations, hack the optimizer and the data loading process, and diagnose and tune memory, I/O, and contention issues.
The purpose of this cookbook is to provide concise recipes, which will help you to build and maintain a very high-speed Oracle Database environment.
Effectively apply performance tuning principles with concise recipes
Table of contents
-
Oracle Database 11gR2 Performance Tuning Cookbook
- Oracle Database 11gR2 Performance Tuning Cookbook
- Credits
- About the Author
- Acknowledgement
- About the Reviewers
- www.PacktPub.com
- Preface
-
1. Starting with Performance Tuning
- Introduction
- Reviewing the performance tuning process
- Exploring the example database
- Acquiring data using a data dictionary and dynamic performance views
- Analyzing data using Statspack reports
- Diagnosing performance issues using the alert log
- Analyzing data using Automatic Workload Repository (AWR)
- Analyzing data using Automatic Database Diagnostic Monitor (ADDM)
- A working example
-
2. Optimizing Application Design
- Introduction
- Optimizing connection management
- Improving performance sharing reusable code
- Reducing the number of requests to the database using stored procedures
- Reducing the number of requests to the database using sequences
- Reducing the number of requests to the database using materialized views
- Optimizing performance with schema denormalization
- Avoiding dynamic SQL
- 3. Optimizing Storage Structures
- 4. Optimizing SQL Code
- 5. Optimizing Sort Operations
- 6. Optimizing PL/SQL Code
- 7. Improving the Oracle Optimizer
- 8. Other Optimizations
- 9. Tuning Memory
- 10. Tuning I/O
- 11. Tuning Contention
-
A. Dynamic Performance Views
- ALL_OBJECTS
- DBA_BLOCKERS
- DBA_DATA_FILES
- DBA_EXTENTS
- DBA_INDEXES
- DBA_SQL_PLAN_BASELINES
- DBA_TABLES
- DBA_TEMP_FILES
- DBA_VIEWS
- DBA_WAITERS
- INDEX_STATS
- DBA_SEQUENCES
- DBA_TABLESPACES
- DBA_TAB_HISTOGRAMS
- V$ADVISOR_PROGRESS
- V$BUFFER_POOL_STATISTICS
- V$CONTROLFILE
- V$DATAFILE
- V$DB_CACHE_ADVICE
- V$DB_OBJECT_CACHE
- V$ENQUEUE_LOCK
- V$FILESTAT
- V$FIXED_TABLE
- V$INSTANCE_RECOVERY
- V$LATCH
- V$LATCH_CHILDREN
- V$LIBRARYCACHE
- V$LOCK
- V$LOCKED_OBJECT
- V$LOG
- V$LOG_HISTORY
- V$LOGFILE
- V$MYSTAT
- V$PROCESS
- V$ROLLSTAT
- V$ROWCACHE
- V$SESSION
- V$SESSION_EVENT
- V$SESSTAT
- V$SGA
- V$SGAINFO
- V$SHARED_POOL_RESERVED
- V$SORT_SEGMENT
- V$SQL
- V$SQL_PLAN
- V$SQLAREA
- V$STATNAME
- V$SYSSTAT
- V$SYSTEM_EVENT
- V$TEMPFILE
- V$TEMPSTAT
- V$WAITSTAT
- X$BH
- B. A Summary of Oracle Packages Used for Performance Tuning
Product information
- Title: Oracle Database 11gR2 Performance Tuning Cookbook
- Author(s):
- Release date: January 2012
- Publisher(s): Packt Publishing
- ISBN: 9781849682602
You might also like
book
Oracle Database 12c Release 2 Multitenant
Master the Powerful Multitenant Features of Oracle Database 12c Govern a scalable, extensible, and highly available …
book
Oracle Data Guard 11gR2 Administration Beginner's Guide
If you’re an Oracle Database Administrator it’s almost essential to know how to protect and preserve …
book
Oracle Database 12c Security Cookbook
Secure your Oracle Database 12c with this valuable Oracle support resource, featuring more than 100 solutions …
book
Oracle Database 11g Release 2 Performance Tuning Tips & Techniques
Implement Proven Database Optimization Solutions Systematically identify and eliminate database performance problems with help from Oracle …