Expert Oracle Database 10g Administration

A unique, one-volume guide to the administration amd mangement of the Oracle database. Fully revised and updated for Oracle 10g, this book covers all of 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. In short, it provides everything that the new and aspring Oracle DBA needs in order to build and admisiter complex Oracle 10g databases. TOC:Chapter 1. The Oracle DBA, the Grid and the Oracle Database 10g Chapter 2. Relational Database Modeling and database designChapter 3. Essential UNIX (and LINUX) for the Oracle DBA Chapter 4. Installing the Oracle10g RDBMS Chapter 5. Introduction to the Oracle10g ArchitectureChapter 6. Using SQL*Plus and iSQL*PlusChapter 7. Schema Management Oracle10gChapter 8. Oracle Transaction ManagementChapter 9. Creating and Upgrading DatabasesChapter 10. Connectivity and NetworkingChapter 11. User Management and Database SecurityChapter 12. Loading and Transforming of Data.Chapter 13. Using the Data Pump Export and Datapump Import UtilitiesChapter 14. Backing up DatabasesChapter 15. Database Recovery Chapter 16. Self Management features of the Oracle 10g databaseChapter 17. Using the Oracle10g Enterprise ManagerChapter 18. Improving database Performance - SQL Query OptimizationChapter 19. Performance Tuning - Tuning the InstanceChapter 20. The Oracle Data Dictionary and the Dynamic Performance TablesChapter 21. Using Oracle PL/SQL PackagesChapter 22. Managing Oracle10g Databases on Windows and LINUX Systems Appendix A Oracle 10g SQL and PL/SQL Primer