This book provides a powerful set of tools for Oracle database administrators and developers. During their many years of administering, tuning, and troubleshooting Oracle databases, the authors have developed hundreds of useful scripts. Now you can instantly take advantage of their experience by putting these scripts to work at your own site. DBAs and developers are constantly reinventing the wheel. Most Oracle sites have similar requirements, problems, and crises, and at most of these sites DBAs and developers find themselves reinventing the wheel by writing the same kinds of scripts -- and too often they're writing them under pressure, in hit-or-miss and error-prone fashion.The scripts in this book are tried-and-true. They've been thoroughly tested in many different environments. 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. You can also turn to these scripts in emergencies to diagnose system problems and repair databases when the pressure is on.The book includes:
Scripts for DBAs -- The ways that DBAs structure files, allocate disk space, tune systems, and enforce security have an enormous impact on how efficiently and effectively systems will operate. The scripts in this category analyze performance, check database reliability, produce security and auditing reports, perform backups and restores, and work with the Oracle Applications.
Scripts for developers and designers -- These scripts help to create, analyze, report, and reverse-engineer the objects in the database. They also allow developers to easily create EXPLAIN PLAN reports on SQL statements, and they provide a front end to RCS (the Revision Control System).
Utility scripts -- These scripts perform a variety of operating system, file, directory, and memory operations (aimed particularly at UNIX sites). You can customize these scripts for your own operating system. The accompanying CD-ROM provides a comprehensive resource for DBAs and developers. It contains complete source code for all of the scripts described in this book, as well as additional software that you will find helpful in monitoring and improving the performance of your databases.
A brief table of contents follows:Part I: Overview
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.
Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animal appearing on the cover of Oracle Scripts is a beetle (Euchroma gigantea), of the Buprestidae family of order Coleoptera. This family is commonly known as jewel beetles or metallic wood-boring beetles. Jewel beetles are some of the most brightly colored insects. They inhabit forests or tropical areas and are found on all continents. In some regions, the large, common, and brilliantly colored jewel beetles are used as body ornaments or jewelry. The larvae of the jewel beetle family are wood-borers, eating their way through various types of trees and other plants.Beetles comprise the largest order of insects in the world; there are at least 300,000 species of beetles in the world, with estimates ranging to well over a million. Species vary in size from about 0.25 mm to over 170 mm, including some of the smallest and largest of the entire insect population. Beetles have two pairs of wings, the outer of which is hardened into a leathery protective layer. They feed on various plant and animal material, and are found under earth or rocks, wood, bark, fungi, or other ground cover, frequently in rotting vegetation or carrion. ... Edie Freedman designed the cover of this book, using a 19th-century engraving from the Dover Pictorial Archive. The cover layout was produced with Quark XPress 3.32 using the ITC Garamond font. Whenever possible, our books use RepKoverTM, a durable and flexible lay-flat binding. If the page count exceeds RepKover's limit, perfect binding is used. The inside layout was designed by Nancy Priest and implemented in FrameMaker 5.0 by Mike Sierra. The text and heading fonts are ITC Garamond Light and Gara mond Book. This colophon was written by Nancy Kotary; thanks to Mark O'Brien and Chuck Bellamy for their kind help with beetle identification.
This book is seriously out of date. In fact, it should no longer be on sale.
I bought it about 4 years ago, but never got as much out of it as I could have - just about 3-4 scripts that I found useful.
Problem is now the scripts are seriously out-of-date (no partitioning, no support for Oracle8i,9i features etc).
The lack of updates/support for these scripts is disappointing. The stated purpose of this book is to prevent DBAs from re-inventing the wheel by supplying a series of tried and tested scripts. Unfortunately thousands of DBAs are now attempting to update these ageing scripts individually - or writing their own from scratch.