O'Reilly logo

Oracle by Guy Harrison

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. Tools of the Trade

In this chapter we’ll look at the core tools for assessing and improving Oracle database performance.

A wide variety of tuning tools are available both from Oracle and from third parties.1 However, in this chapter we concentrate on core tools that are available with the base Oracle server that require no special licensing.2

1 Full disclosure: I have worked for Quest Software, where I contributed to the design and implementation of a range of Quest’s Oracle tuning and administration products, most notably the Spotlight on Oracle and Spotlight on RAC products.

2 Oracle ships with a lot of functionality that requires licensing if you make use of it. In particular, the Active Workload Repository (AWR), Automatic Database ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required