Course Overview
This course will introduce participants to the importance of good initial database design, and the methods used to tune a production Oracle9i database. The focus is on Database and Instance tuning rather than specific operating system performance issues. Students will gain practical experience configuring memory and disk resources; detecting and resolving contention problems; diagnosing and resolving performance issues associated with shared server; reconfiguring file structures for optimal performance. Oracle tools used by the students to diagnose performance problems will include STATSPACK. BCIT is a member of the Oracle Workforce Development Program and uses Oracle University course materials (a $300.00 value) included with tuition. Please enroll early, course materials are ordered on an as needed basis and takes 7-10 days to arrive.
Prerequisite(s)
- 50% in COMP 4664
Credits
4.0
- Retired
- This course has been retired and is no longer offered. Find other Flexible Learning courses that may interest you.
Learning Outcomes
- Size memory structures.
- Optimize sort operations.
- Diagnose contention for latches.
- Tune UNDO segments.
- Monitor and detect latch contention.
- Tune Oracle Shared Server.
- Use Oracle blocks efficiently.
- Tune SQL statements.
Effective as of Winter 2006
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.