Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 SQL Performance Analyzer

• Testing Database Upgrade from Oracle Database 9i to Oracle Database 10g
• Enabling SQL Trace on the Production System
• Creating a Mapping Table
• Building a SQL Tuning Set
• Running SQL Performance Analyzer
  • Creating a SQL Performance Analyzer Task
  • Building the Pre-Upgrade SQL Trial
  • Building the Post-Upgrade SQL Trial
• Comparing SQL Performance
• Tuning Regressed SQL

Index