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 ...