Oracle9i DBA Handbook [Paperback]

Kevin Loney (Author), Marlene Theriault (Author)

Book Description

ISBN-10: 0072193743 | ISBN-13: 978-0072193749 | Publication Date: November 28, 2001 | Edition: 1

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.

Editorial Reviews

From the Back Cover

Implement Expert Administrative Solutions

Keep your mission-critical Internet and e-business systems flexible, secure, and available by using the exclusive information contained in this Oracle-authorized volume. Oracle9i DBA Handbook explains how to set up and maintain a high-performance database and maximize the all-new, powerful features of Oracle9i. Oracle insiders Kevin Loney and Marlene Theriault cover all the bases and provide real-world examples and techniques. A must-have resource for Oracle DBAs.

• Create and manage databases, using the Oracle9i Database Configuration Assistant
• Monitor and tune file usage, transactions, queries, and memory
• Implement rollback segments and system-managed undo
• Handle application migration and online table evolution
• Diagnose and optimize system performance with STATSPACK
• Implement state-of-the-art auditing and security procedures
• Automate backup and recovery operations, using RMAN
• Implement partitions to manage VLDBs
• Distribute computing power and share data across servers, using Oracle Net
• Use Oracle9iAS services to improve flexibility, scalability, and availability

About the Author

Kevin Loney (Wilmington, DE) is a veteran Oracle developer and DBA. He is the author of the best-selling Oracle8 DBA Handbook and co-author of Advanced Tuning and Administration and Oracle8i: The Complete Reference. He frequently makes presentations at Oracle conferences and contributes to Oracle Magazine.

Marlene Theriault has been an Oracle DBA for over 17 ears and has worked with Oracle products since version 2.0 of the Oracle RDBMS. She has been published in magazines and conference proceedings throughout the world. Ms. Theriault received the "Best User Presentation" award at EOUG 1999, "Outstanding Speaker" at EDO'98, and the "Distinguished Speaker" award for presentations at both ECO'95 and ECO'96. She coauthored Oracle Security with William Heney (O'Reilly and Associates, 1998); The Oracle8i DBA Handbook with Kevin Loney (Oracle Press, 2000); and Oracle DBA 101 with Rachel Carmichael and James Viscusi (Oracle Press, 2000). She is chair of the MAOP DBA SIG and authors an "Ask The DBA" column for the MAOP newsletter. Ms. Theriault is an avid recreational walker (Volksmarching) and has done at least one 6-mile walk in each of the 50 United States. Marlene can be reached at [e-mail].

Product Details

• Paperback: 1008 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (November 28, 2001)
• Language: English
• ISBN-10: 0072193743
• ISBN-13: 978-0072193749
• Product Dimensions: 9.1 x 7.3 x 2 inches
• Shipping Weight: 3.6 pounds (View shipping rates and policies)
• Average Customer Review: 3.2 out of 5 stars  See all reviews (12 customer reviews)
• Amazon Best Sellers Rank: #1,328,163 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

26 of 34 people found the following review helpful:

1.0 out of 5 stars This is not fair, Oracle 8 stuff in an 9i book cover!, April 16, 2002

By 

Manfred Fischer - See all my reviews
(REAL NAME)   

This review is from: Oracle9i DBA Handbook (Paperback)

Mrs. Theriault, Mr. Loney, the Oracle guys developed a milestone 9i with a lot of new important database features. In your book I can find features of Oracle 8 and 8i. That is not fair. I'm a lucky man, because my company has bought the book! As an Oracle teacher I must order all the new books, but this book I cant't recommend to people who actually have an idea about Oracle 8!

5 of 5 people found the following review helpful:

4.0 out of 5 stars Don't understand all the negative reviews, July 29, 2005

By 

S. T. Peterson (NOVA) - See all my reviews
(REAL NAME)   

This review is from: Oracle9i DBA Handbook (Paperback)

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.

6 of 7 people found the following review helpful:

5.0 out of 5 stars Great coverage of 9i features, August 2, 2002

By A Customer

This review is from: Oracle9i DBA Handbook (Paperback)

I'm a beginner DBA, and this book had what I needed to get started. It has great coverage of 9i features. I used the scripts to create the database, set it up, and then tune it. I recommend DBAs also pick up a book on their operating system shell so you can program your management scripts.