Oracle SQL Statement Tuning

Students will focus on the Oracle Cost-Based Optimizer (CBO). The students learn to use the Oracle diagnostic tools and facilities: EXPLAIN, SQL*Plus AUTOTRACE, and other tools. Gathering and utilizing object and system statistics is covered in detail. In addition, the participants also learn to influence the behavior of the CBO by hinting and modifying physical database objects.

Download

3 days

$1,850.00

Presently this course is not scheduled. Courses are scheduled based on client demand. To schedule this course, simply contact us.