Oracle Database 10g DBA Handbook

Have a Promotion Code?

Please enter it here:

Great deals and more!

Sign up for special offers, exclusive discounts, and new product announcements from McGraw-Hill Professional.



April 14, 2005


Mixed media product, 736 pages

Other Formats


0072231459 / 9780072231458


Your Price



Main description

Everything a DBA needs to know in one volume--this is the must-have reference for anyone working with the Oracle database, and it's been fully revised and updated for Oracle Database 10g. Co-author Kevin Loney is the all-time, best-selling Oracle Press author.

Table of contents

PART I Database Architecture 1 Getting Started with the Oracle Architecture 2 Upgrading to 10g 3 Planning and Managing Tablespaces 4 Physical Database Layouts PART II Database Management 5 Real Application Clusters 6 Managing the Development Process 7 Monitoring Space Usage 8 Managing Transactions 9 Database Tuning 10 Using STATSPACK 11 Database Security and Auditing 12 Backup and Recovery Options 13 Using Recovery Manager (RMAN) 14 High Availability PART III Networked Oracle 5 Oracle Net 16 Managing Large Databases 17 Managing Distributed Databases

Author comments

Kevin Loney (Wilmington, DE) is a consultant for TUSC and a veteran Oracle developer and DBA. He is among the most renowned members of the Oracle Professional community and is a regular presenter at IOUG-A, Oracle OpenWorld, and regional User Group conferences. Kevin is the coauthor of several of our best-selling titles such as The Complete Reference and the DBA Handbook. Bob Bryla (Plattville, WI) has over 20 years of experience in MIS, ranging from database and data warehouse design to system administration on multiple hardware platforms. Bob is currently lead designer and data analyst for Lands' End's online store database and handles the DBA activities on Lands' End Oracle Internet databases. Bob has also technically reviewed and authored or coauthored several well-reviewed Oracle certification titles for Sybex.

Back cover copy

The Essential Resource for All Oracle Database Administrators

Maintain a high-performance Oracle enterprise database with help from this exclusive Oracle Press guide. Oracle Database 10g DBA Handbook explains how to install Oracle Database 10g, or upgrade from an earlier version, and take full advantage of all the new and improved management, scalability, availability, and security features. Written by Oracle experts, the book covers Automatic Undo Management, Oracle Real Application Clusters, Oracle Recovery Manager, Oracle Data Guard, and much more.

  • Plan tablespaces--including bigfiles and multiple temporary tablespaces--and physical database layout
  • Manage disk space and CPU usage
  • Use Automatic Undo Management to manage transactions
  • Tune queries using the SQL Access Advisor
  • Monitor and tune your database with the Automated Workload Repository and STATSPACK
  • Implement fine-grained security using authentication, authorization, and auditing techniques
  • Automate the management of the memory areas
  • Enable high availability using Oracle Real Application Clusters
  • Perform backup and recovery with Oracle Recovery Manager
  • Use Oracle Data Guard and the flashback features for data protection and disaster recovery
  • Manage Very Large Databases (VLDB) and distributed databases

About the Authors: Kevin Loney is a senior technical management consultant with TUSC, a Chicago-based consultancy providing Oracle solutions. He has been an Oracle developer and DBA since 1987, and has written for Oracle Magazine and Oracle Press since 1990. In 2002, he was named Oracle Magazine's Editors' Choice as Consultant of the Year. He is a frequent and highly rated speaker at local and international Oracle user groups. Bob Bryla is an Oracle 8, 8i, 9 and 10g Certified Professional with more than 15 years of experience in database design, database application development, training, and Oracle database administration. He is the primary Internet database designer and an Oracle DBA at Lands' End in Dodgeville, Wisconsin.

Copyright 2014 McGraw-Hill Global Education Holdings, LLC


Before you can enjoy free downloads from McGraw-Hill Professional, we ask that you please provide your email address and country.

Yes, I want to receive other special offer.