Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

Part I Getting Started

1 Introduction

2 Oracle Database Performance Method

Part II Proactive Database Tuning

3 Automatic Database Performance Monitoring

4 Monitoring Real-Time Database Performance

5 Monitoring Performance Alerts

Part III Reactive Database Tuning

6 Manual Database Performance Monitoring

7 Resolving Transient Performance Problems

8 Resolving Performance Degradation Over Time

Part IV SQL Tuning

9 Identifying High-Load SQL Statements

10 Tuning SQL Statements

11 Optimizing Data Access Paths

Index