Profile
Contact
Search
Cart
|
Profile |
Contact |
Search |
Cart |
 |
Tuning Database Structures |
| Course Status: | Released | Courseware Features |
| Course Language: | English | |
| Course Duration: | 3 Hours | |
| Deployment Options: | Online, Interactive CDs, Network, Downloads, Intranet |
Audience |
| Anyone wishing to learn about Oracle9i database performance tuning |
Prerequisites |
| An understanding of database concepts and technologies |
Course Aim |
| This learning path demonstrates how to identify and resolve common Oracle9i(TM) database performance-related issues. It explains how to analyze and resolve performance problems in tuning memory structures, database structures, and systems and applications. The learning path maps to Exam #1Z0-033: Oracle9i Database: Performance Tuning and comprises instructional objects, simulations, mentored exercises, and a task-based simulation workshop. |
Learning Objectives |
| To describe how to tune components of an Oracle9i database |
Topics Covered |
| Tuning I/O and sort operations Tuning I/O in an Oracle9i database Diagnosing I/O inefficiencies in an Oracle9i database Tuning sorts in an Oracle9i database Configuring undo management Tuning undo segments in an Oracle9i database Manually sizing rollback segments in Oracle9i Monitoring lock contention and block usage Avoiding lock contention in an Oracle9i database Extents and the high-water mark in an Oracle9i database Detecting and resolving row chaining in Oracle9i Optimal block and index usage in an Oracle9i database |