Expert Oracle Database 11g Administration

✍ Scribed by Sam R. Alapati (auth.)

• Publisher: Apress
• Year: 2009
• Tongue: English
• Leaves: 1375
• Edition: 1
• Category: Library

✦ Synopsis

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.

✦ Table of Contents

Front Matter....Pages i-liii
Front Matter....Pages 1-1
The Oracle DBA’s World....Pages 3-17
Relational Database Modeling and Database Design....Pages 19-41
Essential UNIX (and Linux) for the Oracle DBA....Pages 43-95
Using SQL*Plus and Oracle Enterprise Manager....Pages 97-161
Front Matter....Pages 163-163
Oracle Database 11 g Architecture....Pages 165-214
Managing Tablespaces....Pages 215-259
Schema Management....Pages 261-335
Oracle Transaction Management....Pages 337-388
Front Matter....Pages 389-389
Installing and Upgrading to Oracle Database 11 g ....Pages 391-442
Creating a Database....Pages 443-507
Front Matter....Pages 509-509
Connectivity and Networking....Pages 511-542
User Management and Database Security....Pages 543-622
Front Matter....Pages 623-623
Loading and Transforming Data....Pages 625-675
Using Data Pump Export and Import....Pages 677-723
Backing Up Databases....Pages 725-800
Database Recovery....Pages 801-874
Front Matter....Pages 875-875
Automatic Management and Online Capabilities....Pages 877-945
Managing and Monitoring the Operational Database....Pages 947-1038
Front Matter....Pages 1039-1039
Improving Database Performance: SQL Query Optimization....Pages 1041-1127
Performance Tuning: Tuning the Instance....Pages 1129-1220
Back Matter....Pages 1221-1344

✦ Subjects

Data Structures, Cryptology and Information Theory