Oracle Scripts: Powerful Tools for DBAs and Developers

Overview

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 ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (26) from $1.99   
  • New (4) from $5.78   
  • Used (22) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$5.78
Seller since 2010

Feedback rating:

(1813)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
156592438X BRAND NEW. Includes unopened CD-ROM. A portion of your purchase of this book will be donated to non-profit organizations. We are a tested and proven company with ... over 900,000 satisfied customers since 1997. Choose expedited shipping (if available) for much faster delivery. Delivery confirmation on all US orders. Read more Show Less

Ships from: Nashua, NH

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$16.24
Seller since 2008

Feedback rating:

(169)

Condition: New
156592438X BRAND NEW NEVER USED IN STOCK 125,000+ HAPPY CUSTOMERS SHIP EVERY DAY WITH FREE TRACKING NUMBER

Ships from: fallbrook, CA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$20.38
Seller since 2009

Feedback rating:

(851)

Condition: New
156592438X *BRAND NEW* Ships Same Day or Next!

Ships from: Springfield, VA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$50.00
Seller since 2014

Feedback rating:

(139)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

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

Database administrators everywhere are faced with the ongoing job of monitoring Oracle databases for continuous reliability, performance, and security. This book provides a central source of previously created, tested, and documented scripts for performing these monitoring tasks. The Windows CD-ROM contains all of the scripts discussed in the book.

Read More Show Less

Product Details

  • ISBN-13: 9781565924383
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 5/28/1998
  • Edition description: BK&CD ROM
  • Edition number: 1
  • Pages: 204
  • Product dimensions: 7.01 (w) x 9.23 (h) x 0.54 (d)

Meet 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.

Read More Show Less

Read an Excerpt

Chapter 5: Database security Reports and Utilities

grantall.sql

Directory: $DBA
File Type: SQL Script
Edit Required: No
Output File: grall_tmp.sql, grall.sql

This script creates and then executes a script to grant the specified username (such as OPS$ORACLE) all privileges to all nonsystern objects in a database.

grantool

Directory: $DBA
File Type: Shell Script
Edit Required: No
Output File: Screen

This script grants SELECT access on required tables to a specific user, for use in running the $TOOLS/dbousers, $TOOLS/dbo_sql, and $TOOLS/locks utilities.

Note that if this procedure has a privilege violation when trying to grant access to the V$ tables, you must first run the grantsys.sql script, which will grant SELECT WITH GRANT OPTION to yourself, and then rerun the grantool script.

The script will prompt for the Oracle SID of the database to be accessed, and the username to be granted SELECT access to the required tables.

grantool.sql

Directory: $DBA
File Type: SQL Script
Edit Required: No
Output File: Screen

This script is called by the grantool script to perform the actual grants, as described in the previous section.

grantsys.sql

Directory: $DBA
File Type: SQL Script
Edit Required: No
Output File: Screen

This script grants to the current user account the privileges required to grant other users access to the $TOOLS/dbo and locksutilities (via the grantools script).

You will use this script when your account (typically, OPS$oracle) does not have the SELECT privilege WITH GRANT OPTION on the required V$ tables. The script will prompt you for the SYS account password.

makeops

Directory: $DBA
File Type: Shell Script
Edit Required: No
Output File: Screen
Syntax: makeops sid newuser
sid

The Oracle SID of the database to be accessed.

newuser
The new User ID (less the "OPS$" prefix) to be created.

This script creates a new OPS$ username account for a given user, matching the configuration and privileges of the user's current non-OPS$ account. This allows the DBA to quickly create an OPS$ account for a given user which is otherwise identical to the user's existing account without having to determine and duplicate existing privileges. If an OPS$username account exists, the user can then easily log into the database without having to specify a username or password. Here is an example for SQL*Plus:

sqlplus /

The account is created with an "impossible" password, so that it can only be accessed from the server, and even then only by the sqlplus "/" clause.

Restrictions

  • This script requires that the following files exist:

    $DBA/makeqps.sql
    $DBA/copyusis.sql
    $TOOLS/define
    $T0OLS/fixcase
    $DBA/valid_db

  • An OPS$username account must exist (where username matches your UNIX operating system username). This can be created by executing the creops script.
  • The PWSYS environment variable must exist. This variable must contain the password to the Oracle database's SYS account.
  • The PW environment variable must exist. This variable must contain the password to the Oracle database's SYSTEM account....
Read More Show Less

Table of Contents

Preface
I. Overview
1. Introduction
II. Scripts for DBAs
2. Database Control Utilities
3. Database Performance and Trend Analysis Utilities
4. Database Reliability Monitoring Utilities
5. Database Security Reports and Utilities
6. Database Backup Utilities
7. Oracle Applications Utilities

III. Scripts for Developers and Designers
8. Database-Design/DDL Utilities
9. Database Developer Utilities

IV. UNIX Utility Scripts
10. General System Utilities
11. Directory and File Management Utilities
12. Memory Usage Reports

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
Index

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)