Enterprise DBA Part 2: Oracle 8i Performance and Tuning
Prerequisite: CSCI 276/397C:Oracle 8/8i Database Administration or experience or similar background
This course is offered in Spring 2001 and is one of many planned here in Computer Science that will prepare you to become an Oracle Certified Professional.
 |
New material on how to set up the Workshop Exercise strictly for NT! : |
Read this paragraph or print this page first. Then, take this link to go to Dr. Callan's subdirectory which has the zip file NT8i_perf.zip. Double click on the file to download it. When you unzip the file it will separate out into subdirectories. All the MS-DOS command files you need are in these subdirectories - LABS, DEMO, SETUP. The files that consisted of Unix shell scripts have all been replaced by DOS .cmd files in these NT - oriented subdirectories. The key .cmd file is growdb.cmd. The growdb.cmd file calls some perl scripts - flush.pl, runproc.pl and runusers.pl. Runusers.pl will call all the user0x.cmd dos command files, so you do not need to call them overtly. Thus, the only DOS command file you overtly need to run is growdb.cmd. Since the perl scripts are called from this file and the perl.exe and perl.dll is in the LABS subdirectory, be sure you have changed directories appropriately or have put the perl.exe and .dll files in your path.
Course Reading Schedule and Powerpoint Slides:
SUMMARY TABLE OF PERFORMANCE TUNING STATISTICS, GOALS, AND REMEDIES:
Return to Melody's Home Page.