Oracle Scripts: Powerful Tools for DBAs and Developers
| Author | : | |
| Rating | : | 4.56 (757 Votes) |
| Asin | : | 156592438X |
| Format Type | : | paperback |
| Number of Pages | : | 204 Pages |
| Publish Date | : | 2017-11-01 |
| Language | : | English |
DESCRIPTION:
Brian Lomasky is a senior principal consultant with Oracle Corporation Consulting Services. He specializes in Oracle database and UNIX/OpenVMS/WinNT operating system tuning, troubleshooting, configuration, backup and recovery, and database auditing. When he isn't busy creating new scripts to solve day-to-day problems for DBAs, he has been a featured speaker at the national IOUG-A and Oracle OpenWorld conferences, as well as at local user groups.
Why was this book written? A Customer 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 ac. Be very very careful !!! 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 w. Not on the level of other O'Reilly books Ales Kavsek 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 wheelunfortunately :-( 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 o
This book provides a powerful set of tools for Oracle database administrators and developers. You can use them right now to simplify the tasks you perform each day -- monitoring databases for reliability, protecting your database against data loss, improving performance, increasing security, and building reports that provide insight into the inner workings of Oracle databases. They've been thoroughly tested in many different environments. During their many years of administering, tuning, and troubleshooting Oracle databases, the authors have developed hundreds of useful scripts. Most Oracle sites have similar requirements
About the AuthorBrian Lomasky is a senior principal consultant with Oracle Corporation Consulting Services. When he isn't busy creating new scripts to solve day-to-day problems for DBAs, he has been a featured speaker at the national IOUG-A and Oracle OpenWorld conferences, as well as at local user groups.. He specializes in Oracle database and UNIX/OpenVMS/WinNT operating system tuning, troubleshooting, configuration, backup and recovery, and database auditing