Oracle DBA Automation Scripts [Paperback]

Rajendra Gutta (Author)

Book Description

Publication Date: April 11, 2002

Oracle DBA Automation Scripts shows you how to build the scripts that automate the daily operations of Oracle database management. These scripts will work in a variety of environments, including the Windows NT, Sun Solaris 2.x, Sun OS 5.x, HP-UX 11.x, and AIX 4.x operating systems. You'll learn the command differences between these operating systems and how to write scripts to integrate SQL with your OS. Whether you're an aspiring DBA or you have a few years under your belt, you'll be able to use the commands and scripts presented here to install, operate, manage, and tune Oracle databases.

Editorial Reviews

From the Back Cover

This book provides valuable, time-tested scripts for any DBA to automate the daily administration activity of an Oracle database. It provides scripts for Space management, Backup and recovery, tuning and other handy scripts (locking, user reports, resource usage etc.), which are very useful for troubleshooting everyday problems. The title highlights the need to identify and fix potential problems before they can cause loss of data, and in turn loss of business and user productivity.Our book will outperform the competition by providing more scripts and listing and explaining the syntax and implementation of each script for Unix and Windows platforms. * @Bullet1 = 72% of Oracle's 5 million downloads were for Windows NT O'Reilly's scripts do not work on Windows NT

About the Author

Rajendra Gutta is a Senior Principal Consultant and DBA with Oracle Corporation, holds a Bachelors degree in Computer Science, a Masters in Technology Management, and is an Oracle Certified Professional (OCP). More importantly, he spends his days solving the problems of experienced enterprise-level DBAs and knows the obstacles they face.

Product Details

• Paperback: 408 pages
• Publisher: Sams (April 11, 2002)
• Language: English
• ISBN-10: 0672322684
• ISBN-13: 978-0672322686
• Product Dimensions: 9.1 x 7.4 x 1 inches
• Shipping Weight: 1.6 pounds
• Average Customer Review: 4.2 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #2,700,967 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

10 of 10 people found the following review helpful:

5.0 out of 5 stars For new DBAs and teams wanting to deliver turnkey systems, June 1, 2002

By 

Rachel Tozier (Brea, CA USA) - See all my reviews
(REAL NAME)   

This review is from: Oracle DBA Automation Scripts (Paperback)

This collection of scripts cover all of the major DBA functions. Since most experienced DBAs have already amassed their tools, this book is for the newer DBA. It will give you a ready made collection of the basic scripts, which you can modify and perfect as your experience grows.

I like this collection because it allowed me and my team to bundle production ready scripts into an application that we developed for internal company use. Although me and most of my team were DBAs in the past out personal script collections were out of date. We bought this book, tailored the scripts we needed to production tasks to support our application and were able to release a turn key application to production. Since the scripts were provided on CD ROM and were relatively bug free this book saved us hundreds of development hours and allowed us to deliver a system that had a higher value than one that is tossed into production.

If you're a new DBA this book and the scripts that come with it will kickstart your tool library. If you're a developer that is building an Oracle application and want to deliver a complete solution this book will save time and money.

1 of 1 people found the following review helpful:

4.0 out of 5 stars Excellent compendium of Oracle DBA scripts, July 9, 2003

By 

Vinicio Valencia (MIAMI, FLORIDA United States) - See all my reviews
(REAL NAME)   

This review is from: Oracle DBA Automation Scripts (Paperback)

This is a superb book. It has a lot of escencial Oracle DBA scripts written for UNIX / NT environments. Some scripts have really nice value added; for example the backup script provided also creates a file for restoring files backed up. The UNIX section at the end has a lot of useful commands for AIX, Solaris and HP. This is not a book for teaching you how to write scripts (although it has a section devoted to it), but it's clear and simple style make it a really good help for your DBA needs.

1 of 1 people found the following review helpful:

5.0 out of 5 stars For Software Professionals who also take the role of DBA's, May 7, 2003

By 

R. Potluri "RP" - See all my reviews
(REAL NAME)   

This review is from: Oracle DBA Automation Scripts (Paperback)

I bought this book as the author claims that it caters to the requirements of DBA's of different experience levels. I am involved in all phases of project developement. This book helped me in the tasks of the database creation,database maintenance and performance tuning. Automation scripts made my job much easier in database backups. With the help of this book I could
configure new Oracle 9i database and made it fully functional in four hours. Its a great book if you are working on Oracle installed on windows or unix. I feel that it is really worth its price.