Oracle related rants (and lots of off-topic stuff)…
In today’s video we demonstrate how to format query results in SQLcl using query comments and the SQLFORMAT setting.
For those of you that prefer to read, the video is based on this article.
The star of today’s video is Charles Wilson, who I got chatting with at the OTN lounge at a previous OpenWorld. 🙂
Cheers
Tim…
Today’s video is a dash through some of the Approximate Query Processing functionality introduced in Oracle database 12.2.
If watching videos scares you, don’t worry, you can get all the information and more from these articles.
The star turn in today’s video is provided by Franck Pachot. 🙂
Cheers
Tim…
Today’s video gives a quick run through of flashback version query.
If you prefer to read articles, rather than watch videos, you might be interested in these.
The star of today’s video is Tanel Poder. I was filming some other people, he saw something was going on, came across and struck a pose. I figured he knew what I was doing, but it’s pretty obvious from the outtake at the end of the video he was blissfully unaware, but wanted in on the action whatever it was! A true star! 🙂
Cheers
Tim…
Today’s video is a quick demo of flashback query.
If you prefer to read articles, rather than watch videos, you might be interested in these articles.
The cameo for this video comes courtesy of Dina Blaschczok, a DBA based in South Africa and a friend of the family. When the wife goes down to SA, Dina takes care of her and occasionally introduces her to big cats. 🙂
Cheers
Tim…
Over the holiday period I finally decided to tackle the Adaptive Query Optimization stuff in Oracle 12c, which resulted in these articles.
Adaptive Query Optimization is really a collection of different features, hence the links page to bring them all together. Some of the features are just renamed and slightly modified versions of stuff from previous releases. Other bits are totally new. I’ve sat through a number of talks about this stuff over the last few years and the sound-bites make it seem quite obvious and straight forward. That’s because the individual pieces, for the most part, are quite straight forward. The trouble comes when they all start to interact, at which point things can get quite confusing. While I was doing the demos for the features, I had to chop and change quite a bit. Sometimes things didn’t happen when I thought they should. Other times things did happen when I thought they shouldn’t. I think much of it was down to my misunderstanding, but that just goes to show how tricky some of this can be… That’s without adaptive cursor sharing and SQL plan management thrown into the mix…
As I keep saying, these articles will probably get revised over time as I get a better understanding of this stuff. I have a feeling I won’t really get to grips with it until we are live on 12c for a number of projects and people start throwing real situations at me to investigate.
Cheers
Tim…