Oracle9i DBA Handbook | 
|  | | |
 This book is also available, brand-new, from 3rd-party marketplace sellers at Amazon.com, from $10.00. |
The HTML code below can be pasted onto your web-site, your MySpace page, or blog - or any number of similar places - to create a link to this page: If, instead of a text link, you'd like to create a link to this page which will display the book cover, if it's available, then the code below will do exactly that:
Check for the same book at these other US book sites:
• [ Abebooks ] • [ Alibris ] • [ Barnes & Noble ] • [ Half.com ] • [ Powells ] … or check UK bookstores
| Editorial Review / Publisher's Information:
Product Description
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.
| Other Items You May Enjoy:
Browse Books From These Related Subjects:
Customer Reviews:
• It's A Handbook, Not A Study Guide/replacement For Metalink 15 February, 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.
- Reviewed by customer ID: A1CL81D0C51BH2
• Don't Understand All The Negative Reviews 29 July, 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.
- Reviewed by customer ID: ASF2Z8OJR0TP3
• Explanations Far Too Short Useless Avoid 16 September, 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.
- Reviewed by customer ID: A18Q5ANVGBNDNF
• This Is Not A Dba Handbook 12 January, 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"
- Reviewed by customer ID: A2JEB9HY8U7AWS
• Can Oracle Dbas Work With These Types Of Handbooks? 21 July, 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.
- Reviewed by customer ID: ATTIOAJGB0TW7
|
