Installation, Server Configuration, and Database Upgrades           Comparison Between 10.1 and 10.2           About Grid Computing           Installation New Features Support           Performance Enhancements to the Installation Process           Simplified Instance Configuration           Managing Database Control           Viewing Database Feature Usage Statistics           Supported Upgrade Paths to Oracle 10g           Using New Utility to Perform Pre-Upgrade Validation Checks           Using the Simplified Upgrade Process           Manual Upgrade Process           Reverting Upgraded Database Loading and Unloading Data           Introduction to the Data Pump Architecture           Using Data Pump Export and Import           Monitoring a Data Pump Job           Creating External Tables for Data Population           Transporting Tablespaces Across Platforms           Transport Tablespace from Backup           Loading Data from Flat Files by Using EM           DML Error Logging Table           Asynchronous Commit Automatic Database Management           Using the Automatic Database Diagnostic Monitor (ADDM)           Using Automatic Shared Memory Management (ASMM)           Using Automatic Optimizer Statistics Collection           Database and Instance Level Trace           Using Automatic Undo Retention Tuning           Automatically Tuned Multiblock Reads Manageability Infrastructure           Types of Oracle Statistics           The Automatic Workload Repository (AWR)           Active Session History (ASH)           Server-Generated Alerts           Adaptive Thresholds           The Management Advisory Framework Application Tuning           Using the New Optimizer Statistics           Using the SQL Tuning Advisor           Using the SQL Access Advisor           Performance Pages in the Database Control           Indexing Enhancements Space and Storage Management Enhancements           Proactive Tablespace Management           Reclaiming Unused Space           Object Size Growth Analysis           Using the Undo and Redo Logfile Size Advisors           Rollback Monitoring           Tablespace Enhancements           Using Sorted Hash Clusters           Partitioned IOT Enhancements           Redefine a Partition Online           Copying Files Using the Database Server           Dropping Partitioned Table           Dropping Empty Datafiles           Renaming Temporary Files Oracle Scheduler and the Database Resource Manager           Simplifying Management Tasks Using the Scheduler           Managing the Basic Scheduler Components           Managing Advanced Scheduler Components           Database Resource Manager Enhancements Backup and Recovery Enhancements           Using the Flash Recovery Area           Using Incremental Backups           Enhancements in RMAN           Oracle Secure Backup           Cross-Platform Transportable Database           Restore Points           Placing All Files in Online Backup Mode Flashback Technology Enhancements           Using the Flashback Technology           General Flashback Technology           Flashback Database           Flashback Drop           Flashback Table           Row Level Flashback Features Automatic Storage Management           Introduction to Automatic Storage Management           ASM Instance Architecture           Managing the ASM Instance           Managing ASM Disk Groups           Managing ASM Files           Database Instance Parameter Changes           Migrating a Database to ASM           ASM and Transportable Tablespaces           ASM Command-Line Interface           FTP and HTTP Access Enhancements in Analytical SQL and Materialized Views           Enhancements in the MERGE Statement           Using Partitioned Outer Joins           Using the SQL MODEL Clause           Materialized View Enhancements Database Security           XML Audit Trail           VPD and Auditing Enhancements           Oracle Transparent Data Encryption (TDE)           Secure External Password Store           Connect Role Privilege Reduction Miscellaneous New Features           Enhancements in Managing Multitier Environments           SQL and PL/SQL Enhancements           Enhancements in SQL*Plus           Miscellaneous Enhancements Contact the Author

Globusz® Publishing New York • Berlin