Rating: 
Summary: beware of these scripts - They are dangerous
Review: Many of the scripts in this book DO NOT work. While there are several time-bombs in these scripts, the most distressing was using the script to punch views from Oracle. The script is WRONG, and does not include column aliases from DBA_TAB_COLS. I corrupted my database with this mess, and I would not recommend this book to anybody unless they have a death wish.
Rating:
Summary: Be very very careful !!!
Review: OK, idea of this kind of book is fine - to provide a set of usefull scripts for DBA's or anyone else who is working with Oracle databases. In reality some scripts simply don't work (e.g. the one which suppose to rename column in the table) - which is not disaster but some of them may cost you your job because you will end up with corrupted database (e.g. script for views creation) or it will simply kill some database functionality (like script for index recreation which will drop cluster indexes but will not recreate them, so you'll have to spend time figuring what went wrong). I am Oracle DBA for 8 years (also Cetrified DBA and Oracle DBA Master) and I like to use script-approach for daily work but make sure you know how to get out of trouble when dissaster strikes. And if you use this book it will !
Rating: 
Summary: Not on the level of other O'Reilly books
Review: The title of this book should be "Oracle Scripts for System & DB Administrators on Unix". If you're running Oracle on anything else skip this book! You'll be better of spending time on your own searching the web or writing the scripts for yourself (and yes, reinventing the wheel...unfortunately :-( I found only a couple of useful native SQL scripts that worked fine for me (on NT and MVS), but nothing that I could not find on the web or write by myself. I admit that it's hard to write an objective review of such book. You'll love it or you'll hate it - it all depends on which platform you run Oracle, how experienced you're in scripting, how many scripts you already have in your toolbox and how much time you're willing to spend testing the scripts from this book. As other readers already mentioned, you should visit O'Reilly web site first and download several updated scripts before you even start testing scripts in your environment. More universal approach to glue together SQL scripts for the purpose of this book would be with Tcl/Tk, so scripts could be run from Enterprise Manager or standalone. Just a thought..
Rating:
Summary: Not on the level of other O'Reilly books
Review: The title of this book should be "Oracle Scripts for System & DB Administrators on Unix". If you're running Oracle on anything else skip this book! You'll be better of spending time on your own searching the web or writing the scripts for yourself (and yes, reinventing the wheel...unfortunately :-( I found only a couple of useful native SQL scripts that worked fine for me (on NT and MVS), but nothing that I could not find on the web or write by myself. I admit that it's hard to write an objective review of such book. You'll love it or you'll hate it - it all depends on which platform you run Oracle, how experienced you're in scripting, how many scripts you already have in your toolbox and how much time you're willing to spend testing the scripts from this book. As other readers already mentioned, you should visit O'Reilly web site first and download several updated scripts before you even start testing scripts in your environment. More universal approach to glue together SQL scripts for the purpose of this book would be with Tcl/Tk, so scripts could be run from Enterprise Manager or standalone. Just a thought..
Rating:
Summary: Book is for Unix (Should have been labeled so!)
Review: There are a few useful scripts but I have to work more than I should to make them all work in an NT environemnt. The best two scripts 'alertlog' and 'every5' were written for Unix and I cannot use them as is w/o MUCH conversion. Also the book is VERY light on explaining the scripts (no source in book - impossible to review - scripts are only on CD). The best book on scripts so far is the Oracle Press 'PL/SQL Annotated Archives' by Loney. Now THAT book was worth ten times what I paid for it. It had many useful scripts ready for cut and paste.
Rating:
Summary: Book is for Unix (Should have been labeled so!)
Review: There are a few useful scripts but I have to work more than I should to make them all work in an NT environemnt. The best two scripts 'alertlog' and 'every5' were written for Unix and I cannot use them as is w/o MUCH conversion. Also the book is VERY light on explaining the scripts (no source in book - impossible to review - scripts are only on CD). The best book on scripts so far is the Oracle Press 'PL/SQL Annotated Archives' by Loney. Now THAT book was worth ten times what I paid for it. It had many useful scripts ready for cut and paste.
Rating: 
Summary: This book is a lifesaver! The novice should be careful.
Review: This is a great book, full of useful scripts that will make the DBA's life easier in many ways, and occasionally save his/her hide as well! The book is not geared towards the novice, and certainly is not a tutorial on Oracle database administration, but the scripts cover the entire range of DBA tasks. The reader should pay careful attention to the introduction, where the authors lay out the need for some customization and care - some of the other comments posted here are from people who obviously didn't pay attention to this section. There is no way a book of scripts will work "out of the box" for every environment, and they make no pretense about this. This book is a great value for the price, but it won't replace using your brain!
Rating:
Summary: Why was this book written?
Review: We are used to books with example programs that contain errors. But this is Oracle Scripts, a book that is actually just a collection of scripts. Since the whole purpose of the book is to provide scripts to run, you would think the authors would have given them out to a dozen friends for testing. But nooooo.... It's not just a matter of customizing the scripts for your system. The publisher's web site has a link for "updated" scripts, where you can download 20 scripts that either have bug fixes or were accidentally omitted entirely from the book's CD-ROM. Who is supposed to be interested in this book? Experienced DBA's will already have most of these scripts, or can find free versions from a number of sources on the web. New DBA's might like this collection if the book attempted to explain the output of the scripts, but no explanation is offered so they will be mystified. A better book is the one from Oracle Press, Annotated SQL and PL/SQL Archives.
Rating:
Summary: Should have been named " Unix Oracle Scripts"
Review: When I bought this book through the Amazon online, I did not have the opportunity to review the book otherwise I would not have bought the book!. This does not mean that the book is not good, what this means, is that most of the scripts needs to be modified to run on any other platforms other than Unix. The Authors, should have named the book "Unix Oracle Scripts". The scripts that are native sql, works fine but you have to rewrite the rest of the scripts to run for example in Windows NT oracle 7.4. Next time I buy the book from the Amazon.com, I will need to exactly know what platform the scripts are supposed to support. One of the reason for buying this book, was to cut the development time. It turns out , that I have to rewrite these scripts to run on NT. I would have done better writting them myself. I give the book a one star.
| 
