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/TIGER demonstration 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 (

Setting Up the SCOTT/TIGER Schema

The SCOTT/TIGER schema may already exist in your database. It is generally included during ...

Get Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.