Cost-Based Oracle Fundamentals (Expert's Voice in Oracle) and over 2 million other books are available for Amazon Kindle . Learn more
FREE Delivery in the UK.
In stock.
Dispatched from and sold by Amazon.
Gift-wrap available.
Quantity:1
FREE Delivery on orders over £10.
Condition: Used: Good
Comment: Used Good condition book may have signs of cover wear and/or marks on corners and page edges. Inside pages may have highlighting, writing and underlining. All purchases eligible for Amazon customer service and a 30-day return policy.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Cost-Based Oracle Fundamentals: v. 1 (Expert's Voice in Oracle) Paperback – 1 Oct 2005


See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
£39.49
£21.27 £0.01

Trade In Promotion


Frequently Bought Together

Cost-Based Oracle Fundamentals: v. 1 (Expert's Voice in Oracle) + Oracle Core: Essential Internals for Dbas and Developers (Expert's Voice in Databases) + Expert Oracle Database Architecture: Oracle Database Programming 9i, 10g, and 11g Techniques and Solutions
Price For All Three: £118.47

Buy the selected items together


Product details

  • Paperback: 520 pages
  • Publisher: Springer; 1st ed. 2005. 2nd printing 2007 edition (1 Oct 2005)
  • Language: English
  • ISBN-10: 1590596366
  • ISBN-13: 978-1590596364
  • Product Dimensions: 19 x 3.1 x 23.5 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (12 customer reviews)
  • Amazon Bestsellers Rank: 592,365 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

About the Author

Jonathan Lewis has been working in the information technology industry for nearly 25 years, and has been using the Oracle relational database management system for more than 20. For the past 16 years, he has worked as a freelance consultant, often spending only one or two days at a time with any client to address critical performance problems. He also advises on design and implementation problems, and on how to make best use of the most appropriate Oracle features for a given project. Jonathan is also renowned throughout the world for his tutorials and seminars about the Oracle database engine and how to make best use of it. Having visited 42 countries at last count, his exceptional ability has earned him an O1 visa from the United States, allowing him to do consultancy and lecture work there. Jonathan has written two books about Oracle (Practical Oracle8i, Addison-Wesley, 2000; Cost-Based Oracle Fundamentals, Apress, 2005), and has contributed to two others (Oracle Insights, Apress, 2004; Oracle Database 10g New Features, Oracle Press, 2004). He also writes regularly for the UKOUG magazine, and occasionally for other publications around the world. In the limited amount of time he has leftover, Jonathan also publishes high-tech Oracle articles on his blog at jonathanlewis.wordpress.com.

Inside This Book (Learn More)
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

5.0 out of 5 stars
5 star
12
4 star
0
3 star
0
2 star
0
1 star
0
See all 12 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

19 of 19 people found the following review helpful By Douglas Burns on 22 Nov 2005
Format: Paperback
It's my favourite Oracle book of the many I've read and I'm not expecting it to be surpassed any time soon.
This book takes takes a complex and essential component of the Oracle architecture, the Cost Based Optimiser, and teaches it from the basics up to the complex using an elegant tutorial style. Jonathan doesn't stint on the deep detail that's necessary to understand the subject but he doesn't baffle you with science either. You might need to read it a little more slowly and carefully than you would some third-party Oracle books and play around with the plentiful small examples (which are all available online) but that's because you're getting enough information to justify the purchase cost (and much more) and you know when you get to the end that you'll understand the subject *properly*. With that understanding, it'll be much easier to work out why the CBO is doing something that you've never seen it do before. As always with technical subjects, everything springs from the fundamentals.
No matter what your involvement with Oracle is, you can not avoid the optimiser. I bet you there'll be plenty of people in Oracle Support with this book on their desk!

If you think you're a serious Oracle professional, you should
own this book, devour the contents and experience plenty of those moments when the lights go on and you think - 'Oh, right, so *that's* why it does that'. That includes DBAs who'll learn something new about how their decisions on free lists, block sizes and so on can affect application performance.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 9 people found the following review helpful By Alberto Dell'era on 12 Jun 2006
Format: Paperback
Outstanding and excellent book - and I'm saying this after six months of reading and re-reading, and running and studying the provided scripts, and even performing my own investigations starting from the book's test cases.

It has been surprisingly easy to understand the material, even if I didn't know most of the things discussed. Reading has flown seamlessly, not exactly like reading a novel, but close enough for a technical book about the very complex CBO - and that was something I didn't expect at all, a very very nice surprise.

The most fundamental topics (the first ones are selectivity, cardinality, etc) being right at the beginning, I didn't need to read the whole book to start using the new knowledge effectively in practice, thus getting the "morale boost" that motivated me to read the next chapter, and then the next ... adding layer after layer of knowledge.

I also *loved* the high level of detail, which is absolutely necessary to understand the complex CBO, and the precise and succinct writing style as well, which makes for an easier and quicker learning. When speaking about mathematical subjects (since the CBO is just that of course - a mathematical model), it's mandatory to be precise and detailed: vague statements would only add confusion or, worstly, misunderstanding.

To recap - I've got home a vastly improved understanding of the CBO - and for a fraction of the effort I thought it would have taken.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 5 people found the following review helpful By K.E.Pearce on 12 Dec 2005
Format: Paperback
As a DBA I was really looking forward to reading this book and I wasn't disappointed. It is perhaps, a little hard-going in places, but this is not at all surprising as the subject it covers is complex.
I thought the book was well structured and very well written. Each chapter contained lots of detailed information, plenty of interesting examples and a list of downloadable scripts to illustrate the text.
All in all, I thought this was an excellent book and a very useful and comprehensive reference. It comes highly recommended and definitely deserves a place on my Oracle bookshelf.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
4 of 4 people found the following review helpful By K.E.Pearce on 14 Dec 2005
Format: Paperback
As a DBA I was really looking forward to reading this book and I wasn't disappointed. It is perhaps, a little hard-going in places, but this is not at all surprising as the subject it covers is complex.
I thought the book was well structured and very well written. Each chapter contained lots of detailed information, plenty of interesting examples and a list of downloadable scripts to illustrate the text.
All in all, I thought this was an excellent book and a very useful and comprehensive reference. It comes highly recommended and definitely deserves a place on my Oracle bookshelf.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By S. Forgie on 24 May 2007
Format: Paperback
If you are an Oracle DBA interested in Oracle performance, then this is the book for you. I have been a DBA for more than 9 years, and have read many books on the subject of Oracle performance. I can honestly say that "Cost-Based Oracle Fundamentals", along with the Tom Kyte books, are a clear cut above the rest.

Amazingly, more than 400 pages of in depth technical coverage is described as the fundamental level - this serves as a reminder that this book is the first in a series of three, all to be written by Jonathan Lewis.

As you work your way through the book, and examine the test scripts and examples provided, it becomes apparent that Jonathan Lewis has spent many years investigating and testing Oracle, enabling him to be able to share this level of depth and knowledge.

I found that one of the shortest sections - "Appendix A, Upgrade Headaches" was very helpful for my particular day to day role as a DBA. I have always found that there is a fear of what the Optimizer has in store for you, as you upgrade from one version of Oracle to the next. Jonathan Lewis manages to cover off many Optimizer specific changes between the versions that may catch you out. This serves as a very good checklist for any DBA.

Finally, I will be reading this book again, as I need to make sure I have not overlooked anything before the second instalment arrives in the shops!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews



Feedback