As Oracle professionals are challenged to create SQL statements that will support thousands of concurrent executions with sub-second response time, this book’s timing is critical as tuning Oracle SQL has become the single most important skill of the Oracle professional. While not appropriate for the beginner, this book allows senior Oracle professionals to explore important internal mechanisms within Oracle and the powerful and complex internals of Oracle SQL execution. Topics include the internals of Oracle cost-based SQL optimizer, SQL execution internals within the library cache, Oracle SQL coding and optimization techniques, and Oracle index internals. Also included is a ready-to-use code depot full of working SQL tuning scripts, which allow for quick optimization of the SQL and indexes inside the Oracle database.
Book Description
Editorial Reviews
About the Author
Kimberly Floss is the president of the International Oracle Users Group (IOUG) , specializing in Oracle performance tuning and SQL tuning techniques. She has over 15 years of experience in information technology, with specific focus on relational database technology including Oracle, DB2, Microsoft SQL Server, and Sybase. She lives in Chicago.
Product Details
Would you like to update product info or give feedback on images?
|
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
23 of 25 people found the following review helpful:
1.0 out of 5 stars
Horrible! DO NOT BUY!,
By Tekisui "tekisui" (Parasamgate, USA) - See all my reviews
This review is from: Oracle SQL Tuning & CBO Internals (Oracle In-Focus series) (Paperback)
First, I'm not one of the contributors to this book unlike others here who of course rated it highly, putting their interests first. Amazon, you should do a better job of checking someone's role before you let the rating get skewed by unscrupulous contributors.
Second, I did my PhD in this area and teach graduate school in database theory. So I was excited to read the description. Unfortunately, the other reviewers are accurate: this covers multiple versions which are not interchangeable; has errors; covers nothing not available on the Oracle website; uses many different authors. I found it very misleading that the publisher let a compilation of mostly old articles pass as a new text with this title. Of course Rampant also says that books in this series are for professionals who know the concepts and it keeps its books at 200 pages or less to be concise. When I last checked the number of people who really knew optimizer internals was very small. Oh, and this declaration was on page 341. I guess Rampant needs more editing expertise. Bottom line don't waste your money. Don't contribute to the hacks using this as marketing for their consulting efforts.
14 of 15 people found the following review helpful:
1.0 out of 5 stars
Absolutely worthless,
This review is from: Oracle SQL Tuning & CBO Internals (Oracle In-Focus series) (Paperback)
Easily the most useless Oracle book I've ever read.
I lost track of how many times it referred to the 'new features' in 8i. It even has a warning about using the CBO in release 7. Then it introduces new features in 10g. Is this a new features book or a tuning book? Does it know what it aims to be? To add insult to injury, it provided no information that isn't easily accessable from the Oracle website or Metalink. I should call the police because Ms. Floss and Rampart robbed me.
20 of 23 people found the following review helpful:
1.0 out of 5 stars
Big disappointment,
By
This review is from: Oracle SQL Tuning & CBO Internals (Oracle In-Focus series) (Paperback)
If this book had been sent to market as "'Intro to SQL Tuning with Reprints of Previously Published Material by Various Gurus and Breezy Transition Paragraphs by Kimberly,' editor K. Floss available in Large Print Edition Only" I wouldn't feel so ripped off. In that case, my only complaints would have to do with various inaccuracies. Basically, if you know enough about Oracle to be interested in CBO internals, you probably know everything in this silly little book.
Share your thoughts with other customers: Create your own review
|
|
Inside This Book
(learn more)
First Sentence:
In recent versions, Oracle has added many enhancements to their database software to facilitate improved performance. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
corresponding attribute set, stats iot, student summary table, prespawned processes, using external tables, middle query, user unused col tabs, file parallel write, student tuple, redo size, inner query, private outline, storing expressions, correlated queries, correlated query, explain plan output, innermost query, table outer join, driving table, outer joined, tuning advisor, full table scan, stored outlines, optimizer mode, stats table Key Phrases - Capitalized Phrases (CAPs): (learn more)
Oracle Corporation, Sally Cox, John Smith, Enterprise Edition Release, Name Null, Trace Assistant, George Pilcher, New Mexico, Portal Combat, Description Of Column Contents, Mon Apr, Robin Schumacher, Creates the Expression, Job Jobc, Pete Cassidy, Age of Umpires, Glasgow Crash Simulator, Listener Control, London Dome, Manic the Gerbil, Optimize Query Speed, Optimizing Connect Time, Query Plan, Tonic the Gerbil New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
In recent versions, Oracle has added many enhancements to their database software to facilitate improved performance. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
corresponding attribute set, stats iot, student summary table, prespawned processes, using external tables, middle query, user unused col tabs, file parallel write, student tuple, redo size, inner query, private outline, storing expressions, correlated queries, correlated query, explain plan output, innermost query, table outer join, driving table, outer joined, tuning advisor, full table scan, stored outlines, optimizer mode, stats table Key Phrases - Capitalized Phrases (CAPs): (learn more)
Oracle Corporation, Sally Cox, John Smith, Enterprise Edition Release, Name Null, Trace Assistant, George Pilcher, New Mexico, Portal Combat, Description Of Column Contents, Mon Apr, Robin Schumacher, Creates the Expression, Job Jobc, Pete Cassidy, Age of Umpires, Glasgow Crash Simulator, Listener Control, London Dome, Manic the Gerbil, Optimize Query Speed, Optimizing Connect Time, Query Plan, Tonic the Gerbil New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Books on Related Topics
(learn more)
|
|
What Other Items Do Customers Buy After Viewing This Item?
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
