Expert Oracle Database 11g Administration

1. Front Matter

   Pages i-liii

   PDF

2. Background, Data Modeling, UNIX/Linux, and SQL*Plus

   1. Front Matter

      Pages 1-1

      PDF

   2. The Oracle DBA’s World

      Pages 3-17

   3. Relational Database Modeling and Database Design

      Pages 19-41

   4. Essential UNIX (and Linux) for the Oracle DBA

      Pages 43-95

   5. Using SQL*Plus and Oracle Enterprise Manager

      Pages 97-161

3. Oracle Database 11g Architecture, Schema, and Transaction Management

   1. Front Matter

      Pages 163-163

      PDF

   2. Oracle Database 11g Architecture

      Pages 165-214

   3. Managing Tablespaces

      Pages 215-259

   4. Schema Management

      Pages 261-335

   5. Oracle Transaction Management

      Pages 337-388

4. Installing Oracle Database 11g, Upgrading, and Creating Databases

   1. Front Matter

      Pages 389-389

      PDF

   2. Installing and Upgrading to Oracle Database 11g

      Pages 391-442

   3. Creating a Database

      Pages 443-507

5. Connectivity and User Management

   1. Front Matter

      Pages 509-509

      PDF

   2. Connectivity and Networking

      Pages 511-542

   3. User Management and Database Security

      Pages 543-622

6. Data Loading, Backup, and Recovery

   1. Front Matter

      Pages 623-623

      PDF

   2. Loading and Transforming Data

      Pages 625-675

   3. Using Data Pump Export and Import

      Pages 677-723

Sam Alapati's Expert Oracle Database 11g Administration is a comprehensive handbook for Oracle database administrators (DBAs) using the 11g release of the Oracle Database. 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 Database administrators. 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.

• 11g
• Oracle
• SQL
• UNIX
• data model
• database
• database administration
• database design
• database modeling
• performance
• relational database

Sam R. Alapati is an experienced Oracle database administrator who holds the Oracle Certified Professional designation and the Hewlett-Packard UNIX System Administrator certification. He currently manages Oracle databases at the Boy Scouts of America's national headquarters in Los Colinas, Texas. Alapati has been dealing with databases for a long time, including the Ingres RDBMS in the mid-1980s. He is also well-versed in the Microsoft SQL Server, Sybase, and IBM DB2 database management systems.

Policies and ethics