Just because an SQL statement returns the correct result does not mean that access to the data is effective. As application developers are often under time pressure, the optimization of SQL statements is often neglected.
In the workshop we start with identifying slow statements and processing, cover the Oracle Cost-based Optimizer and look at proper indexing.
1 Oracle Database Architecture Overview and Definition
2 Identifying processing and TOP statements
3 Important Data Dictionary and Performance Views (V$)4 Creating traces and execution plans with different methods
5 The Oracle Cost-based Optimizer and what influences it:
6 Oracle object statistics, histograms
7 Use of bind variables and hints
8 SQL Profiles, Baselines and Patches
9 Session and instance parameters that influence the optimizer
10 Finding and understanding TOP SQL statements
11 Tuning SQL statements
12 Oracle indexes, constraints and ROWIDs
13 Constraints and their indexes
14 The correct indexing
15 Do and DON'Ts – examples of how not to do it
16 Locking and blocking in the database, understanding database transactions
17 Optional: Oracle Flashback technology, monitoring and parsing trace
The participants receive theoretical knowledge, which is consolidated with many practical exercises.
This workshop is aimed at database administrators and application developers.
Good Oracle SQL knowledge as you can acquire in the following courses:
Course environment (and Oracle license requirements)