Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
34 used & new from $0.01

Have one to sell? Sell yours here
 
   
Oracle Scripts: Powerful Tools for DBAs and Developers
 
 
Tell the Publisher!
I’d like to read this book on Kindle

Don’t have a Kindle? Get yours here.
 
  

Oracle Scripts: Powerful Tools for DBAs and Developers (Paperback)

by Brian Lomasky (Author), David Kreines (Author)
2.8 out of 5 stars See all reviews (15 customer reviews)

List Price: $29.95
Price: $21.86 & eligible for FREE Super Saver Shipping on orders over $25. Details
You Save: $8.09 (27%)
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Only 2 left in stock--order soon (more on the way).

Want it delivered Tuesday, July 14? Choose One-Day Shipping at checkout. Details
9 new from $9.95 25 used from $0.01
Also Available in: List Price: Our Price: Other Offers:
Paperback (Bargain Price) 10 used & new from $5.36
Like this book? Find similar titles from O'Reilly and Partners in our O'Reilly Bookstore.

Frequently Bought Together

Customers buy this book with Oracle PL/SQL for DBAs by Arup Nanda

Oracle Scripts: Powerful Tools for DBAs and Developers + Oracle PL/SQL for DBAs
  • This item: Oracle Scripts: Powerful Tools for DBAs and Developers by Brian Lomasky

    In Stock.
    Ships from and sold by Amazon.com.
    Eligible for FREE Super Saver Shipping on orders over $25. Details

  • Oracle PL/SQL for DBAs by Arup Nanda

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details


Customers Who Bought This Item Also Bought

Oracle DBA Automation Scripts

Oracle DBA Automation Scripts

by Rajendra Gutta
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)

Oracle SQL*Plus: The Definitive Guide (Definitive Guides)

