Oracle Database 11g DBA Handbook (Oracle Press)

Oracle press make great books for todays DBAs. I have been using their books/manuals since Oracle 8 If you are an Oracle DBA or want to become one these books are a must have item.

Complete and comprehensive. Provides very understable examples and practical solutions. This is a very helpful reference for all oracle database administrators.

read and search especific concepts,for specific searches on defined problems and read without a specific search is hard to understand if you see surface reads have the software to practice the concepts of this book

I love this book. I'm learning a lot from it. It touches every important topic. It is indeed a great hand book.

This is a book you should have always with you. A very helpful handbook I recommend to anyone who`s willing to learn more about Oracle Database.

Good Book in a Good Shape!

love this book I needed it for class but I am keeping it for my job.

In the book and ebook in Chapter 9 Database Security and Auditing , the authors have cut and pasted the classic Becoming Another User method used in previous issues of their book and previous versions of Oracle. select password from dba_users 2 where username = 'SKING'; PASSWORD ------------------------------ 83C7CBD27A941428 1 row selected. In 11g their method does not work. If you select on the dba_users table for the password you only get a null return for it. So their classic method does not work. Instead the correct method is to query using some built in functions, like so: select 'alter user "'||username||'" identified by values '''||extract(xmltype(dbms_metadata.get_xml('USER',username)),'//USER_T/PASSWORD/text()').getStringVal()||''';' old_password from dba_users where username = 'USERNAME'; This will yield the following output string : alter user "USERNAME" identified by values 'F894844C34402B67' I would expect an suthor of Mr. Loney's caliber and Mr. Bryla's stature to have adequately done their homework. If they got this little item wrong, what other items did they get wrong in their book? I have read every one of the Handbooks since Oracle7 and I have enjoyed them tremendously. They have saved the day for myself and many other DBAs. But when you are a trusted source, we expect you to have validated your work and assumptions. I realize it is one minor gaff, but the repercussions could be huge. I am glad my boss asked me to verify that the Becoming Another User method in your book actually worked, otherwise I would have been left in a bad situation. I hope you guys put out an errata to correct these errors. Is there a web site with the corrections? For the owners of the printed copy (I own the printed copy and the ebook) getting the word to them might be a little more difficult. The rest of the book was good, but no longer so excellent. If this error has already been identified and addressed, then thank you. If not, shame on you and your technical proofer for not finding it.