: Apress ; New York : Distributed to the book trade worldwide by Springer-Verlag,
Date of Publication, Distribution, etc.
, c2005.
PHYSICAL DESCRIPTION
Specific Material Designation and Extent of Item
xxvii, 1276 p. ill. 24 cm.
NOTES PERTAINING TO PUBLICATION, DISTRIBUTION, ETC.
Text of Note
e
INTERNAL BIBLIOGRAPHIES/INDEXES NOTE
Text of Note
Includes index.
Text of Note
ng
CONTENTS NOTE
Text of Note
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.