Oracle Database 12c Release 2 Testing Tools and Techniques for Performance and Scalability

Contents

Acknowledgments

Introduction

PART ITools and Test Rigs

1   Presenting Tools for Tuning

An Oracle DBA’s Tool Belt: Tools for Tuning

Chapter Roadmap

Part I—Tools and Test Rigs

Part II—Digging Deeper: SQL Performance Management Tools

Part III—It’s Running Slow: Database Performance Evaluation

Part IV—Testing to Destruction

Part V—A Brave New World: Database In-Memory

Part VI— Appendixes, with Other Tuning Tools, Code Examples, and References

Summary

2   Testing Methodology

TPC-DS: An Appropriate Benchmark for Testing

TPC-DS Database Schema

TPC-DS Application Workloads

Swingbench: Our Tool of Choice for Workload Generation

Swingbench Overview ...