CIS 2131 - Database Performance Tuning

Institution:

Atlanta Technical College

Subject:

Description:

This course enables the database student to be able to fine tune ORACLE databases. Topics include: Tuning overview, Oracle Alert and Trace Files, Utilities and Dynamic Performance Views, Tuning the Shared Pool, Tuning the Buffer Cache, Tuning the Redo Log Buffer, Database Configuration and I/O Issues, Using Oracle Blocks Efficiently, Optimizing Sort Operations, Tuning Rollback Segments, Monitoring and Detecting Lock Contention, SQL Issues and Tuning Considerations for different applications, Managing a Mixed Workload, Tuning with oracle Expert, Multithreaded Server Tuning Issues. This course enables participant to be able to fine tune ORACLE databases. Hours: Class/Week 4 D.Lab/Week 6 Credit 7 Prerequisite: CIS 2130

Credits:

6.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.atlantatech.edu/

Phone Number:

(404) 225-4400

Regional Accreditation:

Southern Association of Colleges and Schools

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.