Oracle Database Transactions and Locking Revealed, by Tom Kyte and Darl Kuhn

I recently came across the book called “Oracle Database Transactions and Locking Revealed” by Tom Kyte and Darl Kuhn. Usually, any new book by Tom Kyte is a big deal and acquires a huge following very quickly. Strangely enough there was only a single review on the Amazon, before I added my own.

For the reasons unknown to me, this book is literally ignored. I haven’t seen posts on the oracle-l about it, on the LinkedIn forums or Usenet. This book is relatively new, became available in November 2014, but it’s enough time for the book to be widely commented or recommended. There are no reasons not to recommend the book. The book is very short, 150 pages, and is not one of those 700+ pages monsters that Oracle books of today frequently turn into. I would wholeheartedly recommend the book to developers, developing Oracle applications. It deals with critically important subjects like locking, transactions, undo and redo.  The only thing missing from the book, which in my opinion should have been there, is flashback.

However, the book is primarily dedicated to applications developers, not meant as an in-depth study for the aspiring DBA hopefuls. The main strength of the book lies precisely in its brevity and clarity. It covers the topics of critical importance for the application development. How many times did I hear the myth about the need to commit frequently? How many times did I see “WHEN OTHERS” exception handler in its most atrocious form (“WHEN OTHERS THEN NULL”)? Tom and Darl do an excellent job explaining these things. They also provide tools to investigate redo and undo, all in 150 pages. Excellent job, must have for any application developer.


About mgogala

I am a consultant with an extensive Oracle DBA experience. I have worked on very large databases. I have worked with OPS and RAC since its inception.I am also a published book writer, having published two books about PHP. This blog is about the challenges and adventures in my professional life. Sorry, no family pictures here.
This entry was posted in Uncategorized. Bookmark the permalink.

One Response to Oracle Database Transactions and Locking Revealed, by Tom Kyte and Darl Kuhn

  1. Alistair Wall says:

    This book has not received much attention because it is an extract from Expert Oracle Database Architecture 3rd edition :

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s