โ Scribed by Sam R. Alapati (auth.)
No coin nor oath required. For personal study only.
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 SQLPlus and i SQLPlus....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
Software Engineering/Programming and Operating Systems
๐ SIMILAR VOLUMES
An excellent book covering all essential DBA topics for Oracle 9i Administration. Explained very well covering In-depth details, Illustrations and examples makes this book invaluable. I use it as a true source of reference and I will strongly recommend this book.
This is the only real Oracle 9i Database Administration book on the market! This 1,000 page book enables a beginner or intermediate level Oracle DBA of Oracle Developer/Manager to master the art of building and managing complex Oracle 9i databases. Expert Oracle9i Database Administration is thorough
<p>This is the only real Oracle9 i 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 Oracle9 i databases. Expert Oracle9 i Database Administration i
Readers of this guide are assumed to be familiar with relational database concepts. They are also assumed to be familiar with the operating system environment under which they are running Oracle.Administrators frequently participate in installing the Oracle server software and migrating existing Ora
This guide is your primary source of introductory, postinstallation, configuration, and administration information for using Oracle9i Enterprise Edition, Oracle9i Standard Edition, or Oracle9i Personal Edition. Differences between the three versions are noted where appropriate.This guide is necessar