Expert Oracle Database 10g Administration / Edition 1
by Sam Alapati
This is a unique, one-volume guide to the administration and management of the Oracle database. Fully revised and updated from its best-selling 9i predecessor, this edition covers all new features, with fully field-tested examplesnot just "showcase" examples.
This book covers the new 10g management and performance tools and provides essential
… See more details belowOverview
This is a unique, one-volume guide to the administration and management of the Oracle database. Fully revised and updated from its best-selling 9i predecessor, this edition covers all new features, with fully field-tested examplesnot just "showcase" examples.
This book covers the new 10g management and performance tools and provides essential primers on Unix, Linux and Windows NT administration and on core SQL and PL/SQL programming techniques. And it provides everything the new and aspring Oracle database administrator needs to build and administer complex Oracle 10g databases.
Product Details
- ISBN-13:
- 9781590594513
- Publisher:
- Apress
- Publication date:
- 09/15/2005
- Series:
- Expert's Voice Series
- Pages:
- 1304
- Product dimensions:
- 7.00(w) x 9.25(h) x 1.81(d)
Table of Contents
| Pt. 1 | Background, data modeling, and UNIX/Linux | |
| Ch. 1 | The Oracle DBA's world | 3 |
| Ch. 2 | Relational database modeling and database design | 19 |
| Ch. 3 | Essential UNIX (and Linux) for the Oracle DBA | 43 |
| Pt. 2 | Oracle Database 10g architecture, schema, and transaction management | |
| Ch. 4 | Introduction to the Oracle Database 10g architecture | 99 |
| Ch. 5 | Schema management | 145 |
| Ch. 6 | Oracle transaction management | 225 |
| Pt. 3 | Installing Oracle Database 10g, and creating and upgrading databases | |
| Ch. 7 | Installing the Oracle Database 10g RDBMS | 279 |
| Ch. 8 | Upgrading to Oracle Database 10g | 315 |
| Ch. 9 | Creating an Oracle Database | 329 |
| Pt. 4 | Connectivity and user management | |
| Ch. 10 | Connectivity and networking | 391 |
| Ch. 11 | User management and database security | 421 |
| Ch. 12 | Using SQL plus and iSQL plus | 491 |
| Pt. 5 | Data loading, backup, and recovery | |
| Ch. 13 | Loading and transforming data | 539 |
| Ch. 14 | Using data pump export and import | 589 |
| Ch. 15 | Backing up databases | 631 |
| Ch. 16 | Database recovery | 699 |
| Pt. 6 | Managing the operational Oracle Database | |
| Ch. 17 | Automatic management and online capabilities | 759 |
| Ch. 18 | Managing and monitoring the operational database | 823 |
| Ch. 19 | Using Oracle enterprise manager | 883 |
| Ch. 20 | Managing Oracle Databases on Windows and Linux systems | 909 |
| Pt. 7 | Performance tuning | |
| Ch. 21 | Improving database performance : SQL query optimization | 937 |
| Ch. 22 | Performance tuning : tuning the instance | 1001 |
| Pt. 8 | The data dictionary, dynamic views, and the Oracle-supplied packages | |
| Ch. 23 | The Oracle data dictionary and the dynamic performance views | 1083 |
| Ch. 24 | Using Oracle PL/SQL packages | 1145 |
| App. A | Oracle Database 10g SQL and PL/SQL : a brief primer | 1183 |
Customer Reviews
Average Review: