- Save 10% on Books for Schools offered by Amazon.co.uk when you purchase 10 or more of the same book. Here's how (terms and conditions apply) Enter code SCHOOLS2016 at checkout. Here's how (terms and conditions apply)
Effective Oracle by Design (Oracle Press) Paperback – 1 Sep 2003
|New from||Used from|
- Choose from over 13,000 locations across the UK
- Prime members get unlimited deliveries at no additional cost
- Find your preferred location and add it to your address book
- Dispatch to this address when you check out
Special Offers and Product Promotions
Customers Who Bought This Item Also Bought
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Effective Oracle by Design [provides] a lot of examples and tips that you
can use everyday.
-- Oraclehome.co.uk, July 2006
From the Back Cover
Streamline Application Development with Help from an Oracle Expert
Oracle guru Tom Kyte has written the definitive guide to designing and building high-performance, scalable Oracle applications. Providing detailed code examples throughout, Tom teaches proactive and efficient methods to develop and tune Oracle applications that fully exploit the database. You'll learn how to maximize the built-in functionality of the tools you're using in order to achieve the best results possible. From the exclusive publisher of Oracle Press books, this is a must-have resource for all Oracle developers and DBAs.
- Use SQL*Plus, TKPROF, STATSPACK, JDeveloper, and other tools
- Take advantage of Oracle's scalable architectural implementations
- Handle administration with SPFILES, Oracle Managed Files, and Automatic Segment Space Management
- Use archivelog mode, RMAN, and Data Guard for bulletproof backup and recovery
- Improve statement processing by using bind variables and reducing parsing
- Make full use of the Cost Based Optimizer (CBO)
- Choose data structures that result in effectively designed schemas
- Write efficient SQL statements and high-performance PL/SQL code
- Learn invaluable techniques from an Oracle insider
What Other Items Do Customers Buy After Viewing This Item?
Top Customer Reviews
Thomas Kyte is well known for being an excellent writer, and in fact the material is presented here in a clear, concise yet complete manner, and it's very easy to follow the discussion and reproduce the examples.
The examples themselves are one of the greatest strengths of this book, because they illustrate, and prove, the topics discussed (and so what is written is *reliable*, which is of course a fundamental property for any technical book, but a quality seldom found in other Oracle tomes). At the same time, the examples (written mostly in SQL and PL/SQL) teach you a lot about how to code appropriately (the Author being a well-known SQL guru), showing e.g. syntactic variations, useful Oracle-supplied packages, new Oracle extensions ... I strongly believe that in order to be a good developer you must be exposed to high quality code, and reading this book is an excellent way to achieve this (well, I learnt more about SQL and PL/SQL from Thomas Kyte's books than from other books dedicated exclusively to SQL and PL/SQL programming).
The book is also magic - it can read your mind. Yes, I had in store a couple of non-trivial questions to be asked on asktom.oracle.com, and I found the answers in the book!Read more ›
Usually I shy away from large technical volumes because I know from experience they just sit, gathering dust, on my bookshelves. However, this book is so well written it is actually like pleasure reading. If I did have a criticism it would be that the author really pushes his mantra of "do your own benchmarking", consequently every point he makes has lenghthy examples of tests he has run along side it. Sometimes it just makes you think, "OK, I believe you, now lets get on with it". This is a minor quibble, the book is a reference, not meant to be read from cover to cover (although I did) and also much can be learnt from just looking at the code he is writing.
If you have anything to do with Oracle in your working life, other than being the most low level user, you need to read this book.
The only criticisms I can offer is that this book is rather long for what it offers and sometimes neglects to show the whys as well as the hows.
An example is with bind variables. Kyte certainly tells you how to do it but I had to learn the why and when (and when not to) from an O'Reilly book. Kyte makes the point that rarely is there a majic bullet within Oracle, that many techniques work well in many or most situations. But he soemtimes doesn't offer the theory which might lead to a good guess on what will work in your situation....
Most Recent Customer Reviews
The content of the book, i.e. what the author wrote, is excellent.
The book itself arrived very late (dispatched to wrong address) and has extensive coffee/tee stain. Read more