Expert Oracle JDBC Programming

C H A P T E R  1

Performance Toolkit

In this chapter, you’ll learn how to set up an environment so that you can test the example code in this book. You’ll also learn about some common utilities for benchmarking performance used throughout this book. The chapter covers the following topics:

• Setting up your SQL*Plus environment
• Setting up the SCOTT/TIGER demonstration schema
• Setting up the BENCHMARK/BENCHMARK schema, which we’ll use throughout the book for executing some of our code examples
• Setting up sql_trace, timed_statistics, and tkprof, two parameters and a command-line tool that will tell you what SQL your application executed and how ...