Enterprise DBA Part 2: Oracle 8i Performance and Tuning
Prerequisite: CSCI 379: Enterprise DBA Part 1A - Oracle 8i Architecture and Administration or experience or similar background
This course is offered in Spring 2002 and is one of many planned here in Computer Science that will prepare you to become an Oracle Certified Professional.
Your TAs for this class are -
Daniel (Pei-yu) Chung with email address peiyu@ecst.csuchico.edu
Chakorn (Joe) Vithayasai with email address vvithaya@ecst.csuchico.edu
 |
Take this link to find out more about how to join the Oracle Academic Initiative. |
|
Take this link to find out how to install the course software at your site for this class. |
Course Reading Schedule and Powerpoint Slides:
Link to your Course Grades thus far (you will need your *secret number* as assigned by your TA):
Below are a number of links related specifically to the cumulative exercise for this course, the Performance Tuning Workshop Team Exercise:
|
SUMMARY TABLE OF PERFORMANCE TUNING STATISTICS, GOALS, AND REMEDIES: |
|
|
|
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.
|
For UNIX environments - Take this link to find out how to prepare the course database for the culminating exercise of the course - The Performance Tuning Workshop! |
Return to Melody's Home Page.