Expert Oracle Database 11g Administration

by Alapati, Sam R.

• ISBN13: 9781430210153
• ISBN10: 143021015X
• Format: Paperback
• Copyright: 2008-11-10
• Publisher: Springer-Verlag New York Inc

Summary

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 modelling, 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.

Table of Contents

Background, Data Modeling, UNIX/Linux, and SQL*Plus
The Oracle DBA's World	p. 3
Relational Database Modeling and Database Design	p. 19
Essential UNIX (and Linux) for the Oracle DBA	p. 43
Using SQL*Plus and Oracle Enterprise Manager	p. 97
Oracle Database 11g Architecture, Schema, and Transaction Management
Oracle Database 11g Architecture	p. 165
Managing Tablespaces	p. 215
Schema Management	p. 261
Oracle Transaction Management	p. 337
Installing Oracle Database 11g, Upgrading, and Creating Databases
Installing and Upgrading to Oracle Database 11g	p. 391
Creating a Database	p. 443
Connectivity and User Management
Connectivity and Networking	p. 511
User Management and Database Security	p. 543
Data Loading, Backup, and Recovery
Loading and Transforming Data	p. 625
Using Data Pump Export and Import	p. 677
Backing Up Databases	p. 725
Database Recovery	p. 801
Managing the Database
Automatic Management and Online Capabilities	p. 877
Managing and Monitoring the Operational Database	p. 947
Performance Tuning
Improving Database Performance: SQL Query Optimization	p. 1041
Performance Tuning: Tuning the Instance	p. 1129
Oracle Database 11g SQL and PL/SQL: A Brief Primer	p. 1221
Index	p. 1255
Table of Contents provided by Blackwell. All Rights Reserved.