Oracle Database Administration: The Essential Refe

BUY THIS BOOK

Print Book $39.95

Safari Books Online

What is this?

Print Book £28.50

What is this?

Looking to Reprint this content?

Tell a friend

Oracle Database Administration: The Essential Refe

By David C. Kreines, Brian Laskey
First Edition April 1999
Pages: 580
ISBN 10: 1-56592-516-5 | ISBN 13: 9781565925168
(Average of 5 Customer Reviews)

Book description

A concise reference to the enormous store of information Oracle8 or Oracle7 DBAs need every day, Oracle Database Administration covers DBA tasks like installation, tuning, backups, networking, auditing, and query optimization. It's also a set of quick references on initialization parameters, SQL statements, data dictionary tables, system privileges, roles, and syntax for SQL*Plus, Export, Import, and SQL*Loader.
Full Description

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 SQL*Plus, Export, Import, and SQL*Loader 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.

Browse within this book

Cover | Table of Contents | Colophon

Featured customer reviews

Oracle Database Administration: The Essential Reference Review, August 09 2002

Rating:

Submitted by Steve Rodolfich [Respond | View]

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. [http://www.fgm.com] 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 stever@fgm.com

Oracle Database Administration: The Essential Reference Review, October 11 2001

Rating:

Submitted by K Vainstein [Respond | View]

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.

Oracle Database Administration: The Essential Reference Review, January 10 2001

Rating:

Submitted by Marc-Oliver Ihm [Respond | View]

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 !

Read all reviews

Oracle Database Administration: The Essential Reference Review, December 01 2000

Rating:

Submitted by K Vainstein [Respond | View]

It is highly doubtful whether any book can save your soul.

However, if you're an Oracle DBA, this book will save your ass.

Buy it.

Oracle Database Administration: The Essential Reference Review, September 21 2000

Rating:

Submitted by Kevin Bass   [Respond | View]

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.

Oracle Database Administration: The Essential Reference Review, March 10 2000
Submitted by asim uddin   [Respond | View]

Thanks for writting the wonderful and helpful book for the Oracle Proffessionals without this book we can not understand the DBA so easily and grab the best knowledge.

Oracle Database Administration: The Essential Reference Review, October 01 1999
Submitted by elh   [Respond | View]

As stated by the other readers, this is a great book. Extremely well designed and edited. The division of the book into two section (concepts and details) made it a true pleasure to read. While the Oracle Press books are pretty good, I went with O'Reilly on the DBA topic because I just didn't want to get burdened 1200 + pages of pedantic garbage (ever notice how no Oracle books are ever weigh less than 10 pounds?). In sum, I don't regret the purchase. And while it's a lot lighter than my other Oracle books, I consider it my most valuable reference.

Oracle Database Administration: The Essential Reference Review, July 31 1999
Submitted by Spencer Johnson   [Respond | View]

As a new DBA with lots of questions, this book is just what I have been looking for!

There are no referals like in Oracle Press, just straight answers, very good.

Oracle Database Administration: The Essential Reference Review, July 28 1999
Submitted by Philip Relyea   [Respond | View]

Thank you for writing this book. There is a typographical error on page 153. In the USE_CONCAT section, /*+ USE_CONCAT /*, should be /*+ USE_CONCAT */

Oracle Database Administration: The Essential Reference Review, July 14 1999
Submitted by Rafael d´Afonseca   [Respond | View]

It´s a very good book. A lot of tips how to configue,install and admnistrate the Oracle Database. DBA must have this book as a complete reference!

Oracle Database Administration: The Essential Reference Review, May 28 1999
Submitted by Janine Sisk   [Respond | View]

I love the book so far; it's at just the right
level of detail for me.

However, I think there's an error in one of the
erratas. :) The errata page says that on p. 29,
"to the prefix TEST" should be "to the prefix
test". However, unless my eyes are deceiving me,
it doesn't say that. It says "to the prefix INIT",
which should be "to the prefix init".

Oracle Database Administration: The Essential Reference Review, May 20 1999
Submitted by Paul Simmons   [Respond | View]

Great book, The layout is designed for ease of use.

However I believe there may be a small errata p 281. 3/4 down the page. 'Enable/Disable autoexetending the size of datafiles' it refers to using the alter tablespace command, this should be alter database

Oracle Database Administration: The Essential Reference Review, May 11 1999
Submitted by John   [Respond | View]

So far, it seems to be a good book. However, on page 54-55 it misrepresents RAID-0 as mirroring. In fact, RAID-0 is striping and RAID-1 is mirroring.

Oracle Database Administration: The Essential Reference Review, April 16 1999
Submitted by Todd Fulton   [Respond | View]

Love the book!

Media reviews "If you want a good, solid, practical reference guide covering both Oracle 7 and 8, look no further." --Dave Rutlidge, Cvu, February 2001

"A well-written book, and great value for the money." --Kay Ewbank,Computer Shopper , July 2000

"This book is a must for all Oracle database administrators and developers who are working in distributed environments. It describes the techniques and tools need to design, develop, and manage huge distributed systems. I strongly recommend this book to anyone developing or administering distributed databases or preparing to do so." -L. Pasculescu, Computing Reviews August 1999

Read all reviews

See larger cover