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 setup the EODA account used for many of the examples in this book
  • 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 web site. If you download the scripts, there will be a chNN folder that contains the scripts for each chapter (where NN is the number of the ...

Get Expert Oracle Database Architecture, Third Edition now with O’Reilly online learning.

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