Synopses & Reviews
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.
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 DBA needs to build and admisiter complex Oracle 10g databases.
GRATIANO . . . As who should say I am Sir Oracle, And when I ope my lips, let no dog bark The Merchant of Venice, act 1, scene 1 Oracle Corporation used to print the preceding quotation from Shakespeare at the beginning of one of its chapters in the Oracle database administrator (DBA) manual (Oracle 6). I always thought the quote was interesting. If you proceed a little further in the play, you ll find this quotation: BASSANIO Gratiano speaks an infinite deal of nothing, more than any man in all Venice. His reasons are as two grains of wheat hid in two bushels of chaff: you shall seek all day ere you find them . . . The Merchant of Venice, act 1, scene 1 Bassanio counters that, in truth, Gratiano speaks too much: from two bushels of chaff, two grains of wheat may be recovered. And that s the raison d etre for this book: to separate the wheat from the chaff. This second part of the quotation is more apt when you consider the difficulty of extracting the right database management procedures from the tons of material available for the Oracle Database 10g database. Oracle Corporation publishes copious material to help you manage its increasingly complex databases. Oracle Corporation also conducts a variety of in-person and Web-based classes to explain the vast amount of subject matter that you need to understand to effectively work with the Oracle database today."
Table of Contents
Chapter 1. The Oracle DBA, the Grid and the Oracle Database 10g
Chapter 2. Relational Database Modeling and database design
Chapter 3. Essential UNIX (and LINUX) for the Oracle DBA
Chapter 4. Installing the Oracle10g RDBMS
Chapter 5. Introduction to the Oracle10g Architecture
Chapter 6. Using SQL*Plus and iSQL*Plus
Chapter 7. Schema Management Oracle10g
Chapter 8. Oracle Transaction Management
Chapter 9. Creating and Upgrading Databases
Chapter 10. Connectivity and Networking
Chapter 11. User Management and Database Security
Chapter 12. Loading and Transforming of Data.
Chapter 13. Using the Data Pump Export and Datapump Import Utilities
Chapter 14. Backing up Databases
Chapter 15. Database Recovery
Chapter 16. Self Management features of the Oracle 10g database
Chapter 17. Using the Oracle10g Enterprise Manager
Chapter 18. Improving database Performance - SQL Query Optimization
Chapter 19. Performance Tuning - Tuning the Instance
Chapter 20. The Oracle Data Dictionary and the Dynamic Performance Tables
Chapter 21. Using Oracle PL/SQL Packages
Chapter 22. Managing Oracle10g Databases on Windows and LINUX Systems
Appendix A Oracle 10g SQL and PL/SQL Primer