Expert Oracle database 10g administration /
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Berkeley, CA : New York :
Apress ; Distributed to the book trade worldwide by Springer-Verlag,
c2005 [reprinted 2010].
|
| Subjects: | |
| Classic Catalogue: | View this record in Classic Catalogue |
Table of Contents:
- 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.