dbi services Blog

Welcome to the dbi services Blog! This blog focuses on database infrastructure and middleware topics. It covers technologies such as Oracle, Microsoft SQL Server, MySQL, Sybase, Linux, or Documentum (etc.). The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on the postings!

Jonathan Lewis @ dbi services: Oracle Optimizer workshop

Thursday, 01 March 2012 Posted by Hervé Schweitzer Category Development & Performance 0 comment

Last week, Oracle Ace Director Jonathan Lewis held an Oracle Optimizer Workshop at dbi services Basel Area. I would like to share some of the key learnings of this really interesting exchange I experienced together with my colleagues.

In his workshop, Jonathan Lewis covered an impressive amount of Oracle optimizer know how: from the fundamentals of the Cost Based Optimizer (CBO) to the latest 11.2 Oracle Optimizer features. Useless to say that we were all amazed from Jonathan's expertise.

Jonathan Lewis workshop dbi services Basel Area

Jonathan provided an impressive insight into the Oracle Optimizer which really helped me to better grasp the decisions of the Cost Based Optimizer (CBO). Understanding how and why nested loops or hash joins are used is a black box if you are not aware of the underlying "maths". This kind of information cleary was a big added value of Jonathan's workshop. He also gave us lots of practical and very funny examples of his experience at customer sites.

Jonathan Lewis workshop dbi services Basel Area

As most of you know, Jonathan Lewis is a well known figure in the Oracle community and has also published several books (last publication in November 2011: Oracle Core: Apress, ISBN 978-1430239543). His blog really is a key Oracle resource (http://jonathanlewis.wordpress.com/) and he also contributes to several other blogs, newsgroups, forums, and Oracle User Group magazines.

Jonathan Lewis workshop dbi services Basel Area

Again, Jonathan, thanks a lot for your great workshop!

Tags: Performance, Oracle optimizer, Workshop

How to avoid strange figures in the Oracle optimizer system statistics Have you ever noticed strange figures while collecting the Oracle optimizer system statistics ? If so, you need to provide the optimizer with the corr...
Simulating and testing I/O performances with ORION Since Oracle 11.2, Oracle provides ORION in the RDBMS binaries (in ${ORACLE_HOME}/bin). ORION - ORacle Input Output Numbers - is an I/O calibration to...
How to retrieve previous table statistics using Oracle dbms_stats Sometimes, you need to modify the statistics of a table. There are various reasons: either for the performance analysis or because the execution plan...
Saving time and increasing service availability with MySQL Enterprise Monitor 2.3 Nowadays, MySQL Databases are encapsulated into many mission critical software solutions. Lots of companies host one or many MySQL databases in their ...
A SQL statement is slow and suddenly fast? Have a look at "Cardinality Feedback"! While discussing with some tuning gurus, I was made aware about this feature. It is not so far from the adaptive cursor sharing perfectly described in...

About the author

Hervé Schweitzer

Hervé Schweitzer is Principal Consultant and responsible of High Availability solutions at dbi services.

He has more than ten years of experience in database and infrastructure management, engineering, and optimization.

He is specialized in Oracle technologies such as standardisation, Backup and Recovery, Tuning, and in High Availability solutions such as Oracle Data Guard, Oracle Grid Infrastructure, Oracle Real Application Clusters RAC, Oracle GoldenGate and Oracle Failsafe.

http://www.dbi-services.com