Expert Oracle Database 11g Administration / Edition 1

Expert Oracle Database 11g Administration / Edition 1

4.0 3
by Sam Alapati
     
 

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

See more details below

Overview

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.

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.

Who this book is 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.

Read More

Product Details

ISBN-13:
9781430210153
Publisher:
Apress
Publication date:
11/14/2008
Series:
The Expert's Voice in Oracle Series
Edition description:
2009
Pages:
1400
Product dimensions:
7.00(w) x 9.10(h) x 2.30(d)

Table of Contents

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

Ch. 1 The Oracle DBA's World 3

Ch. 2 Relational Database Modeling and Database Design 19

Ch. 3 Essential UNIX (and Linux) for the Oracle DBA 43

Ch. 4 Using SQL*Plus and Oracle Enterprise Manager 97

Pt. 2 Oracle Database 11g Architecture, Schema, and Transaction Management

Ch. 5 Oracle Database 11g Architecture 165

Ch. 6 Managing Tablespaces 215

Ch. 7 Schema Management 261

Ch. 8 Oracle Transaction Management 337

Pt. 3 Installing Oracle Database 11g, Upgrading, and Creating Databases

Ch. 9 Installing and Upgrading to Oracle Database 11g 391

Ch. 10 Creating a Database 443

Pt. 4 Connectivity and User Management

Ch. 11 Connectivity and Networking 511

Ch. 12 User Management and Database Security 543

Pt. 5 Data Loading, Backup, and Recovery

Ch. 13 Loading and Transforming Data 625

Ch. 14 Using Data Pump Export and Import 677

Ch. 15 Backing Up Databases 725

Ch. 16 Database Recovery 801

Pt. 6 Managing the Database

Ch. 17 Automatic Management and Online Capabilities 877

Ch. 18 Managing and Monitoring the Operational Database 947

Pt. 7 Performance Tuning

Ch. 19 Improving Database Performance: SQL Query Optimization 1041

Ch. 20 Performance Tuning: Tuning the Instance 1129

Appendix Oracle Database 11g SQL and PL/SQL: A Brief Primer 1221

Index 1255

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >