Oracle Database Administration: The Essential Refe
A Quick Reference for the Oracle DBA
Publisher: O'Reilly Media
Final Release Date: April 1999
Pages: 582

Oracle database administration requires a vast amount of information and an ability to perform a myriad of tasks--from installation to tuning to network troubleshooting to overall daily administration. Oracle provides many tools for performing these tasks; the trick is knowing what tool is right for the job, what commands you need to issue (and when), and what parameters and privileges you need to set. And, as every DBA knows, you need to know how do all this under pressure, while you face crisis after crisis.This book provides a concise reference to the enormous store of information an Oracle DBA needs every day (as well as what's needed only when disaster strikes). It's crammed full of quick-reference tables, task lists, and other summary material that both novice and expert DBAs will use time and time again. It covers the commands and operations new to Oracle8, but also provides Oracle7 information for sites still running earlier versions.Oracle Database Administration provides two types of material:

  • DBA tasks--chapters summarizing how to perform critical DBA functions: installation, performance tuning, preventing data loss, networking, security and monitoring, auditing, query optimization, and the use of various Oracle tools and utilities
  • DBA reference--chapters providing a quick reference to the Oracle instance and database, the initialization (INIT.ORA) parameters, the SQL statements commonly used by DBAs, the data dictionary tables, the system privileges and roles, and the SQLPlus, Export, Import, and SQLLoader syntax
The book also includes a resource summary with references to additional books, Web sites, and other online and offline resources of special use to Oracle DBAs.Oracle Database Administration is the single essential reference you'll turn to again and again. If you must choose only one book to use at the office, keep at home, or carry to a site you're troubleshooting, this will be that book.
Table of Contents
Product Details
About the Author
Recommended for You
Customer Reviews


by PowerReviews
oreillyOracle Database Administration: The Essential Refe

(based on 4 reviews)

Ratings Distribution

  • 5 Stars



  • 4 Stars



  • 3 Stars



  • 2 Stars



  • 1 Stars



Reviewed by 4 customers

Displaying reviews 1-4

Back to top


Oracle Database Administration: The Essential Reference Review

By Steve Rodolfich

from Undisclosed

Comments about oreilly Oracle Database Administration: The Essential Refe:

I've worked on Oracle before, but I certainly wished I had this handy

book back then. It helped that I had an Oracle project to work on so I

could apply what I read. It was also helpful using the book as a

reference to troubleshoot during my project.

Assuming the reader has a solid understanding of database principles,

this text is a great tool to have handy in your shop. The focus of the

book is squarely on Oracle 7 and 8. Those looking for help with 8i and

above need to look elsewhere.

The book is a great companion to Oracle's Metalink site and is not

intended on replacing any existing references. Any Oracle

troubleshooting should start with this companion to get a general

understanding of the issue with followup requiring other resources. In

terms of troubleshooting, I doubt many will find solutions in this text,

however it will provide some background and insight into most issues.

The text is written in a concise manner and does a good job in

explaining the many Oracle tools without being too wordy. An area I

found sorely lacking was the installation chapter which glossed over

options and made assumptions that did not always apply to real-world

situations. However to be fair, an accurate coverage of Oracle

installations and all the pitfalls would probably take several books.

The first part of the book serves it's purpose in getting anyone with

some DBA knowledge up and running on Oracle. Practice is vital to

understanding the concepts explained in this section. I highly

recommend executing the queries and peeking into the INIT.ORA files when

necessary or else most of the concepts will escape you.

The second part of the book consists of DBA Reference chapters.

Particularly valuable is the SQL syntax and Oracle Data Dictionary

chapters. Again, very concise and does a good job of explaining the

subject without being confusing.

All in all, a useful book to have around, especially for those

supporting older Oracle installations. Relies heavily on other

resources, although it does help in navigating the Oracle course.


Steve Rodolfich is a Software Developer / Systems Administrator for FGM,

Inc. [] Steve has a BBA in Management Information

Systems and MBA from the University of Hawaii. He works with various

technogies developing 3-tier architecture solutions. The three greatest

joys in his life is his wife, daughter, and TiVo. Steve can be reached

at [...]


Oracle Database Administration: The Essential Reference Review

By K Vainstein

from Undisclosed

Comments about oreilly Oracle Database Administration: The Essential Refe:

Marc-Oliver, don't hold your breath. O'Reilly appears intent on not updating the important books in the Oracle series, and instead publishing [a] new titles on minor/side topics, and [b] Incredibly And Yet Another PL/SQL books.

Whatever. I'm glad to have had advantage of the key books when they were still mostly relevant.

(1 of 1 customers found this review helpful)


Oracle Database Administration: The Essential Reference Review

By Marc-Oliver Ihm

from Undisclosed

Comments about oreilly Oracle Database Administration: The Essential Refe:

A Must have for every DBA ! It has more coffee-stains than any other of my books !

Serves both as a reference for everything Oracle and as a quick-start-guide for selected topics (e.g. tkprof or SQL*Loader).

I only miss chapters about oracle built-in-packages (I use "Harrison: Oracle Desk Reference" for this).

Waiting impatiently for the new release to cover 8i/9i !


Oracle Database Administration: The Essential Reference Review

By Kevin Bass

from Undisclosed

Comments about oreilly Oracle Database Administration: The Essential Refe:

This is a very good reference book. As a new DBA, I have found the material on database configuration, installation and administration to be very informative and straight-forward.

This book along with Oracle Security: Protecting Oracle Databases, is a great reference combination for the successful of a new DBA.

Displaying reviews 1-4

Back to top

Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Print:  $39.95