Expert Oracle database 11g administration: Expert Oracle database 11g administration

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

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.

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 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. - And more! Who is this book 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. pt. 1. 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 pt. 2. Oracle database 11g architecture, schema, and transaction management. Oracle database 11g architecture Managing tablespaces Schema management Oracle transaction management pt. 3. Installing Oracle database 11g, upgrading, and creating and databases Installing and upgrading to Oracle database 11g Creating a database pt. 4. Connectivity and user management. Connectivity and networking User management and database security pt. 5. Data loading, backup, and recovery. Loading and transforming data Using data pump export and import Backing up databases Database recovery pt. 6. Managing the database. Automatic management and online capabilities Managing and monitoring the operational database pt. 7. Performance tuning. Improving database performance : SQL query optimization Performance tuning : tuning the instance Appendix A. Oracle database 11g SQL and PL/SQL: a brief primer. 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. 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 A comprehensive handbook for Oracle database administrators using the latest release of the Oracle Database, this guide covers all aspects of database administration including backup and recovery, day-to-day administration and monitoring, performance tuning, and more.