X

Insights into Statistics, Query Optimization and the Oracle Optimizer

  • 12c |
    Tuesday, June 25, 2013

Oracle Database 12c is here!

By: Maria Colgan | Master Product Manager

Oracle Database 12c was officially release today and is now available for download. Along with the software release comes a whole new set of collateral that explains in detail all of the new features and functionality you will find in this release.

The Optimizer page on Oracle.com has all the juicy details about what you can expect from the Optimizer in Oracle Database12c.  There you will find the following 3 new white papers;

Over the coming months we will also present an in-depth series of blog posts on all of the cool new Optimizer features in 12c so stay tuned for that and happy reading!

+Maria Colgan

Join the discussion

Comments ( 6 )
  • guest Monday, July 1, 2013

    Hello,

    In case for hybrid hystograms cardinality for endpoint value=52114 with repeat_count=24 calculated as 250. Why not simply 24?

    Best regards,

    Mikhail.


  • guest Tuesday, July 2, 2013

    Hi Mikhail,

    The actual number of rows in the customers table with a cust_city_id=52114 is 227, so a cardinality estimate of 250 is very close. The reason the frequency is not recorded as 227 is because histograms are created on a sample. We example exactly how histogram creation happens in our blog post on April 2nd 2012;

    https://blogs.oracle.com/optimizer/entry/i_thought_the_new_auto

    Thanks,

    Maria


  • guest Friday, July 12, 2013

    Hi Maria,

    I've read about the new null-accepting semi-joins. Why are they only working with EXISTS subqueries but not with IN subqueries, even if those were the subject for unnesting and semi-join?

    Best regards,

    Andrej


  • guest Friday, August 16, 2013

    Hi Maria,

    in 11g, histogram collection has always been done on an approximate sample size of 5,500 non-null values.

    Has this been modified in 12c (may be due to the new types of histograms)?

    Best regards

    Reiner


  • guest Wednesday, August 21, 2013

    Hi Maria,

    in 11g, histogram collection has always been done on an approximate sample size of 5,500 non-null values.

    Has this been modified in 12c (may be due to the new types of histograms) ?

    Best

    Reiner


  • guest Tuesday, August 5, 2014

    Why is this blog inactive. Is this team no longer there in oracle ?


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha
Oracle

Integrated Cloud Applications & Platform Services