Oracle Optimization Schulung:
Understand the optimization process
This seminar is prepared for developers and DBAs in order to help them to understand the optimization process and introduce them in performance problem troubleshooting. During the course we discuss in details the basic database mechanisms. This step is necessary to understand the possible bottlenecks in SQL statement execution and become familiar with the remedies for performance problems.
In subsequent lessons we study the SQL statement execution, the influence of binding variables on SQL statement execution and their side effects. Then we move to the cost based optimization details. In second day we start with the wait events and response time analysis. The index internals are discussed in separate lesson. In this session we try to find the answers why indexes are not used. We also discuss available database features, which can be used for access path optimization. In the last session we discuss the optimizer hints and SQL Profiles.