Access articles and resources written by some of the best Oracle brains in the world.
Oracle Cost-Based Optimizer Advanced Session
Presented by Randolf Geist
Weds 1st August 2012
This webinar has now finished, but feel free to click the button above to watch the recording.
Summary
Building on the previous Cost-Based Optimizer Basics webinar, in this almost "zero-slide" session we'll explore different aspects of the Cost-Based Optimizer that haven't been covered or only mentioned briefly in the 'basics' session.
This is a continuous live demonstration including topics like: Clustering Factor, Histograms, Dynamic Sampling, Virtual Columns, Daft Data Types and more. If you've ever asked yourself why a histogram can be a threat to database performance and why storing data using the correct data type matters regarding Execution Plans then this session is for you. It is recommended, although not required, to watch the recording of the 'basics' webinar first.
A live Q+A session with Randolf Geist will follow the presentation.
Randolf Geist
Oracle ACE Director, member of the OakTable Network, instructor for the Oracle University as part of their "Celebrity Seminar" program, co-author of Expert Oracle Practices, published by the "OakTable press". Expert on All Things Oracle.
All Things Oracle.com
Schema Compare for Oracle
- Compare 2 schemas and see highlighted differences side-by-side
- Automatically create update scripts to migrate any changes