by Jonathan Gennick
Oracle Utilities Pocket Reference (Pocket Reference (O'Reilly))

Oracle Utilities Pocket Reference (Pocket Reference (O'Reilly))

by Sanjay Mishra
4.7 out of 5 stars (3)  $9.95
Oracle Data Dictionary Pocket Reference

Oracle Data Dictionary Pocket Reference

by David Kreines
3.7 out of 5 stars (3)  $9.95
Oracle SQL*Loader: The Definitive Guide

Oracle SQL*Loader: The Definitive Guide

by Jonathan Gennick
4.4 out of 5 stars (12)  $29.19
Explore similar items

Editorial Reviews

Product Description
Because most Oracle sites have similar requirements, problems, and crises, Oracle database administrators and developers find themselves constantly reinventing the wheel by writing the same kinds of scripts -- often under pressure in hit-or-miss fashion. This book provides a powerful set of tried-and-true tools for DBAs and developers. The scripts have 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 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.

About the Author
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.

Product Details

  • Paperback: 200 pages
  • Publisher: O'Reilly Media, Inc. (May 1, 1998)
  • Language: English
  • ISBN-10: 156592438X
  • ISBN-13: 978-1565924383
  • Product Dimensions: 9.2 x 7 x 0.8 inches
  • Shipping Weight: 12.8 ounces (View shipping rates and policies)
  • Average Customer Review: 2.8 out of 5 stars See all reviews (15 customer reviews)
  • Amazon.com Sales Rank: #884,519 in Books (See Bestsellers in Books)

    Popular in this category: (What's this?)

    #38 in  Books > Computers & Internet > Databases > Oracle > DBA

Look Inside This Book

Citations (learn more)
1 book cites this book:

What Do Customers Ultimately Buy After Viewing This Item?

Oracle Scripts: Powerful Tools for DBAs and Developers
61% buy the item featured on this page:
Oracle Scripts: Powerful Tools for DBAs and Developers 2.8 out of 5 stars (15)
$21.86
Oracle DBA Checklists Pocket Reference
16% buy
Oracle DBA Checklists Pocket Reference 4.3 out of 5 stars (6)
Oracle Data Dictionary Pocket Reference
12% buy
Oracle Data Dictionary Pocket Reference 3.7 out of 5 stars (3)
$9.95
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
11% buy
Oracle SQL*Plus: The Definitive Guide (Definitive Guides) 3.9 out of 5 stars (19)

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
Check the boxes next to the tags you consider relevant or enter your own tags in the field below.

Your tags: Add your first tag
 
Help others find this product — tag it for Amazon search
No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

 

Customer Reviews

15 Reviews
5 star:
 (6)
4 star:    (0)
3 star:    (0)
2 star:
 (3)
1 star:
 (6)
 
 
 
 
 
Average Customer Review
2.8 out of 5 stars (15 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
15 of 16 people found the following review helpful:
1.0 out of 5 stars Why was this book written?, July 4, 1999
By A Customer
We are used to books with example programs that contain errors. But this is Oracle Scripts, a book that is actually just a collection of scripts. Since the whole purpose of the book is to provide scripts to run, you would think the authors would have given them out to a dozen friends for testing. But nooooo....

It's not just a matter of customizing the scripts for your system. The publisher's web site has a link for "updated" scripts, where you can download 20 scripts that either have bug fixes or were accidentally omitted entirely from the book's CD-ROM.

Who is supposed to be interested in this book? Experienced DBA's will already have most of these scripts, or can find free versions from a number of sources on the web. New DBA's might like this collection if the book attempted to explain the output of the scripts, but no explanation is offered so they will be mystified.

A better book is the one from Oracle Press, Annotated SQL and PL/SQL Archives.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
10 of 11 people found the following review helpful:
1.0 out of 5 stars Be very very careful !!!, June 4, 1999
By A Customer
OK, idea of this kind of book is fine - to provide a set of usefull scripts for DBA's or anyone else who is working with Oracle databases. In reality some scripts simply don't work (e.g. the one which suppose to rename column in the table) - which is not disaster but some of them may cost you your job because you will end up with corrupted database (e.g. script for views creation) or it will simply kill some database functionality (like script for index recreation which will drop cluster indexes but will not recreate them, so you'll have to spend time figuring what went wrong). I am Oracle DBA for 8 years (also Cetrified DBA and Oracle DBA Master) and I like to use script-approach for daily work but make sure you know how to get out of trouble when dissaster strikes. And if you use this book it will !
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
6 of 6 people found the following review helpful:
2.0 out of 5 stars Not on the level of other O'Reilly books, April 11, 2000
By Ales Kavsek (Ljubljana, Slovenia) - See all my reviews
The title of this book should be "Oracle Scripts for System & DB Administrators on Unix". If you're running Oracle on anything else skip this book! You'll be better of spending time on your own searching the web or writing the scripts for yourself (and yes, reinventing the wheel...unfortunately :-( I found only a couple of useful native SQL scripts that worked fine for me (on NT and MVS), but nothing that I could not find on the web or write by myself.

I admit that it's hard to write an objective review of such book. You'll love it or you'll hate it - it all depends on which platform you run Oracle, how experienced you're in scripting, how many scripts you already have in your toolbox and how much time you're willing to spend testing the scripts from this book.

As other readers already mentioned, you should visit O'Reilly web site first and download several updated scripts before you even start testing scripts in your environment.

More universal approach to glue together SQL scripts for the purpose of this book would be with Tcl/Tk, so scripts could be run from Enterprise Manager or standalone. Just a thought..

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

1.0 out of 5 stars Not for NT
Almost all of the SQL scripts shown require UNIX scripts for execution. Unless you know how to convert the UNIX scripts to NT this book is not very useful.
Published on July 19, 2001

2.0 out of 5 stars Thin, thin, thin
If you have some time on your hands and want to line-by-line debug/modify/enhance a set of scripts that were originally written for Oracle 7, then buy this book. Read more
Published on February 27, 2001 by A. J. Woods

2.0 out of 5 stars Book is for Unix (Should have been labeled so!)
There are a few useful scripts but I have to work more than I should to make them all work in an NT environemnt. Read more
Published on August 12, 2000 by Lee Collins

5.0 out of 5 stars Fantastic reference!
As an Oracle Certified Professional DBA, I found this book to be worth every cent. The scripts are comprehensive, covering almost every area that could possibly need attention... Read more
Published on April 16, 1999 by David C. Sisk

5.0 out of 5 stars This book saved my job!
I just bought this book and installed the scripts, and the "every5" script has already warned me of an impending disaster and as a result literally saved my job! Read more
Published on April 13, 1999

5.0 out of 5 stars Bread on the Table
About three years ago I was an Informix contractor, but Oracle8's arrival killed off the market. The dribble of contracts left were of the "Informix Project Converting to... Read more
Published on April 6, 1999 by Jack Maturin

1.0 out of 5 stars Should have been named " Unix Oracle Scripts"
When I bought this book through the Amazon online, I did not have the opportunity to review the book otherwise I would not have bought the book!. Read more
Published on March 18, 1999

5.0 out of 5 stars This book is a lifesaver! The novice should be careful.
This is a great book, full of useful scripts that will make the DBA's life easier in many ways, and occasionally save his/her hide as well! Read more
Published on January 12, 1999

5.0 out of 5 stars Excellent support for scripts
I want to ammend the rating below because I have been so impressed with O'Reilly support. While one script, crviews. Read more
Published on October 26, 1998 by Donald Burleson

1.0 out of 5 stars Poorly documented and not worth the money
Luckily my company picked up the tab, else I would have returned it. This book seems to be cooked up by some DBA's out to make a buck. Read more
Published on October 24, 1998 by kahartma@notes.up.com

Only search this product's reviews



Customer Discussions

 Beta (What's this?)
New! See all customer communities, and bookmark your communities to keep track of them.
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]

   


Product Information from the Amapedia Community

Beta (What's this?)


Look for Similar Items by Category


Let Toro Clear the Snow

Let Toro Clear the Snow
Rely on Toro for top-quality snow throwers and power shovels to make snow removal a breeze.

Shop all Toro

 

Big Savings in Books

Bargain Books
Find great titles at fantastic prices in our Bargain Books Store.
 

Buy Three Books, Get a Fourth Free

4-for-3 Books
Order any four eligible books under $10 and get the lowest-price book free in our 4-for-3 Books Store. See more details.
 

Sand It Down

Shop for sanders
Sanders are useful when preparing surfaces for painting and when making or repairing furniture.

Shop for sanders

 

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Where's My Stuff?

Shipping & Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue shopping: Top Sellers

Conditions of Use | Privacy Notice © 1996-2009, Amazon.com, Inc. or its affiliates