Portable DBA: Oracle (Paperback)

by Robert Freeman (Author) "As I mentioned in the introduction, this book is less about learning how to do something and more about actually doing it..." (more)
Key Phrases: update global indexes, impacted partitions, table system privilege, Oracle Error Message Text Description, View Name Description All User, Oracle Data Pump (more...)

Editorial Reviews

Product Description
This handy, affordable reference is ideal for on-the-job DBAs in need of quick access to administrative commands, error resolutions, and best practices. Covering the most commonly used Oracle database versions, the book contains invaluable tables so problems can be diagnosed quickly and includes examples and syntax diagrams for each command.

From the Back Cover
YOUR ON-THE-JOB QUICK REFERENCE

Carry essential Oracle Database administration information and troubleshooting techniques along with you so you can handle a wide variety of tasks on the spot. This handy resource offers fast access to administrative commands, error resolutions, best practices, and more. Written by an Oracle expert and published by Oracle Press, this convenient reference gives you quick solutions in an easy-to-find format. Don't leave your desk without it! Get details on:

Database creation and management

Rollback/undo segments, control files, and redo logs

Oracle tablespaces and tables

Indexes, views, and materialized views

Clusters

Sequences and synonyms

Users, profiles, roles, and grants

Types, dimensions, and other Oracle objects

Clauses and outlines

PL/SQL

DML commands

See all Editorial Reviews

Product Details

• Paperback: 598 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (July 21, 2004)
• Language: English
• ISBN-10: 0072229802
• ISBN-13: 978-0072229806
• Product Dimensions: 9.1 x 7.2 x 1.3 inches
• Shipping Weight: 2.2 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars See all reviews (5 customer reviews)
• Amazon.com Sales Rank: #837,097 in Books (See Bestsellers in Books)

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

  #36 in

  Books > Computers & Internet > Databases > Oracle > DBA

Customer Reviews

Most Helpful Customer Reviews

8 of 8 people found the following review helpful:

5.0 out of 5 stars A true MUST HAVE reference book, December 12, 2004

By	Dwayne Cox (Gainesville, FL) - See all my reviews (REAL NAME)

Like many Oracle DBAs, I have plenty of reference books that are useful. The problem I run into is that some tend to be quite large (i.e. 1000+ pages) and the information I need is contained in one paragragh from this book, one chapter from another and a schema diagram from yet another. I have long searched for one book to take with me to customer sites that contains examples of command usage, diagrams and concise explanations. Enter Robert Freeman's Portable DBA: Oracle.

This book is just what is claims to be: a portable reference for topics such as creating/removing a database, managing undo/rollback segments, building indexes and using the import/export utilities. This is just some of the subject matter covered. There are also appendices containing Oracle syntax, data dictionary views and initialization parameters.

Note that this book is not a tutorial and assumes you are knowledgeable in at least the basics of being an Oracle DBA. Having said that, it is full of examples to help jog your memory in how to use a certain command as well as giving you enough infomation so that you can research a command more fully in other reference materials.

Lest I forget, Mr. Freeman's writing style is easy to read and instructional without getting too technical. He knows his stuff and knows how to teach as well.

At just under 600 pages, you will not be carrying this in your back pocket. But, if you want one DBA reference book to take with you in your travels, this is the one.

Highly recommended!!!


Dwayne Cox
Oracle DBA for over 6 years

1 of 1 people found the following review helpful:

5.0 out of 5 stars Great book for all DBAs, April 20, 2005

By	Kent Crotty (North Carolina) - See all my reviews (REAL NAME)

This is a book all DBAs must have! As a DBA for over 5 years, I have been waiting for a book like this to come out for some time and Robert Freeman has hit the mark! This book has all the basic essentials for my day to day job. I don't know how most people, but I have a hard time remembering the exact syntax of all the commands. The DBA Cheat Sheet section has helped me every time. And if I need more information, I just look in the chapters and I always find it.

Another great feature of the book is the error sections. Robert has included the typical errors that you may run into when issuing commands. Then provides possible causes and solutions. It's all right there without having to search Metalink or Oracle's documentation.

I highly recommend this book. It has been a welcome member in my book collection and has replaced a number of them.

2 of 3 people found the following review helpful:

1.0 out of 5 stars Reference Manual Replica, September 5, 2005

By	A. Khan "Arif Khan" (( London, United Kingdom)) - See all my reviews (REAL NAME)

I hate being a critic of the Oracle Books but I believe constructive criticism is good for the Oracle Authors and they benefit the Oracle Community in the long run.

This is a good book If you are looking for a mini and heavy Reference Manual instead of the online help or Oracle Documentation CD.
For all those who are used to the old Oracle Handbook, this is nothing but a replica of it with a cool name.

For all those who want to add a book to the book shelf , it is a piece to add to increase the numbers. But for people who are keen to keep the bookshelf with usable books, this is not the right book.

Arif Khan
Oracle Consultant, London.