• RRP: £43.99
  • You Save: £38.35 (87%)
FREE Delivery in the UK on orders over £10.
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon.
Gift-wrap available.
Oracle9i DBA Handbook (Or... has been added to your Basket
+ £2.80 UK delivery
Used: Good | Details
Condition: Used: Good
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Oracle9i DBA Handbook (Oracle Press) Paperback – 1 Dec 2001

See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
"Please retry"
£5.64 £0.01
£5.64 FREE Delivery in the UK on orders over £10. Only 1 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.

Product details

  • Paperback: 1008 pages
  • Publisher: McGraw-Hill Osborne (1 Dec. 2001)
  • Language: English
  • ISBN-10: 0072193743
  • ISBN-13: 978-0072193749
  • Product Dimensions: 18.5 x 5.1 x 23.1 cm
  • Average Customer Review: 3.5 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 2,435,479 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

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 mtheriault@mindspring.com.

Inside This Book (Learn More)
Explore More
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

3.5 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See both customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

47 of 47 people found the following review helpful By andrew_kirstein@usa.net on 31 Jan. 2002
Format: Paperback
I've been a big fan of Kevin Loney's DBA handbooks ever since the Gold covered Oracle 7 version was released 1995. The latest incarnation appears to be a rework of the last two books (7/8i), but there are some surprising ommissions when it comes to 9i.
The absence of any discussion on the server parameter file (spfile) and its ability to dynamically reconfigure instances on the fly is disappointing. So too is the 1 page discussion on Real Application Clusters (the OPS replacement). Undo tablespaces fare little better with three pages - considering they are a replacement to what the author described as "Oracle's Problem Children" in his earlier work - I'm surprised there isn't more discussion on the difference between rollback segments and their 9i successors. I also felt that nearly 300 pages at the back of the book dedicated to SQL command syntax should probably be another book on its own. Its useful, but not just for DBAs.
The early chapters are a good as ever though, DB design, OFA layouts and performance considerations are discussed using a "common sense" approach. The inclusion of chapters on STATSPACK, RMAN and tuning 9iAS are great. If and when the next DBA Handbook is released, I'd like to see the SQL Command Reference dropped (into its own publication) and a little more on the features of the 9i server included. The book is essentially a rework of the previous version with some of the 9i features included.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
By adrian on 29 April 2009
Format: Paperback
was looking for this book as a replacement text and was very satisfied with the contentsz
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 12 reviews
26 of 34 people found the following review helpful
This is not fair, Oracle 8 stuff in an 9i book cover! 16 April 2002
By Manfred Fischer - Published on Amazon.com
Format: 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
Don't understand all the negative reviews 29 July 2005
By S. T. Peterson - Published on Amazon.com
Format: 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
Great coverage of 9i features 2 Aug. 2002
By A Customer - Published on Amazon.com
Format: 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.
4 of 5 people found the following review helpful
Another Fine Tome 10 Dec. 2001
By CanonCat - Published on Amazon.com
Format: Paperback Verified Purchase
Kevin Loney continues to be a major force in documenting the onslaught of new database features from Oracle and this volume is no different.
Don't expect a CD-ROM to be included with this however - mine arrived without one and there is no indication that there ever was one planned. The Oracle Press web site does not mention one. This actually turned out to be a listing error by Amazon and has been corrected. If you like performance tuning, consider Donald Burleson's excellent guide to using and extending the Oracle Statspack utility.
19 of 27 people found the following review helpful
This in NOT an Oracle9i new features book! 14 Jan. 2002
By A Customer - Published on Amazon.com
Format: Paperback
You should only consider buying this book if you do not have a good Oracle8i book already or if you are willing to read it completely. There are only a few references to Oracle9i and you have to search them in the index (which means that you have to know the new features BEFORE even reading the book!). It looks like time-to-market has played a key role in the conception of this book.
The one star is for being a pretty good book for Oracle newbies.
Were these reviews helpful? Let us know