Optimizer One-Day Master Class
Since its introduction in Oracle 7, people have been fascinated and intimidated by the Cost-Based Optimizer and the statistics it relies on. It has long been felt that the internals of the Optimizer were shrouded in mystery and that a degree in wizardry is required to be able to make it do the right thing. This one day workshop will explain the fundamentals of the cost based Optimizer and the statistics that feed it, as well as providing a methodology for diagnosing and resolving SQL execution performance problems. The workshop begins with an in-depth look at statistics and statistics maintenance, a challenge all DBAs must face in order to prevent suboptimal execution plan. This presentation includes information on the features introduced in Oracle Database 11g to improve the quality and efficiency of statistics gathering, as well as strategies for managing statistics in various database environments. These strategies include how to use dynamic sampling and when, and how, to manually set statistics directly versus collecting them.
The workshop continues with a detailed explanation on how to interpret an execution plan. Each aspects of an execution plan is examined, from cardinality estimates to parallel execution and you will learn what information you should be gleaming from the plan and how it affects the execution.
After lunch the workshop focuses on the process of analyzing and resolving the most common SQL execution performance problems including, poor cardinality estimations, bind peeking issues, selecting the wrong access method and more. With clear how-to examples you will learn how to identifying and quickly resolving these issues and develop a methodology to prevent them in the future.
This event is chargable to both UKOUG members and non members.
If you are member of UKOUG and would like to attend this event a charge of £125 +VAT will apply.
Non-members will be charged £175 +VAT
3 Reasons why you should attend this SIG: