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

The goal of this book is to provide you with a single source for most of your day-to-day Oracle database management tasks. Of course, it isn’t feasible to cover each and every DBA topic in detail. What I’ve done in this book is focus on the topics that are common to most enterprises, such as installing the Oracle Database 11g software, creating and upgrading databases, exporting and importing data, backing up and recovering data, and performance tuning. I place a lot of emphasis in this book on explaining all of Oracle’s automatic management solutions. Using Oracle’s automatic management features will keep you from reinventing the wheel each time. It also turns out that after several years of development, Oracle has finally placed in your hands a set of powerful management advisors and other tools that make a lot of traditional DBA work obsolete.

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.