| OverviewA 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. Editorial ReviewsProduct DescriptionOracle 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. |
Top Sellers in This Category | Browse Similar Topics | | Top Level Categories:Sub-Categories: | | | |
Reader Reviews From Amazon (Ranked by 'Helpfulness') Average Customer Rating: based on 23 reviews. Oracle, The Essential Reference Review, 2002-08-10 Reviewer rating: 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. --------------------- ... | An excellent reference book!, 2001-02-15 Reviewer rating: This is an excellent reference book. I am an experienced Oracle DBA and I use it as a quick reference. The topics are well organized and to the point. David Kreines and Brian Laskey have done an excellent job. | How can 130pages for 7 chapters clearly explain DBA's work?!, 2000-11-23 Reviewer rating: Can't understand why someone gives it 5*, ... worse than handbook and document came together with cd. I have this book at my hand, it used only 130 pages (p1-p130) to cover all OCP test contents except SQL. unbelieveable.... | A very useful reference book. Keep it to hand !, 2000-06-23 Reviewer rating: This book serves it purpose very well. As the title says, it is an essential reference, and that is exactly what I use it for. As some other reviewers point out, there is a lot of copy-and-paste work in it. But I think that is not a problem. In fact, very often it is much practical than navigating the bulk of on-line books, when you have to wait for the browser to load, search for a word or topic, or even when there's no computer at hand. Not to mention I can carry it around in my bag when necessary. I especially would like to emphasize the coverage of SQL commands, init.ora parameters, data dictionary views and utilities. Although I agree there are some inconsistent topics in this book and some mistakes as well, I think the people who complain about it either expected something very different or did not understand how useful it can be. | Sometimes useful companion, 2000-04-03 Reviewer rating: I really didn't like this book in the beginning. Why? Most of the time I'm using an on-line documentation for quick reference and original Oracle documentation set for studying material larger than a few pages. In the old days (do you remember Oracle Book ? ;-) this kind of reference guide would be a rescue for any DBA. Now days?Perhaps... The organization of the book is quite good, index is excellent and some chapters are more than just reference on the subject. When I'm not working on the site where I can easily reach on-line documentation or paper manuals then this book goes with me. One drawback at the time of writing this review is that this edition doesn't cover Oracle8i so you should at least wait for the second edition. |
Some information above was provided using data from Amazon.com. View at Amazon > |
| |
|
|
