| | Copyright |
| | Preface |
| | About the Authors |
| | Acknowledgments |
| | We Want to Hear from You! |
| | Introduction |
| | | Who Should Read This Book |
| | | What You Need to Use This Book |
| | | How This Book Is Organized |
| | | About the Book's Sample Code |
| | | Conventions Used in This Book |
| | Part I. Getting Started with Oracle Database 10g |
| | | Chapter 1. Exploring Oracle Database 10g Architecture |
| | | Overview of New Features |
| | | Processes Beneath the Hood |
| | | Memory Architecture |
| | | Automatic Undo Management |
| | | SQL Advisors |
| | | Oracle's Suite of Other Advisors |
| | | Flash Recovery Area |
| | | Flashback Operations |
| | | Improved Oracle Enterprise Manager |
| | | Grid Technology Unveiled |
| | | Summary |
| | | Chapter 2. Installing Oracle Database 10g |
| | | Installation Decisions |
| | | Prerequisites |
| | | Installing 10g on UNIX/Linux |
| | | Oracle Database 10g DBCA Overview |
| | | Installing 10g on Windows |
| | | Companion CD Installation and Patches (All Platforms) |
| | | Installation Checklists |
| | | Database and Binary Cloning |
| | | Using Enterprise Manager for Cloning |
| | | Migrating a Database from 8i or 9i |
| | | Overview of Database Upgrade Assistant |
| | | Applying Patches to Database Installations |
| | | Uninstalling from a Failed Install |
| | | Summary |
| | | Chapter 3. Customizing Installation Options |
| | | OEM and Automatic Alerts |
| | | XML DB for XML Data Processing |
| | | ConText and Other Options |
| | | Setting Up RAC |
| | | Managing Backups with RMAN |
| | | Summary |
| | | Chapter 4. Setting Up Automatic Storage Management |
| | | Automatic Storage Management (ASM) |
| | | Prerequisites for Using ASM |
| | | Configuration Options |
| | | Performing ASM Operations |
| | | Avoiding ASM Pitfalls |
| | | When and Where to Use ASM |
| | | Summary |
| | Part II. Quick Wins Using Oracle Database 10g |
| | | Chapter 5. Using Automatic Memory Management |
| | | Introduction to Quick Wins |
| | | What Is Automatic Shared Memory Management? |
| | | Understanding Memory Advisor |
| | | Automated Maintenance Tasks |
| | | Memory Management Tips |
| | | Scaling for Database Expansion |
| | | ASMM Improvements in 10g Release 2 |
| | | Summary |
| | | Chapter 6. Monitoring with Automatic Statistics Collection |
| | | Automatic Statistics Collection Fundamentals |
| | | Collecting and Analyzing Statistics |
| | | Metrics Monitoring and Customization |
| | | Using Database Alerts with Metrics |
| | | Making the Most of Metrics and Statistics Collection |
| | | New Features in Oracle Database 10g Release 2 |
| | | Summary |
| | | Chapter 7. Managing Automatic Undo |
| | | Using Automatic Undo Management |
| | | Redo Log File Sizings |
| | | Using Undo Advisor |
| | | Guaranteeing Undo Availability |
| | | Undo Tips from the Trenches |
| | | Automatic Undo Management Improvements in Release 2 |
| | | Summary |
| | | Chapter 8. Leveraging Automatic Segment Management |
| | | Segment Management in Oracle Database 10g |
| | | Making Segment Management Work for You |
| | | Using Segment Advisor |
| | | Intelligent Segment Resource Estimation |
| | | Space-Management Tips and Tricks |
| | | ASSM Improvements in Release 2 |
| | | Summary |
| | | Chapter 9. Implementing Recovery Manager |
| | | RMAN Basics |
| | | New Features of RMAN |
| | | Recovery Without Hurdles |
| | | New Features in Oracle Database 10g Release 2 |
| | | Summary |
| | Part III. Tuning Oracle Database 10g |
| | | Chapter 10. Adopting a New Approach to Tuning |
| | | A New Performance Philosophy |
| | | New and Improved Views |
| | | Time and Wait Model |
| | | OEM and Tuning |
| | | New Features in Oracle Database 10g Release 2 |
| | | Summary |
| | | Chapter 11. Effectively Using the Automatic Workload Repository |
| | | Introducing the AWR |
| | | Customizing the AWR |
| | | Performing Baselining |
| | | Active Session History |
| | | New Features in Oracle Database 10g Release 2 |
| | | Summary |
| | | Chapter 12. Effectively Using the Automatic Database Diagnostic Monitor |
| | | Introduction to ADDM |
| | | Interfacing to ADDM |
| | | Making Sense of ADDM Data |
| | | New Features in Oracle Database 10g Release 2 |
| | | Summary |
| | | Chapter 13. Effectively Using the SQL Advisors |
| | | Automating the SQL Advisors |
| | | Using the Advisors for Tuning |
| | | Avoiding Advisor Pitfalls |
| | | New Features in Oracle Database 10g Release 2 |
| | | Summary |
| | | Chapter 14. Influencing the Cost Based Optimizer |
| | | New Optimizer Improvements |
| | | SQL Profiles |
| | | Effective Use of Histograms |
| | | New Features in Oracle Database 10g Release 2 |
| | | Summary |
| | Part IV. Scaling and Availability with Oracle Database 10g |
| | | Chapter 15. Utilizing Oracle Database 10g Real Applications Clusters |
| | | Oracle 10g RAC Overview |
| | | Cluster Ready Services |
| | | Service Workload Management |
| | | 10g RAC Installation and Migration Enhancements |
| | | 10g RAC Manageability Enhancements |
| | | Automatic Storage Management for Cluster Management |
| | | Third-Party Cluster Management Support |
| | | Limited Rolling Upgrade with OPATCH |
| | | 10g RAC Tips for Better Use |
| | | Advanced RAC Features in Oracle Database 10g Release 2 |
| | | Summary |
| | | Chapter 16. Utilizing 10g Physical and Logical Standby with Data Guard |
| | | Oracle 10g Data Guard Overview |
| | | General Improvements with Oracle 10g Data Guard |
| | | Logical Standby Improvements |
| | | Data Guard Broker Improvements |
| | | Applying Patch Sets with Data Guard in Place |
| | | New Features in Oracle Database 10g Release 2 |
| | | Summary |
| | | Chapter 17. Effectively Using Flashback Technologies |
| | | Brief Overview of Flashback Technology |
| | | Flashback Database |
| | | Flashback Table |
| | | Flashback Drop with Recycle Bin |
| | | Flashback Versions Query |
| | | Flashback Transaction Query |
| | | Advanced Flashback Features in Oracle Database 10g Release 2 |
| | | Summary |
| | | Chapter 18. Leveraging Grid Technology Features |
| | | What Exactly Is the Grid? |
| | | Oracle's Version of the Grid |
| | | Managing the Grid |
| | | Summary |
| | Part V. Using Oracle Database 10g Utilities and Other Advanced Features |
| | | Chapter 19. Maximizing Data Movement with Oracle Data Pump |
| | | Oracle 10g Data Pump Enhancements |
| | | External Table Enhancements |
| | | Advanced Data Pump Features in Oracle Database 10g Release 2 |
| | | Summary |
| | | Chapter 20. Using 10g SQL*Plus and iSQL*Plus |
| | | 10g SQL*Plus Enhancements |
| | | 10g iSQL*Plus Enhancements |
| | | Advanced iSQL*Plus and SQL*Plus Features in Oracle Database 10g Release 2 |
| | | Summary |
| | | Chapter 21. Making the Most of Oracle Database 10g |
| | | A Collection of Useful Features |
| | | DML/DDL Features |
| | | Network Features |
| | | Security Features |
| | | Resource Manager and Scheduler |
| | | New Database Initialization Parameters |
| | | Oracle Streams Enhancements |
| | | MetaLink Integration with Oracle Database 10g |
| | | Oracle Database 10g EM Patch Cache |
| | | Oracle Applications 11i with Oracle Database 10g |
| | | Summary |
| | Index |