Setting Up Your Environment

In this section, I will cover how to set up an environment capable of executing the examples in this book. Specifically:

  • How to set up the SCOTT/TIGER demonstration schema properly

  • The environment you need to have up and running

  • Configuring AUTOTRACE, a SQL*Plus facility

  • Installing Statspack

  • Installing and running runstats, and other custom utilities used throughout the book

  • The coding conventions I use in this book

All of the non-Oracle supplied scripts are available for download from the www.apress.com website.

Setting up the SCOTT/TIGER Schema

The SCOTT/TIGER schema will often already exist in your database. It is generally included during a typical installation, but it is not a mandatory component of the database. You may ...

Get Expert Oracle Database Architecture: Oracle Database 9 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