Saturday, September 14, 2013

12c September - Kyte, Osborne & Poder

Sounds like a law firm right?  No, it's just three of the smartest individuals around if you have Oracle issues (one of which will be featured soon) so it makes sense I'd put together their posts today on 12c features.

I'm going to start with Tom Kyte sharing the CBAC (CODE Based Access Control) feature introduced with 12c which pretty much just blew my mind.  I loved the conversation that took place in the comments too!

Yesterday I did share what Tim Hall talked about, but Tom goes over the Implicit Results sets with some additional insights into why it was implemented as well as showing examples too.

Do you know what new bells and whistles that have been added in 12c?  Tom does, and now so can you.  Oh and you might learn something about invisible columns as well!

Another one of the game changer type of features being introduced with 12 is the concept of white listing your code.  You seriously need to see what Tom shares about this!

Here we are introduced to a new bug with using SQL Translation Framework by Kerry Osborne, and to the actual SQL Translation Framework feature itself which appears to have been created to allow us to address performance issues without changing the code!

Then Kerry helps us understand how to control the dial for automatic degree of parallelism.

Last, but not least, is Tanel Poder showing us how the CBO in 12c transforms scalar subqueries that are being used in the SELECT statement.

No comments:

Post a Comment