Expert Oracle Database 11g Administration

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.

Background, Data Modeling, UNIX/Linux, and SQL*Plus.- 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, Schema, and Transaction Management.- Oracle Database 11g Architecture.- Managing Tablespaces.- Schema Management.- Oracle Transaction Management.- Installing Oracle Database 11g, Upgrading, and Creating Databases.- Installing and Upgrading to Oracle Database 11g.- Creating a Database.- Connectivity and User Management.- Connectivity and Networking.- User Management and Database Security.- Data Loading, Backup, and Recovery.- Loading and Transforming Data.- Using Data Pump Export and Import.- Backing Up Databases.- Database Recovery.- Managing the Database.- Automatic Management and Online Capabilities.- Managing and Monitoring the Operational Database.- Performance Tuning.- Improving Database Performance: SQL Query Optimization.- Performance Tuning: Tuning the Instance.

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.