Blog - comments

Hi Stephane,

In fact at dbi services we have professional material ;-)

Samsung SSD 840 PRO Series

Gregory Steulet

I have a write throughput 10x lower than your test (is it the SSD?)

stephane (ebu)
You obtained :Running the test with following options: Number of threads: 64 Random number generator...
stephane (ebu)

I wrote a benchmark based on your own. I'm so far from your result (which is very good for a laptop)

stephane (ebu)
Hi Stephane,It depends, you can find the stats for MySQL 5.6 below:sysbench 0.5: multi-threaded sys...
Gregory Steulet
Blog Nicolas Jardot UKOUG 2012: Day 2 - Not only about Oracle Optimizer (CBO)

dbi services Blog

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
Posted by on in Technology Survey

UKOUG 2012: Day 2 - Not only about Oracle Optimizer (CBO)

Yesterday was a very busy day at UKOUG 2012: many technical sessions about performances and also a time travel back in the evening. I really like sessions about performances (Oracle Optimizer) and Oracle behinds, but I will not focus on the technical side because it will take too much time (maybe in future blogs!). I will just summarize a little the main interesting topics.

I had the opportunity to attend several sessions during this day keeping the theme of the execution of SQL statements: how works the optimizer, how can we influence the decisions of the CBO (Cost-Based Optimizer), how can we check the execution, etc...

SQL Monitor

It's a feature embedded in Enterprise Manager but you can also run it from SQL Plus. The generated reports focuses on one SQL execution but give us all details on where the database spent his time to give the results.
You can see each part of an execution plan and its corresponding CPU or I/O consumption. It also displays all plan statistics you can find with dbms_xplan to quickly see of the plan seems to be the wrong one.

And I can add that the HTML version is pretty cool, some components are dynamic and self-contained in the page itself.

Optimizer hints

Maria Colgan explained us that hints are some additional information we can give to the optimizer to help plan calculation. That's why hints seem to be ignored sometimes but in fact it's because the information was not enough or not useful in that particular case.

If you want to use hints, the event trace 10053 will be you friend to know if the hints are been recognized and used by Oracle.

Controlling the execution plans

Oracle provides us several ways of controlling the execution plans without modifying the code:

  • Outlines
  • SQL Profiles
  • SQL Patches
  • SQL Baselines

They are a lot of cases where we need to fix an issue quickly without having the time to perform a deep analysis. Therefore these methods should be considered as exception and most of time as a solution to give time to resolve the root cause.

Back in the future


This year event theme was 1950's Las Vegas.

Very nice theme, many people at the tables but I enjoyed playing with the provided chips. 
It was also the moment where the speakers are available to discuss not only about the technics.

See you for the last conference day.

Rate this blog entry:

Nicolas Jardot has more than two years of experience in Oracle database management and Microsoft application development. He is specialized in Oracle tuning as well as in the Oracle Optimizer. Nicolas Jardot perfectly masters the behavior of the Oracle Optimizer, holding speeches on the topic at the Oracle OpenWorld 2013 and the UKOUG 2013. He is also specialized in C++ development and masters the programming of requests in SQL language. Nicolas Jardot has a solid experience in the virtualization and centralization of applications. He has developed several PL/SQL packages aimed to simplify the administration of database applications and maintains the DMK_SQL package of dbi services' Database Management Kit. Nicolas Jardot is Oracle Certified Professional 11g (OCP 11g) and ITIL Foundation V3 certified. He holds an Engineer's Degree in Computer Science from the University of Technology of Belfort-Montbéliard (F). His branch-related experience covers Pharma, Public Sector, Health, Real Estate, Automotive, etc.


  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Sunday, 02 August 2015
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)


Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter