Oracle Database 11g: руководство администратора баз данных: [всеобъемлющее пособие по Oracle Database 11g, описывающее все инструменты и технологии для построения баз данных Oracle и эффективного управления ими]

Книга «Oracle Database 11g. Руководство администратора баз данных» - энциклопедический справочник по СУБД Oracle 11g, описывающий все инструменты и технологии для построения и эффективного управления базами данных Oracle. Эта книга является результатом глубокого убеждения автора в том, что нынешние администраторы баз данных нуждаются в едином справочнике, который бы покрывал весь спектр существующих задач - от проектирования базы данных до ежедневного управления ею и выполнения критически важных работ, таких как настройка производительности, резервное копирование и восстановление. В книге рассматривается архитектура Oracle. Вдобавок в книге предложены примеры по программированию на Oracle SQL и PL/SQL в средах Linux/Unix, ориентированные на новичков. Книга содержит все, что необходимо администраторам баз данных Oracle (вне зависимости от их опыта) для успешного построения и управления сложными базами данных Oracle Database 11g.

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.

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.