Oracle Database 11gR2 Performance Tuning Cookbook

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.

Oracle Database 11gR2 Performance Tuning Cookbook

Ciro Fiorillo

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.
eBook
$10.00
RRP $32.99
Save 69%
Print + eBook
$54.99
RRP $54.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$10.00
$54.99
RRP $32.99
RRP $54.99
eBook
Print + eBook

Frequently bought together


Oracle Database 11gR2 Performance Tuning Cookbook Book Cover
Oracle Database 11gR2 Performance Tuning Cookbook
$ 32.99
$ 10.00
Oracle 11g R1/R2 Real Application Clusters Essentials Book Cover
Oracle 11g R1/R2 Real Application Clusters Essentials
$ 41.99
$ 10.00
Buy 2 for $20.00
Save $54.98
Add to Cart

Book Details

ISBN 139781849682602
Paperback542 pages

Book Description

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.

Table of Contents

What You Will Learn

  • Design applications that run at lightning speed
  • Implement fast and scalable SQL and PL/SQL code
  • Choose the correct structures to store the data and access them
  • Optimize sort operations, such as order-by, Top-N queries, ranking, and set operators
  • Help the optimizer to choose the right access plan to retrieve data at the best available speed
  • Load data in the database at a faster speed by using the correct tools and options
  • Tune the database memory to obtain maximum performance using available resources
  • Tune the I/O operations, by designing a database over the I/O system
  • Tune and reduce contention issues on data and structures by using an optimal design

Authors

Table of Contents

Book Details

ISBN 139781849682602
Paperback542 pages
Read More

Read More Reviews

These popular $10 titles might interest you

Oracle 11g R1/R2 Real Application Clusters Essentials Book Cover
Oracle 11g R1/R2 Real Application Clusters Essentials
$ 41.99
$ 10.00
OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide Book Cover
OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide
$ 35.99
$ 10.00
Oracle Data Guard 11gR2 Administration : Beginner's Guide  Book Cover
Oracle Data Guard 11gR2 Administration : Beginner's Guide
$ 35.99
$ 10.00
Oracle WebLogic Server 12c Advanced Administration Cookbook Book Cover
Oracle WebLogic Server 12c Advanced Administration Cookbook
$ 29.99
$ 10.00
Oracle Enterprise Manager 12c Administration Cookbook Book Cover
Oracle Enterprise Manager 12c Administration Cookbook
$ 29.99
$ 10.00
Oracle Goldengate 11g Complete Cookbook Book Cover
Oracle Goldengate 11g Complete Cookbook
$ 41.99
$ 10.00