Blog - comments

Hi goog article can we install avdf firewall with flat network if it's possible please let me know ?

Thilina
First, thank you for your interrest in this blog.Yes, the byte code will be interpreted each time bu...
BIEHLER Stephane
Pretty sure this is wrong:> already said that JVMs interprets the generated byte code - that's true...
Gs
Michael, great article, however, I would disagree on DRS/Host Affinity. You are legally only requir...
David Bradshaw
Hi lauri, db_file_multiblock_read_count is still used in exadata smartscan because it defines the si...
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

UKOUG_LasVegas

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:
1

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.

Comments

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

Leave your comment

Guest Wednesday, 22 October 2014
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)

Contact

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