: Apress ; New York : Distributed to the book trade worldwide by Springer-Verlag,
, c2005.
xxvii, 1276 p. ill. 24 cm.
e
Includes index.
ng
Pt. 1. Background, data modeling, and UNIX/Linux. The Oracle DBA's world -- Relational database modeling and database design -- Essential UNIX (and Linux) for the Oracle DBA -- Pt. 2. Oracle database 10g architecture, schema, and transaction management. Introduction to the Oracle database 10g architecture -- Schema management -- Oracle transaction management -- Pt. 3. Installing Oracle database 10g, and creating and upgrading databases. Installing the Oracle database 10g RDBMS -- Upgrading to Oracle database 10g -- Creating an Oracle database -- Pt. 4. Connectivity and user management. Connectivity and networking -- User management and database security -- Using SQL *Plus and iSQL *Plus -- 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 operational Oracle database. Automatic management and online capabilities -- Managing and monitoring the operational database -- Using Oracle enterprise manager -- Managing Oracle databases on Windows and Linux systems -- Pt. 7. Performance tuning. Improving database performance : SQL query optimization -- Performance tuning : tuning the instance -- Pt. 8. The data dictionary, dynamic views, and the Oracle-supplied packages. The Oracle data dictionary and the dynamic performance views -- Using Oracle PL/SQL packages -- Appendix A. Oracle database 10g SQL and PL/SQL: a brief primer.