TITLE: Selected Topics in Computer Programming : Database Performance Tuning
Lead Instructor: TBA
Office: TBA
Phone: TBA

Office Hours:

     Title: Oracle9i Performance Tuning: Optimizing Database Productivity
     Author: Hassan A. Afyouni
     ISBN: 0-619-16004-7
     Publisher: Thomson Course Technology

Software used to complete coursework: Oracle 9i,Refer http://otn.oracle.com/software/content.html
Other required equipment:

Credit Hours: Three (3) Semester Hours
Pre-requisites: CIS257
Co-requisites: none

Course Description:
This course provides an opportunity to explore areas of current interest in Computer Programming. Emphasis is placed on subject matter appropriate to computer programming. Upon completion, students should be able to demonstrate an understanding of the specific area of study.

Course Goals:
  1. To obtain the education and hands-on skill to Administer an RDBMS, Relational Database Management System
Course Objectives:
Upon successful completion, students will be able to demonstrate (through completion of classwork and assignments):
  • An understanding of the Oracle Performance and Tuning
  • An understanding of Tuning Goals
  • An understanding of Performance Problems
  • An understanding of DBA Roles and Responsibilities
  • An understanding of Oracle Tunig Tools
  • The education and hands-on skill to pass Oracle Certification Exam 1Z0-032
The Core Values of Wake Technical Community College
Respect Instructor and students will foster an environment that is respectful of all.
Responsibility Instructor and students will foster an environment that promotes taking responsibility for one's actions and obligations.
Critical Thinking Instructor and students will strive to improve the critical thinking skills of analysis, synthesis, and evaluation.
Communication Instructor and students will strive to ensure that both written and oral communications are clearly understood.
Collaboration Instructor and students will strive to develop collaborative skills.

Grading Is As Follows:
Exam 60 2 @ 30% each
Labs/Projects 30 up to 10 Lab Assignments
Attendance 10

Classroom Policies:
  • Students are responsible for all of the information presented in the Wake Technical Community College Student Handbook.
  • Please note that computers are to be used at all times for official course purposes. Use of computers for general web surfing, email, chat rooms, etc. is not allowed. Violation of this rule will result in a grade deduction and possible loss of computer privileges.
  • The college forbids the use of audible electronic equipment (cell phones, pagers, etc.) during instructional time.
  • If you miss a lecture or arrive late, you are responsible for the material presented, handouts distributed, and any announcements made that day. The instructor will not provide notes for missed classes.
Tentative Schedule
Note: This schedule is subject to some changes/modifications per Instructor -- This offered as only a study guide. The pace of each class differs according to the instructional needs of the students in the class. Always consult with your instructor. Note** A Final Project may be assigned in leiu of a Final Exam.
Week Coursework Textbook/Assignments
Performance Tuning Overview
Chapter 1
Tuning the Buffer Cache and Redo Log Buffer
Chapters 2, 3
Tuning the Shared Pool Memory, Working with the Program Global Area
 Chapters 4, 5
Optimizing Data Storage and Tablespaces

 Chapters 6 & 7     
Tuning Undo Segments and Detecting Lock Contention
 Chaptesr 8, 9
Other Tuning Issues and Tuning Tools
 Chapter 10, 12
SQL Tuning
Chapter 13
Optimizing Applications
Chapter 14
Final exam

Disability Support Services is available for students who require academic accommodations due to any physical, psychological, or learning disability. To determine eligibility, contact the office at 108-S Holding Hall or call
662-3405 (TDD 779-0668)

Copyright 2004/2005 Wake Technical Community College All Rights Reserved