Expert Oracle Database 11g Administration / Edition 1
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, daytoday administration and monitoring, performance tuning, and/em>/strong>
… See more details belowOverview
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, daytoday 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 daytoday 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 cuttingedge 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 daytoday 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.
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
Customer Reviews
Average Review: