Amazon.com Review
In
Oracle SQL & PL/SQL Annotated Archives, authors Loney and Carmichael have assembled a topical collection of SQL & PL/SQL scripts for Oracle7 and Oracle8. Although this book is not by any means a tutorial for the database's programming language, even skillful database administrators can learn much from the illustrated techniques.
The book begins with a chapter of Oracle8-specific scripts that include warning indicators for password expirations, scripts for determining value distributions across table and index partitions, and others. The rest of the chapters are devoted to particular topics. The first section addresses performance management and includes several scripts for collecting statistics and managing the System Global Area. These performance-related scripts are extremely valuable for any developer.
Next comes a series of scripts related to monitoring transactions, diagnostic utilities to analyze data definition, and similar scripts for managing objects and space. Then it's on to diagnostic and utility scripts for managing users and some general database scripts. The book wraps up with a lengthy appendix that serves as an excellent reference to the PL/SQL language.
Each chapter begins with summary of its scripts, and they are also included on the CD-ROM. Explanatory text is clearly identified as annotations, but the majority of the book consists of highly technical reading. While this book does not make for a very entertaining read, it provides Oracle administrators with powerful tools they can turn to in a pinch. --Stephen Plain
From the Back Cover
The Ultimate Collection of SQL & PL/SQL Scripts and Expert Commentary.
Add power and fine-tuning to your daily programming, administration, and management tasks with this collection of annotated SQL and PL/SQL scripts.
This unique book and CD set from best-selling author Kevin Loney and Oracle DBA Rachel Carmichael provides you with an extensive collection of scripts--each accompanied by expert commentary on how to customize and use it. You'll also discover numerous proven techniques for resolving problems such as improperly sized memory areas, random number generation, and object dependency issues. The critical topics covered include:
Performance tuning Transaction management Deadlock resolution User management Data and relationship management Predicting and managing space requirements Managing Oracle8-specific features including abstract data types, partitions, expiring passwords, and more
Perform all your database and application management tasks more efficiently with the help of this valuable Oracle tool!
