Search
  Shop

Programming

Certification Central

Reference

Databases

Tuning

Database Management Systems

SQL

PL & SQL

General

Data Warehousing

DBA

Oracle Press

Kindle Edition

 
 
 
 
 
 
 
 
 
 
 
Home

Databases

Oracle9i DBA Handbook

Oracle9i DBA Handbook
Email a friendEmailView larger imageZoom

Oracle9i DBA Handbook

 
SKU:  

In Stock
Availability:   Usually ships in 1 business days
Only 1 left in stock, order soon!
 
 

This authorized guide from Oracle Press explains how implement all the new features of Oracle9i and manage a robust, high-performance Oracle database. You'll get new and revised material on installation, database creation, using STATSPACK, Recovery Manager, Oracle9i Application Server, external tables, flashback queries, and much more.

 
List Price: $59.99
Our Price: $40.49 & this item ships for FREE with Super Saver Shipping.
You Save: $19.50 (33%)
 
 

Note: Item may be sold and shipped by another company. Learn more.


Product Details
Author:Kevin Loney
Paperback:1008 pages
Publisher:McGraw-Hill Osborne Media
Publication Date:November 28, 2001
ISBN:0072193743
Package Length:8.98 inches
Package Width:7.32 inches
Package Height:2.2 inches
Package Weight:3.62 pounds
Average Customer Rating: based on 12 reviews

Customer Reviews
Average Customer Review:3.0
Write an online review and share your thoughts with other customers.

5 of 5 found the following review helpful:

4Don't understand all the negative reviews  Jul 29, 2005
First off, I purchased this book as I am taking a course in Relational Database Design using Oracle 9i. I had labs to do that involved setting up user accounts, giving/revoking permissions to tables, etc. THe "Complete Reference" didn't have the necessary information--some but not all. This book--the DBA Handbook--had more complete information that quickly gave me me the information that I needed to answer the questions. I must admit that I shyed away from it at the beginning of the course because I read all the negative comments here. But I am glad that my desperation (because the Oracle product documentation was absolutely no help) pushed me to go to nearest Borders to check it out before purchasing it. I am happy with it.

1 of 2 found the following review helpful:

2Can Oracle DBAs work with these types of Handbooks?  Jul 21, 2005
It is a good compilation of Oracle DBA 9i functionality. When it comes to using for real DBA work, I find it nearly impractical. One can not cover every little detail in a book like this to call it a handbook. With information available from software provider, books need to be written in much simpler manner rather than regrugitating what already exists.

I am more of an Oracle training manuals person which gives many specifics around various concepts and commands. I basically classify basic DBA knowledge at four levels(see below). You can basically control database behaviour at the system level(ALTER SYSTEM) or at the session(SET) level and some programmatically using Oracle supplied(DBMS) packages. Once you understand this idea, you can expand knowledge of various parameters and commands by simply searching them in Oracle documentation and using them as needed. Offcourse I do expect DBAs to know about Oracle architecture. Well can someone write a book in 100 pages that acts as a good starting point rather than redundant reference.

Four Levels:
a)Oracle Software Level(Installing, Patching etc.), Universal Installer teaches you a lot. Knowing OMF and OFA is recommended. Understanding Architecture.
b)Oracle System/Database Level: Setting parameters at instance level, creating control files, parameter files, tablespaces and altering them. Oracle Database Configuration Assistant and OEM can help you here.
c) Control at session level using SET command.
d) Backup and Restore: SQLLoader, Export, Import, RMAN utilities, Operating System Backups.
Tuning issues fall under b and c category.

Hope this helps. I tried using the reference, not very successful in what I wanted to do. Price wise the book is a deal.

1 of 2 found the following review helpful:

2This is NOT a DBA handbook  Jan 12, 2005
This book falls far short of being a DBA handbook. It is more useful to someone who needs to "get by" for a few weeks while their DBA is away.

It is ok at showing you how to "do things" in some cases (hence 2 stars). But, if you need to work backwards (i.e you might want to query dictionary tables to find out where something lives and why) then this book is almost useless. I am an experienced Oracle DBA and decided to write this review after referencing this book 10 times in the past week and not finding any help at all from this book in each case. The index is worse than useless.

This books title should have been "a DBA overview"


1 of 3 found the following review helpful:

2explanations far too short USELESS AVOID  Sep 16, 2004
I have 2y. experience on Ora8i & 9i.2 on windows 2000 and winXP german platform. Bought tons of those fat & bulky Oracle books of all these gurus (Loney, Urmann, Trezzo, ...) including 9i reference books. A lot of money thrown out!

Oracle (9i) Universal Installer and oracle Enterprise Manager got more foolproof, I recommend to install w/o a book first & let the wizzard do the work. Oracle 10g should be even more "adaptive".

We had bought the official german translation Oracle Press/Hanser for a migration project from Sybase Adaptive Anywhere 7.0.4 to Oracle 9i.2. well, maybe everything is covered, but explanations are FAR too short.
example 1: the new feature pfile or spfile instead of init<...>.ora
This is not even a reference book! Just a waste of 2.36 inch (6cm) space on your bookshelf to say it straight.
example 2: book index lacks the keywords you are looking for

At least the book (german edition) is long lasting, nicely layouted and printed on decent quality paper. It doesn't fall apart as other Oracle paperbacks from Osborne/McGrawHill. Two stars for that.

All in all, if you are in deep trouble with your Oracle Database don't hope for help of these authors/gurus, i.e. no e-mail support.
Better get a free sign up to Technet (OTN) and save the money for a TOAD license. Or buy a book from Mike Ault.

Last but not least it's an outdated book (as of Sep 2004), Oracle 10g is out. it's a fast paced world.

4It's a handbook, not a study guide/replacement for Metalink  Feb 15, 2003
I'm an Oracle developer who has inherited admin responsiblities for a medium sized database/application. This book DOES provide the information necessary to do that.

I am pursuing the OCA/OCP track as part of this new responsibility and, as other reviewers have stated, this book does NOT act as a study guide by itself.

Additionally, it is NOT a replacement for Metalink for more subtle problems/issues.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 About UsContact Us
 
Web business powered by Amazon WebStore