Loading Events

« All Events

  • This event has passed.

What the Heck is the Oracle Optimizer Doing? Part 2 – Plan Costing

February 3 @ 13:30 - 14:30

O que diabos o Oracle Optimizer está fazendo? Parte 2 - Plano de custos

Session Abstract:

When Oracle optimizes your SQL, it works out what it thinks is the best way to execute your statement to retrieve your data as quickly as possible, minimising unnecessary resource usage.

This presentation will look at what Oracle is doing. We will use the 10053 trace functionality to show how Oracle uses statistics to cost your SQL access paths, showing what cost really means and how it works, and the impact of messing with system statistics on your database.

Note: This webinar session not planned for recording, please attend the live session only.
Imagem
Neil Chandler
Database Guy, Chandler Systems

Neil has been working in IT since 1988, and with Oracle software since 1991.

He is an independent consultant who specialises in Performance Tuning, RAC, DataGuard, Goldengate, Upgrades, Data Migration, with some PL/SQL and Apex Development for good measure.

He likes to drink strong smooth Italian coffee, good beer and better whisky, depending upon the time of day.

Neil is an Oracle ACE Director, and a board member of the UKOUG

Details

Date:
February 3
Time:
13:30 - 14:30
Event Categories:
, , , ,
Event Tags:
Website:
https://www.aioug.org/events/what-the-heck-is-the-oracle-optimizer-doing-part-2-plan-costing