Expert Oracle Database 11g Administration

  • 30h 37m
  • Sam R. Alapati
  • Apress
  • 2009

Sam Alapati’s Expert Oracle Database 11g Administration is a comprehensive handbook for Oracle database administrators (DBAs) using the latest release of the Oracle Database (Oracle Database 11g). All key aspects of database administration are covered, including backup and recovery, day–to–day administration and monitoring, performance tuning, and more. This is the one book to have on your desk as a continual reference. Refer to it frequently. It’ll help you get the job done.

  • Comprehensive handbook for Oracle DBAs. Covers all major aspects of database administration.
  • Tests and explains in detail key DBA commands.
  • Offers primers on Linux/Unix, data modeling, SQL, and PL/SQL.

What you’ll learn

  • Prepare an environment for Oracle. Configure the system. Install the software. Create a database.
  • Monitor your database environment day–to–day with confidence that you will detect and resolve problems before they become emergencies.
  • Get the most out of Oracle Database 11g by taking full advantage of its management features and cutting–edge technologies.
  • Back up your database and be able to recover it if needed.
  • Secure your database, in terms of both regulatory compliance and user management.
  • Troubleshoot and resolve connectivity, network, and performance problems.
  • And more!

Who is this book for?

Expert Oracle Database 11g Administration is written for Oracle database administrators who want a comprehensive reference to refer to during their day–to–day work. It’s clearly written in a way that is accessible to both intermediate and beginning administrators. Readers can easily and quickly find the content they need.

About the Author

SAM ALAPATI is currently an independent Oracle consultant, working at ERCOT (Electric Reliability Council of Texas). Prior to this, Sam was an Oracle DBA at the Boy Scouts of America, Sabre, Oracle Corporation, NBC, and AT&T. Sam has previously written Expert Oracle9i Database Administration and Expert Oracle Database 10g Administration, both for Apress, as well as three OCP certification books for Oracle Press. Sam has also coauthored Oracle Database 11g RMAN Recipes and Oracle Database 11g New Features for DBAs and Developers, both published by Apress. Sam has been working with relational databases since 1985, starting with the Ingres database.

In this Book

  • The Oracle DBA's World
  • Relational Database Modeling and Database Design
  • Essential UNIX (and Linux) for the Oracle DBA
  • Using SQL*Plus and Oracle Enterprise Manager
  • Oracle Database 11g Architecture
  • Managing Tablespaces
  • Schema Management
  • Oracle Transaction Management
  • Installing and Upgrading to Oracle Database 11g
  • Creating a Database
  • Connectivity and Networking
  • User Management and Database Security
  • Loading and Transforming Data
  • Using Data Pump Export and Import
  • Backing Up Databases
  • Database Recovery
  • Automatic Management and Online Capabilities
  • Managing and Monitoring the Operational Database
  • Improving Database Performance: SQL Query Optimization
  • Performance Tuning: Tuning the Instance