O'Reilly logo

Expert Oracle Database Architecture: Oracle Database 9 by Thomas Kyte

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required