This module covers performance and tuning concepts, what system resources affect performance, and how tuning often requires that you give up one aspect of performance, to gain another.
Participants learn to use system functions for monitoring the performance of specific queries.
This module examines how the Query Optimizer creates a plan for processing queries and how you can create useful indexes that enable the optimizer to choose the optimal plan. Creating useful indexes by matching them with the proper queries is a large part of the tuning process. The Query Optimizer - Query Analysis Unit 3. This module discusses mechanisms that the server uses to maintain data integrity and consistency, and how that affects performance. Included in this module are detailed discussions on rollback segments, redo log, tablespaces and locks.