Expert Oracle Database 10g Administration

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’être 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.

GRATIANO . . . As who should say "e;I am Sir Oracle, And when I ope my lips, let no dog bark!"e; -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.

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.- Oracle Database 10g Architecture, Schema, and Transaction Management.- to the Oracle Database 10g Architecture.- Schema Management.- Oracle Transaction Management.- Installing Oracle Database 10g, and Creating and Upgrading Databases.- Installing the Oracle Database 10g RDBMS.- Upgrading to Oracle Database 10g.- Creating an Oracle Database.- Connectivity and User Management.- Connectivity and Networking.- User Management and Database Security.- Using SQL*Plus and iSQL*Plus.- Data Loading, Backup, and Recovery.- Loading and Transforming Data.- Using Data Pump Export and Import.- Backing Up Databases.- Database Recovery.- 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.- Performance Tuning.- Improving Database Performance: SQL Query Optimization.- Performance Tuning: Tuning the Instance.- The Data Dictionary, Dynamic Views, and the Oracle-Supplied Packages.- The Oracle Data Dictionary and the Dynamic Performance Views.- Using Oracle PL/SQL Packages.