Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
24 used & new from $9.99

Have one to sell? Sell yours here
 
   
Oracle SQL Tuning & CBO Internals (Oracle In-Focus series)
 
 
Tell the Publisher!
I’d like to read this book on Kindle

Don’t have a Kindle? Get yours here.
 
  

Oracle SQL Tuning & CBO Internals (Oracle In-Focus series) (Paperback)

by Kimberly Floss (Author) "In recent versions, Oracle has added many enhancements to their database software to facilitate improved performance..." (more)
Key Phrases: corresponding attribute set, stats iot, student summary table, Oracle Corporation, Sally Cox, John Smith (more...)
2.6 out of 5 stars See all reviews (12 customer reviews)

List Price: $27.95
Price: $21.24 & eligible for FREE Super Saver Shipping on orders over $25. Details
You Save: $6.71 (24%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Want it delivered Tuesday, July 21? Choose One-Day Shipping at checkout. Details
14 new from $17.20 10 used from $9.99

Frequently Bought Together

Oracle SQL Tuning & CBO Internals (Oracle In-Focus series) + Oracle Tuning: The Definitive Reference (Oracle in-Focus Series) + Oracle Tuning Power Scripts: With 100+ High Performance SQL Scripts (Oracl in-Focus)
Price For All Three: $79.41

Show availability and shipping details


Customers Who Bought This Item Also Bought

Oracle Tuning Power Scripts: With 100+ High Performance SQL Scripts (Oracl in-Focus)

Oracle Tuning Power Scripts: With 100+ High Performance SQL Scripts (Oracl in-Focus)

by Harry Conway
5.0 out of 5 stars (1)  $20.40
Oracle PL/SQL Tuning: Expert Secrets for High Performance Programming (Oracle In-Focus series)

Oracle PL/SQL Tuning: Expert Secrets for High Performance Programming (Oracle In-Focus series)

by Dr. Timothy Hall
3.7 out of 5 stars (3)  $23.07
Oracle Silver Bullets: Real-World Oracle Performance Secrets (Oracle In-Focus series)

Oracle Silver Bullets: Real-World Oracle Performance Secrets (Oracle In-Focus series)

by Donald Burleson
3.4 out of 5 stars (8)  $20.40
Oracle Wait Event Tuning: High Performance with Wait Event Interface Analysis (Oracle In-Focus series)

Oracle Wait Event Tuning: High Performance with Wait Event Interface Analysis (Oracle In-Focus series)

by Stephen Andert
4.2 out of 5 stars (4)  $25.15
Oracle Database 10g Performance Tuning Tips & Techniques (Osborne ORACLE Press Series)

Oracle Database 10g Performance Tuning Tips & Techniques (Osborne ORACLE Press Series)

by Richard Niemiec
4.9 out of 5 stars (15)  $37.79
Explore similar items

Editorial Reviews

Product Description
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.

About the Author
Kimberly Floss is one of the USA's most respected Oracle Database Administrators and president of the International Oracle Users Group (IOUG). With more than a decade of experience, Kimberly specializes in Oracle Performance Tuning and is a respected expert in SQL tuning techniques. She is an active member of the Chicago Oracle User Group, and the Midwest Oracle User Group, in addition to the IOUG. Kimberly Floss has more than 15 years of experience in the information technology industry, with specific focus on relational database technology, including Oracle, DB2, Microsoft SQL Server, and Sybase. She holds a bachelors of science degree in computer information systems from Purdue University, specializing in systems analysis and design, and an MBA with emphasis in management information systems from Loyola University. Kimberly has extensive experience performing as a DBA on Mainframe, Unix and Windows-based systems, as well as managing DBA teams supporting multiple database platforms. She also works as an adjunct professor, teaching SQL Programming/Database Administration at a local community college. A popular presenter at International Oracle conferences, Kimberly lives in the Chicago-land area, with her husband, son, and two cats.

Product Details

  • Paperback: 300 pages
  • Publisher: Rampant Techpress (April 28, 2004)
  • Language: English
  • ISBN-10: 0974599336
  • ISBN-13: 978-0974599335
  • Product Dimensions: 8.9 x 6.8 x 1.1 inches
  • Shipping Weight: 1.5 pounds (View shipping rates and policies)
  • Average Customer Review: 2.6 out of 5 stars See all reviews (12 customer reviews)
  • Amazon.com Sales Rank: #990,213 in Books (See Bestsellers in Books)

    Popular in these categories: (What's this?)

    #28 in  Books > Computers & Internet > Databases > Oracle > Tuning
    #42 in  Books > Computers & Internet > Databases > Oracle > SQL
    #81 in  Books > Computers & Internet > Databases > Oracle > PL & SQL

Inside This Book (learn more)


Books on Related Topics (learn more)
 
 


Tag this product

 (What's this?)
Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.
Your tags: Add your first tag
 
Help others find this product — tag it for Amazon search
No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

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

 

Customer Reviews

12 Reviews
5 star:
 (4)
4 star:
 (1)
3 star:    (0)
2 star:    (0)
1 star:
 (7)
 
 
 
 
 
Average Customer Review
2.6 out of 5 stars (12 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
21 of 23 people found the following review helpful:
1.0 out of 5 stars Horrible! DO NOT BUY!, October 19, 2004
By Tekisui "tekisui" (Parasamgate, USA) - See all my reviews
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.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
13 of 14 people found the following review helpful:
1.0 out of 5 stars Absolutely worthless, October 16, 2005
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.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
19 of 22 people found the following review helpful:
1.0 out of 5 stars Big disappointment, September 1, 2004
By A. S. Drury (Delmar, NY United States) - See all my reviews
(REAL NAME)   
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.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
Ad
 
Most Recent Customer Reviews

1.0 out of 5 stars Beware falsely inflated ratings
One of the reviewers of this book (Donald Burleson) is also a contributor, in fact he seems to have a track record of rave reviewing books he has co-authored or published. Read more
Published on July 15, 2007 by Red Robbo

1.0 out of 5 stars Waste of time and money
As other reviewers have noted this book is mostly a collection of old lightweight articles by other authors (some of them not even credited). Read more
Published on May 16, 2006 by Art T

5.0 out of 5 stars Good internal information
I was happy with the price and quality of this book. The book has detailed information about the internal workings of the cost based optimizer and the scriptgs were helpful. Read more
Published on June 22, 2005 by Paul Z.

1.0 out of 5 stars disappointing
This book contain obsolete information. Most of the text refers to Oracle 7 or Oracle 8 and mostly incorrect information. Read more
Published on April 19, 2005 by Borg Selnik

4.0 out of 5 stars Intresting Book with wide appeal
I found this book intresting and a useful addition to my library. The information spans multple version ( I and many I work with still support Oracle8i) which is an advantage. Read more
Published on January 27, 2005 by J. Garmany

5.0 out of 5 stars Lots of great information on SQL Internals
This is the best book I've seen for tuning Oracle SQL.
It is well written, up to date (includes 8i to 10g info), and it is full of examples and real world experiences... Read more
Published on November 4, 2004 by Laura McKeenan

1.0 out of 5 stars Don't buy it!!!
Please, don't buy it. Not only it is not well structured, but it contains not up-to-date content (some parts only apply to 8i) and a lot of miskakes as well!
Published on October 15, 2004 by Antognini Christian

5.0 out of 5 stars Good book on SQL Tuning
Good book and worth the cost if you need help with SQL Tuning.
Published on September 27, 2004 by HAC

5.0 out of 5 stars Great Plain-English overview of a complex subject
I think that Kim Floss has done an excellent job in making a very complex process understandable and clear. Read more
Published on September 25, 2004 by Donald Burleson

Only search this product's reviews



Customer Discussions

 Beta (What's this?)
New! See all customer communities, and bookmark your communities to keep track of them.
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]

   


Product Information from the Amapedia Community

Beta (What's this?)


Look for Similar Items by Category


Cook with the Best Ingredients

Traditional Paella Kit
Fall into cooking or give the gift of great cooking with fresh and innovative ingredients and spices from Amazon Gourmet.

Shop more now

 

Big Savings in Books

Bargain Books
Find great titles at fantastic prices in our Bargain Books Store.
 

Dive into Summer Reading

Summer Reading for Kids and Teens
Don't even think about hitting the beach without browsing the books in our Summer Reading Store. Discover bestsellers, paperback picks, beach reads, and more terrific titles all summer long.
 

Comfortable and Cozy

Shop for Furnace Accessories
Maintain the efficiency and heating power of your furnace during the cooler months with filters and accessories. Don't be left in the cold.

Shop all heating and cooling products

 
Ad

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Where's My Stuff?

Shipping & Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue shopping: Top Sellers
Free
Free by Chris Anderson
Paranoia
Paranoia by Joseph Finder
My Soul to Lose
My Soul to Lose by Rachel Vincent
The Adventures of Sherlock Holmes
The Adventures of Sherlock Holmes by Arthur Conan, Sir, 1859-1930 Doyle

Conditions of Use | Privacy Notice © 1996-2009, Amazon.com, Inc. or its affiliates