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

• Introduction

Part II: Scripts for DBAs

• Database Control Utilities
• Database Performance and Trend Analysis Utilities
• Database Reliability Monitoring Utilities
• Database Security Reports and Utilities
• Database Backup Utilities
• Oracle Applications Utilities

Part III. Scripts for Developers and Designers

• Database-Design/DDL Utilities
• Database Developer Utilities

IV: UNIX Utility Scripts

• General System Utilities
• Directory and File Management Utilities
• Memory Usage Reports

Part V. Appendixes

• A. SQL Scripts That Create Oracle Tables
• B. Tables Created by SQL Scripts
• C. SQL Scripts That Create Output Files
• D. Output Files Created by SQL Scripts

Oracle Scripts Review,  May 05 2000
Submitted by K Vainstein   [Respond | View]



Pre-cooked scripts? That's no fun... hacking your own is far cooler.

Now, explanation of some Oracle scripting hints/techniques would have been nice (I thought this book would have just that, and bought it).

Vainst



Oracle Scripts Review,  January 12 2000
Submitted by Sanjeev Parikh   [Respond | View]



I bought this book from the US a years ago. I found it quite useful. It provides a comprehensive set of scripts essential to add into any DBAs toolbox.

I would definitely recommend it.

Sanj



Oracle Scripts Review,  October 08 1999
Submitted by N. Stiltner   [Respond | View]



Thanks for a good start.


Oracle Scripts Review,  August 18 1999
Submitted by L. Holladay   [Respond | View]



Good news. I emailed O'Reilly technical support and overnight got a new script that worked perfectly. It's just what I needed when I needed it.

I'm not happy that I had problems with the book script, and the updated web site script, but very pleased with the technical support. Thank you Stephen R. Figgins for the helpful email.


Oracle Scripts Review,  August 17 1999
Submitted by Larry Holladay   [Respond | View]



First script wouldn't work. crconstr.sql.

So I tried downloading a new version from this web site and it doesn't work for some other reason. I have DBA priveleges and am using 7.3 as is stipulated in the script. What's wrong? Who can I get help from ?


Oracle Scripts Review,  July 30 1999
Submitted by Jim Beckman   [Respond | View]



O'Reilly editing has always been excellent - until it comes to verifying scripts. Hopefully O'Reilly will at least outsource this function in the future.


Oracle Scripts Review,  July 13 1999
Submitted by Earl Shaffer   [Respond | View]



I liked the book, but it was supposed to cover Oracle8. Where is the partition information? The crtables.sql does not have partition information in the logic. How can it reproduce a partition table correctly if the script is not looking at the PARTITION_NAME from DBA_TABLES?

Maybe I am missing something.


Oracle Scripts Review,  March 10 1999
Submitted by Brian Fett, Oracle DBA   [Respond | View]



Having this book as a source for scripts is better than having to sort through web sites, user group handouts, etc.

However, I found it a little confusing to get started. All the scripts are described, yet some are just scripts that are called by other scripts ... so I found myself wanting an organized list of the scripts I can really use.

To the authors, here is a request: post to this site one more script. I want a "master script" that I can fire off that will produce a master report. If I have to enter some information, I'd like to enter it just once. If there are bugs or missing files on the book's CD, how about including fixes and files in the master script.

In other words, let's get organized.


Oracle Scripts Review,  February 22 1999
Submitted by Gary Chapman, Academic Computing, NYU   [Respond | View]



I find some nice nuggets here, but feel that
a future edition could make significant
improvements in the area of installation
instructions (details missing) and in
inconsistency among scripts... some emit files,
some write to screen, some take parameters,
some don't... some scripts need editing, some
don't... not to mention missing scripts
and files that must be obtained via the web and
manually inserted into the scripts directories.

Some independent tester should have tried to
install and run these scripts, following the instructions in the book, before they were
published.

I myself would like to see this set of scripts
re-implemented for running and display via web-browser.