Items related to Oracle Database 11gR2 Performance Tuning Cookbook

Oracle Database 11gR2 Performance Tuning Cookbook - Softcover

  • 3.80 out of 5 stars
    5 ratings by Goodreads
 
9781849682602: Oracle Database 11gR2 Performance Tuning Cookbook

Synopsis

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

What you will learn from this book

  • 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

Approach

In this book you will find both examples and theoretical concepts covered.

Every recipe is based on a script/procedure explained step-by-step, with screenshots, while theoretical concepts are explained in the context of the recipe, to explain why a solution performs better than another.

Who this book is written for

This book is aimed at software developers, software and data architects, and DBAs who are beginning to use the Oracle Database, and want to solve performance problems faster and in a rigorous way.

If you are an architect who wants to design fast performing applications, a DBA who is keen to dig into the causes of performance issues, or a developer who wants to learn why and where the application is running slowly this book will provide a good start for your career in performance tuning.

"synopsis" may belong to another edition of this title.

About the Author

Ciro Fiorillo

Ciro Fiorillo is an IT professional and consultant with experience of more than a decade in different roles (developer, analyst, DBA, project manager, data and software architect) among software industries. He has worked on different technologies and architectures, such as Oracle, SQL Server, Delphi, C# and .NET Framework, C/C++, Java, PHP, COBOL, Fortran, and Tibco.

Ciro is currently employed as Lead Software and Data Architect with FinWin Srl, a software house specializing in banking and loans applications.

As a freelancer he writes articles for websites and printed magazines about software and computing, participates in workshops, and teaches C++ and Fortran parallel programming with Intel Software tools.

Ciro can be reached at ciro@cirofiorillo.com.

"About this title" may belong to another edition of this title.

  • PublisherPackt Pub Ltd
  • Publication date2012
  • ISBN 10 1849682607
  • ISBN 13 9781849682602
  • BindingPaperback
  • LanguageEnglish
  • Number of pages521
  • Rating
    • 3.80 out of 5 stars
      5 ratings by Goodreads

Buy Used

Condition: As New
Like New
View this item

US$ 33.77 shipping from United Kingdom to U.S.A.

Destination, rates & speeds

Search results for Oracle Database 11gR2 Performance Tuning Cookbook

Stock Image

Fiorillo, Ciro
Published by Packt Pub Ltd, 2012
ISBN 10: 1849682607 ISBN 13: 9781849682602
New Softcover

Seller: Lucky's Textbooks, Dallas, TX, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Seller Inventory # ABLIING23Mar2912160253589

Contact seller

Buy New

US$ 59.48
Convert currency
Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Ciro Fiorillo
Published by Packt Publishing Limited, 2012
ISBN 10: 1849682607 ISBN 13: 9781849682602
New PAP
Print on Demand

Seller: PBShop.store US, Wood Dale, IL, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

PAP. Condition: New. New Book. Shipped from UK. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # L0-9781849682602

Contact seller

Buy New

US$ 75.49
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Ciro Fiorillo
Published by Packt Publishing Limited, 2012
ISBN 10: 1849682607 ISBN 13: 9781849682602
New PAP
Print on Demand

Seller: PBShop.store UK, Fairford, GLOS, United Kingdom

Seller rating 4 out of 5 stars 4-star rating, Learn more about seller ratings

PAP. Condition: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # L0-9781849682602

Contact seller

Buy New

US$ 70.13
Convert currency
Shipping: US$ 7.93
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Fiorillo, Ciro
Published by Packt Publishing 2011-12, 2011
ISBN 10: 1849682607 ISBN 13: 9781849682602
New PF

Seller: Chiron Media, Wallingford, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

PF. Condition: New. Seller Inventory # 6666-IUK-9781849682602

Contact seller

Buy New

US$ 62.73
Convert currency
Shipping: US$ 20.92
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: 10 available

Add to basket

Stock Image

Fiorillo, Ciro
Published by Packt Pub Ltd, 2012
ISBN 10: 1849682607 ISBN 13: 9781849682602
New Softcover

Seller: Ria Christie Collections, Uxbridge, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. In. Seller Inventory # ria9781849682602_new

Contact seller

Buy New

US$ 69.25
Convert currency
Shipping: US$ 16.18
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Ciro Fiorillo
Published by Packt Publishing Limited, 2012
ISBN 10: 1849682607 ISBN 13: 9781849682602
New Paperback / softback
Print on Demand

Seller: THE SAINT BOOKSTORE, Southport, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback / softback. Condition: New. This item is printed on demand. New copy - Usually dispatched within 5-9 working days 1023. Seller Inventory # C9781849682602

Contact seller

Buy New

US$ 77.81
Convert currency
Shipping: US$ 22.93
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Seller Image

Ciro Fiorillo
Published by Packt Publishing, 2012
ISBN 10: 1849682607 ISBN 13: 9781849682602
New Taschenbuch
Print on Demand

Seller: AHA-BUCH GmbH, Einbeck, Germany

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Taschenbuch. Condition: Neu. nach der Bestellung gedruckt Neuware - Printed after ordering. Seller Inventory # 9781849682602

Contact seller

Buy New

US$ 98.95
Convert currency
Shipping: US$ 37.73
From Germany to U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Fiorillo, Ciro
Published by Packt Publishing, 2012
ISBN 10: 1849682607 ISBN 13: 9781849682602
Used Paperback

Seller: dsmbooks, Liverpool, United Kingdom

Seller rating 4 out of 5 stars 4-star rating, Learn more about seller ratings

Paperback. Condition: Like New. Like New. book. Seller Inventory # D7F5-8-M-1849682607-6

Contact seller

Buy Used

US$ 103.19
Convert currency
Shipping: US$ 33.77
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Seller Image

Fiorillo, Ciro
Published by Packt Publishing, 2011
ISBN 10: 1849682607 ISBN 13: 9781849682602
New Kartoniert / Broschiert
Print on Demand

Seller: moluna, Greven, Germany

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Kartoniert / Broschiert. Condition: New. Dieser Artikel ist ein Print on Demand Artikel und wird nach Ihrer Bestellung fuer Sie gedruckt. Seller Inventory # 11785180

Contact seller

Buy New

US$ 84.59
Convert currency
Shipping: US$ 56.03
From Germany to U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket