Blog - comments

Hi Olivier, That's a good question. I think the reason is that data_object_id cannot identify a segm...
@toms and others: -- create your output: iozone -Rab output.xls /u01-- scp off to desptop, or to loc...
Scott
Hi Frank,Very interesting post ! Congratulations for starting an Oracle 7 ; did you virtualize an HP...
Olivier Berthommé
Belle démo, je crois que je vais te la piquer ! Mais as tu essayé un DBCC CHECKCONSTRAINTS ou un DBC...
SQLpro

Thanks Franck , you are a savior! Great article indeed.

Prasad
Blog Nicolas Jardot OakTable at UKOUG 2012: Hybrid Columnar Compression (Exadata), SQL tuning, etc.

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

OakTable at UKOUG 2012: Hybrid Columnar Compression (Exadata), SQL tuning, etc.

Yesterday, I went to a set of sessions organized by OakTable members just before the kick-off of the UKOUG conference 2012, one of the biggest events on Oracle Technology and E-Business in Europe. This post focuses on some of the covered topics, such as database development, Hybrid Columnar Compression (Exadata), optimizer statistics, and SQL tuning.

There were 2 streams with very interesting topics. I attended to sessions covering the following topics:

  • Application development: Keep it simple
  • Compression
  • Guiding practices for optimizer statistics
  • Tuning SQL using profiles

The first session was not really technical, it was about best practices when it comes to database development. The main point is to not to think that simple equals easy: The goal is to write an application which will be maintainable. To do so, it is important to think about database design and not to focus only on one possible method.

The second session was about a new compression feature called Hybrid Columnar Compression is available on Exadata. It was very interesting because in some cases compression can be CPU killer feature. We also reviewed how basic and OLTP compression works.

After a quick lunch, we started again for the two last sessions.

The optimizer statistics are often a source of performance issues due to missing or bad statistics. However, developing a customized job is very time consuming and Oracle does the correct job for most of cases. The big advice is to let the default job and treat the exceptions. 

The last session was about how using profiles to change plans without touching the code of an SQL statement. This Oracle feature is very useful when you quickly need to treat the symptoms because you have no time to solve the root cause. We had a look at how to create a profile with the tuning advisor and also by hand.

In conclusion, it was a very good introduction day with experts that were available to share their astounding knownledge!

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 Saturday, 01 November 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