CIS 2131 - Database Performance Tuning

Institution:

Georgia Piedmont Technical College

Subject:

Description:

Prerequisite: CIS 2130 with minimum grade of "C" 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.

Credits:

7.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.gptc.edu

Phone Number:

(404) 297-9522

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.