Expert Oracle9i Database Administration

Description

This is the only real Oracle9i database administration book in the market! This 1,000+ page book enables a beginner or intermediate level Oracle DBA or Oracle developer/manager to master the art of building and managing complex Oracle9i databases. Expert Oracle9i Database Administration is thorough in covering all aspects of the 9i database, and includes a UNIX primer as well as an introduction to SQL and PL/SQL. Author Sam Alapati covers the entire spectrum of the new Oracle9i RDBMS software and clearly explains how to use all of its powerful features. Currently there is no one book that includes the necessary UNIX administration, Windows NT management, and SQL backgrounds and the necessary database administration principles. This book fills that gap well, by providing all the necessary material in one comprehensive volume. It takes several courses as well as mastery of several Oracle manuals to become a proficient database administrator. Readers will be able to become expert Oracle Database administrators by using this book. Expert Oracle9i Database Administration is designed to be the most complete Oracle9i database text available. Front Matter....Pages i-xlii Front Matter....Pages 1-1 The Oracle DBA’s World....Pages 3-23 Relational Database Modeling and Database Design....Pages 25-53 Essential UNIX (and Linux) for the Oracle DBA....Pages 55-104 Front Matter....Pages 105-105 Installing the Oracle9 i RDBMS....Pages 107-137 Introduction to the Oracle9 i Architecture....Pages 139-196 Using SQL*Plus and i SQL*Plus....Pages 197-236 Schema Management in Oracle9 i ....Pages 237-307 Oracle Transaction Management....Pages 309-360 Front Matter....Pages 361-361 Creating an Oracle Database....Pages 363-424 Connectivity and Networking....Pages 425-468 User Management and Database Security....Pages 469-529 Front Matter....Pages 531-531 Loading and Transforming Data....Pages 533-577 Using the Export and Import Utilities....Pages 579-610 Backing Up Databases....Pages 611-671 Database Recovery....Pages 673-719 Front Matter....Pages 721-721 Managing the Operational Database....Pages 723-770 Using Oracle9 i Enterprise Manager....Pages 771-818 Front Matter....Pages 819-819 Improving Database Performance: SQL Query Optimization....Pages 821-886 Performance Tuning: Tuning the Instance....Pages 887-972 The Oracle Data Dictionary and the Dynamic Performance Views....Pages 973-1027 Front Matter....Pages 819-819 Using Oracle PL/SQL Packages....Pages 1029-1076 Managing Oracle Databases on Windows and Linux Systems....Pages 1077-1103 Back Matter....Pages 1105-1204