REVIEW - Oracle Scripts


Title:

Oracle Scripts

Author:

Brian Lomasky, David C. Kreines

Publisher:

O'Reilly (1998)

Pages:

185pp

Reviewer:

Mike Ellis

Reviewed:

June 1999

Rating:

★★★☆☆


Put simply, if you work with Oracle databases, this book will have something for you.

Put simply, if you work with Oracle databases, this book will have something for you. DBAs will find a lot of useful scripts to extract performance statistics or security information from the database, perform backups or even create a completely new database. Application developers will welcome the scripts that will give them all the gory details of how their application is interacting with the database.

Most of the scripts are written as Operating System independent Oracle SQL and are compatible with both Oracle 7.3 and Oracle 8. There are also a few Unix shell scripts included to cover such tasks as database backup and recovery, system memory usage and so on.

As one might suspect, the book itself plays second fiddle to the CD-ROM, serving as little more than a paper index to the scripts. The CD-ROM contains the scripts four times to cope with the vagaries of DOS ad Unix. The contents of the CD are divided into two categories; those of use primarily for DBAs and those with a wider audience. Each category is further subdivided to allow the reader to quickly locate the desired script.

If you use or administer an Oracle database, this book will have something for you. For the newcomer, the scripts in this book will save you from repeating the mistakes of others. For the more experienced Oracle user, the scripts will provide a new and sometimes surprising insight into the inner workings of your database.


Book cover image courtesy of Open Library.





Your Privacy

By clicking "Accept Non-Essential Cookies" you agree ACCU can store non-essential cookies on your device and disclose information in accordance with our Privacy Policy and Cookie Policy.

Current Setting: Non-Essential Cookies REJECTED


By clicking "Include Third Party Content" you agree ACCU can forward your IP address to third-party sites (such as YouTube) to enhance the information presented on this site, and that third-party sites may store cookies on your device.

Current Setting: Third Party Content EXCLUDED



Settings can be changed at any time from the Cookie Policy page.