Expert Oracle Database 10g Administration

0.0

This is a unique, one-volume guide to the administration and management of the Oracle database. Fully revised and updated from its best-selling 9i predecessor, this edition covers all new features, with fully field-tested examples not just showcase examples. This book covers the new 10gmanagement and performance tools and provides essential primers on Unix, Linux and Windows NT administration and on core SQL and PL/SQL programming techniques. And it provides everything the new and Spring Oracle DBA needs to build and administer complex Oracle 10g databases. Table of Contents Part 1 - Background, Data Modeling and UNIX/Linux Chapter 1: The Oracle DBA's World Chapter 2: Relational Database Modeling and Database Design Chapter 3: Essential UNIX (and Linux) for the Oracle DBA Part 2 - Oracle Database 10g Architecture, Schema and Transaction Management Chapter 4: Introduction to the Oracle 10g Architecture Chapter 5: Schema Management Chapter 6: Oracle Transaction Management Part 3 - Installing Oracle Database 10g, and Creating and Upgrading Databases Chapter 7: Installing the Oracle Database 10g RDBMS Chapter 8: Upgrading to Oracle Database 10g Chapter 9: Creating an Oracle Database Part 4 - Connectivity and User Management Chapter 10: Connectivity and Networking Chapter 11: User Management and Database Security Chapter 12: Using SQL Plus and iSQL Plus Part 5 - Data Loading, Backup and Recovery Chapter 13: Loading and Transforming Data Chapter 14: Using Data Pump Export and Import Chapter 15: Backing Up Databases Chapter 16: Database Recovery Part 6 - Managing the Operational Oracle Database Chapter 17: Automatic Management and Online Capabilities Chapter 18: Managing and Monitoring the Operational Database Chapter 19: Using Oracle Enterprise Manager Chapter 20: Managing Oracle Databases on Windows and Linux Systems Part 7 - Performance Tuning Chapter 21: Improving Database Performance: SQL Query Optimization Chapter 22: Performance Tuning: Tuning the Instance Part 8 - The Data Dictionary, Dynamic Views and the Oracle-Supplied Packages Chapter 23: The Oracle Data Dictionary and the Dynamic Performance Views Chapter 24: Using Oracle PL/SQL Packages