Oracle Performance Tuning for 10gR2

( 1 )

Overview

Tuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100%+ performance improvement. Physical and configuration tuning often gives at most a 25% performance increase.

Gavin Powell shows that the central theme of Oracle10gR2 Performance Tuning is four-fold: ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (5) from $1.99   
  • New (1) from $136.82   
  • Used (4) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$136.82
Seller since 2011

Feedback rating:

(871)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand new and unread! Join our growing list of satisfied customers!

Ships from: Phoenix, MD

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

Tuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100%+ performance improvement. Physical and configuration tuning often gives at most a 25% performance increase.

Gavin Powell shows that the central theme of Oracle10gR2 Performance Tuning is four-fold: denormalize data models to fit applications; tune SQL code according to both the data model and the application in relation to scalability; create a well-proportioned physical architecture at the time of initial Oracle installation; and most important, mix skill sets to obtain the best results.

* Fully updated for version 10gR2 and provides all necessary transition material from version 9i
* Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning
* Contains experienced guidance and real-world examples using large datasets Emphasizes development as opposed to operating system perspective

Read More Show Less

Product Details

  • ISBN-13: 9781555583453
  • Publisher: Elsevier Science
  • Publication date: 9/29/2006
  • Edition number: 2
  • Pages: 960
  • Product dimensions: 7.50 (w) x 9.20 (h) x 1.50 (d)

Meet the Author

Gavin Powell, BSc. Comp.Sci., OCP (Oracle8i Certified Professional) has fifteen years of computer industry experience. Diverse experience in database administration and database development in both relational and object databases. Applications development experience is procedural and object-oriented. He also has some systems administration experience. His extensive consulting experience includes software vendors, internet .COM’s (some unfortunately have met with their demise), accounting, banking, financial services, the travel industry, construction, retail, mining, shipping, education and general advisory capacity. Gavin Powell has worked with many software products, tools and programming languages. These tools include items in the list shown below. He has authored two successful books Oracle …High performance Tuning and the just released Oracle SQL
Read More Show Less

Table of Contents

Part I. Data Model Tuning; The Relational Database Model; Tuning the Relational Database Model; A Brief History of Data Modeling;
Part II. SQL Code Tuning; Concepts of Efficient SQL; Common Sense Indexing; Oracle SQL Optimization and Statistics; How Oracle SQL Optimization Works;
How to Find Problem Queries; Automated SQL Tuning;
Part III. Physical and Configuration Tuning; Installing Oracle and Creating a Database; Tuning Oracle Database File Structures;
Low Level Physical Tuning; Hardware Resource Usage Tuning; Tuning Network Usage; Oracle Partitioning and Parallelism; Ratios: Possible Symptoms of Problems; Tools and Utilities; Part IV. Tuning Everything at Once; The Wait Event Interface; The Database Control; Tuning With STATSPACK; Appendices
Appendix A. Sample Databases
Appendix B. Sample Scripts (script changes)
Appendix C. Sources of Information (accreditations)Appendix D. SQL Tuning in Oracle Enterprise Manager
(might delete this one, depending on how much I remove from part III, which is 9i)
Read More Show Less

Customer Reviews

Average Rating 4
( 1 )
Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted October 16, 2006

    Excellent book on Oracle 10G Tuning

    This is the first book I have read from Gavin Powell and Digital Press. The book is excellent. Gavin's approach to helping you understand the concepts are displayed well with code examples. You will read a passage and then see an example to really enforce the principle. The examples support the concepts and using both together helped me out a great deal. The chapters on Tcp/ip and DSM SUBSYSTEM I found to be really helpful. This architecure chapter goes in much needed detail as so many books just glance over the different Oracle tuning. What the processes are used for and how they can be tuned is well documented. The ODBC chapter helped me understand how to configure and best to take its advantage its fullest level for a given situation. At the end of the sql/mx chapter Gavin has a section on specific tuning and this section should be required reading for all DBAs and developers. Something else I got from the book are methods for writing SQL and tuning it. The SQL that the author puts together looks so easy and natural for him to write. He is a master of SQL*Plus and that is a side benefit to reading the book. The techniques I picked up from reading Gavin's examples will help me just as much or more so than content of the book. This book is an excellent addition to my Oracle collection of books and I highly recommend reading it.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)