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...)

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

Customer Reviews

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.

13 of 14 people found the following review helpful:

1.0 out of 5 stars Absolutely worthless, October 16, 2005

By	Chuck Kueser - See all my reviews

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.

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.