How to Setup your Course Database - PERFDB -  for the 

Performance Tuning Workshop

Note: All necessary files mentioned are located in the LABS subdirectory 

of the perftuneclass directory

a. Shutdown your PERFDB instance.

b. Restart your PERFDB instance using the initwks.ora file (located in the LABS directory within your perftuneclass directory).

c. Run the script prewks.sql in sqlplus (located in the LABS directory).  Read the script before running. This is supposed to remove any extra tablespaces, files, and rollback segments that you created during the labs.  Be sure to edit the script if you need to replace path names, etc.

d. Run the script wks.sql (in LABs) after prewks.sql is done.

e. Shutdown your instanceand restart using the initbad.ora file located in the LABS directory.

Now you are ready for the Performance Tuning Workshop!