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 (http://www.apress.com).

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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial