Setting Up Your Environment
In this section, I cover how to set up an environment capable of executing the examples in this book, specifically with regard to the following topics:
- How to set up the
SCOTT/TIGERdemonstration schema properly
- The environment you need to have up and running
- How to configure AUTOTRACE, a SQL*Plus facility
- How to install Statspack
- How to install and run runstats and other custom utilities used throughout the book
- The coding conventions used in this book
All of the non-Oracle-supplied scripts are available for download from the Source Code section of the Apress web site (http://www.apress.com).
Setting Up the SCOTT/TIGER Schema
SCOTT/TIGER schema may already exist in your database. It is generally included during ...