Oracle 24x7 Tips and Techniques

by Venkat S. Devraj

Maintaining near-flawless database uptime is a source of anxiety for countless database administrators. In Oracle 24x7 Tips & Techniques, Venkat S. Devraj has compiled an unprecedented collection of... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0072119993
• ISBN13: 9780072119992
• Release Date: November 1999
• Publisher: McGraw-Hill/Osborne Media
• Length: 1005 Pages
• Weight: 3.75 lbs.
• Dimensions: 2.1" x 7.4" x 9.1"

Customer Reviews

Viva Venkat!

I cannot begin to say how much this book has helped me. The author has dispensed with the theoretical dribble that you find in most books and given us a hands-on manual of how to administer an Oracle database from the ground up. I've just come to a 24x7 environment, so I bought this book thinking it would just help me with tuning, backup & recovery and a few other facets of the job, but after reading it, I feel confident that I could handle any type of Oracle assignment, from the capacity planning stage all the way through to production. It's that comprehensive folks, and it's written in a style that keeps you interested. He doesn't just tell you what to do, he tells you why and he tells you what to expect if you don't. I don't care what type of environment you're running, this book will help you be a better DBA and will keep you home where you belong on the weekends. Stop reading and put it in your shopping cart.

Good value for the money

A good way to judge a technical book is to turn to a section on a subject that you already understand, and see if the author knows his stuff. If he does a good job on that section, you can hope he's doing a good job elsewhere.I know enough about Oracle databases to say, this guy REALLY knows his stuff. His first chapter is on Service Level Agreements -- which is exactly the right starting point for anyone who really wants to manage the uptime of a database. After that, it keeps getting better. In three chapters I had enough to both vindicate many of my own beliefs and to call up a former client with a recommended change to the INIT.ORA I'd left them with.Wonderful book. More Oracle books should be this good. -Tom

Every single chapter is highly recommended

In today's world of "write a book in a month for the money", so many self-proclaimed "technical authors" seem to be making hay reengineering the user manuals. This book comes across as a refreshing change. The author claims to have spent a year writing it. And this time appears to have been really well spent. The book is meticulously researched and extremely well written. The topics covered are built well on top on one another. Each chapter is crucial in learning to maintain complete database uptime. At the same time, any individual chapter can be separately read. The first chapter that caught my fancy was chapter 13 (Interpreting the alert log and trace files). It dissects the alert log and systematically presents information that I have never seen before. examples: newer tracing options, tracing of PL/SQL code by dumping PL/SQL buffers, tracing ongoing sessions, detailed analysis of internal errors, etc. etc. Another real winner is chapter 14 on corruption. It provides end to end coverage on corruption. Every issue that comes to mind (and more) is presented there. The author has just not taken an Oracle-centric approach. He has gone behind the Oracle scenes and talks in detail about hardware, operating systems, and even the mysterious network. Information on triple mirroring and third-party replication such as EMC geo mirroring is unprecedented. My sincere advice: get your hands on this book.

Best Oracle DBA Book in Years

I have been an Oracle DBA for nearly 14 years and I read nearly all of the new books published on the subject. This book is the best I have read in years. Even if you aren't striving to achieve true 24 x 7 operation, the configuration and performance tips alone are better than most of the advanced tuning books on the market today.The author covers every major topic important to an Oracle DBA in great detail. He includes information that I have not found in any other source. The table of contents does not begin to describe the depth of information contained within the pages of the book.The author also gives you the benefit of his real world field experience, describing what works, what does'nt, and why. He even provides case studies which guide the reader step-by-step through the process.Have you ever wondered how to perform an Oracle upgrade or patch installation with little or no down time? Want to pinpoint which indexes need rebuilding instead of guessing? Want to be able to identify exactly which latch or enqueue is causing the trouble? Want to double or triple your income by becoming the smartest DBA on the block? Read this book.

CONGRATS ORACLE PRESS - YOU HAVE ARRIVED FINALLY

Excellent book. This is the fiirst book I have seen from Oracle Press that goes byond the usual fluff. The author has somehow managed to provide vast breadth and incridible depth in several areas. Very impressive. One important aspect I found was, the focus is not just on availability, as the title might indicate. The author has given equal importance to performance, as well. Also, in several areas he/she has provided detailed info on how Oracle works internally, which is very useful for both developers and DBAs. Especially for folks like me, who do a bit of both. For example, I have not seen before ANY other book talk about such buffer cache and shared-pool internals, comprehensve methods to enhance DBWR performance, physical aspects of bitmap indexes and related advise, available but previously undocumented tracing options, several hardware architectures, detailed NETWORK/OS tuning, etc. etc. etc. I could go on and on. I have just spend the last two weeks reading this book and still have quite a way to go. However from what I have seen this has been a great investment. I will look for more books from tuis author.