|
Provided by: Serebra Learning Corporation Tuning Database Structures in Oracle9i |
 |
Training
Provided by Serebra Learning Corporation
To describe how to tune components of an Oracle9i database Anyone wishing to learn about Oracle9i database performance tuning
|
|
||||||||
Tuning Database Structures in Oracle9i
Audience
Anyone wishing to learn about Oracle9i database performance tuning
Topics
Objectives
- Tuning Database Structures in Oracle9i
- describe I/O concepts and discuss how to analyze and tune I/O in an Oracle9i database.
- diagnose and tune I/O performance problems in an Oracle9i database.
- describe how to tune the sorting process and to differentiate between types of sorts in an Oracle9i database.
- discuss undo management and how to monitor and tune rollback segment activity in an Oracle9i database.
- manually determine the number and size of rollback segments in an Oracle9i database.
- describe the types and features of locks and to describe how to avoid lock contention in an Oracle9i database.
- explain how to optimize extent management and to discuss the high-water mark.
- discuss how to optimize block and index usage in an Oracle9i database.
- detect and resolve row migration and chaining in an Oracle9i database.
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
