Video : Real-Time Materialized Views

Today’s video is a quick demo of Real-Time Materialized Views,
introduced in Oracle Database 12c Release 2 (12.2).

This is based on information from the following articles.

The cameo for today’s video is Maria Colgan. πŸ™‚



Video : Collation and Case-Insensitive Queries in Oracle Database

Today’s video is a run through the Collation functionality introduced in Oracle Database 12c Release 2 (12.2).

If videos aren’t your thing, you can find a lot more information about this subject in my article here.

The cameo in today’s video is Kim Berg Hansen. πŸ™‚



PS. Subscribe to my YouTube channel here.

OBUG Tech Days Belgium 2019 : Day 2

Day 2 started a little late for me and I missed the first block of speakers. Sorry Alex!

The first session of the day for me was Franck Pachot with “Microservices : Get rid of your DBA and send the DB into Burnout”. The session started with a rousing chorus of “Happy Birthday” for Franck. My bad summary of the session would be, pick the right tool and the right approach for the job. The “obvious” solution for the job is not always so obvious. One size doesn’t fit all!

After that it was keynote time with Gurmeet Goindi and Maria (questions at the end) Colgan. Gurmeet started off with the key features of Exadata past, present and future. Maria continued with some of the optimiser goodness coming in “a future release”.

Next up was Roger McNicol with “Understanding Oracle External Tables”. This was one of those sessions where I sat smugly thinking, “I knew that”, until he started talking about some stuff I didn’t have a clue about. I’ll check out some of this stuff when I get home and sneak it into some existing articles, then act superior, like I always knew it. πŸ™‚

The next session was “REST enabling your Oracle database with Oracle REST Data Services” by Jeff Smith. Which Jeff Smith? That Jeff Smith! I’ve seen Jeff do this talk before, but he’s reworked his demos, so I wanted to see the new and improved version, and I was the next speaker in this room so… πŸ™‚

I was the next speaker, with my session, “Multitenant : What’s new in Oracle Database 18c and 12.2”. There is a lot of good stuff in the Multitentant architecture now. All my articles on the subject are listed here. I think the session went OK, but I did overrun. Sorry!

From there I popped out with some folks for a farewell drink, then it was off to catch my plane. I ended up on the same train as Maria. When we got to the airport I tried to get her case off the luggage rack and it destroyed my hand. For a totally accurate depiction of what happened, check out the “I’ve got his pig sticker” scene from Blade.

I had about 2 hours before my plane left, so I got out the laptop and played catch-up on life. We boarded about 10 minutes late, and then sat on the plane for about 35 minutes before we left. The flight was fine and we gained back a little time on the way. I got a taxi home and that was the end of the trip!

Thanks to everyone at OBUG for inviting me to come and play. Thanks to the attendees and speakers for making the event happen. This was a self-funded trip, but I’d like to thank the Oracle ACE Program and Groundbreaker Ambassadors Program for allowing me to fly the flag.



OBUG Tech Days Belgium 2019 : Day 1

The day started at my normal wake-up time. My flight wasn’t until 10:50, but I decided the leave for the airport really early to avoid traffic. It makes no difference to me if I’m at home on my laptop, in the airport on my laptop, or at work… πŸ™‚

The only thing of note from the airport was me trying to scan through boarding security with my conference ticket, which of course failed, but they let me through anyway. Interesting…

The flight was scheduled for 75 minutes, but it took about 55 minutes, so we clawed some time back. Once landed and through security I headed off to get a train to Antwerp. The train took about 45 minutes, then it was a 2K walk to the venue, arriving fashionably late for the first day!

I arrived in time to see Frits Hoogland presenting “All about Linux memory usage by the Oracle database”. I’ve seen him present this session before, but I’m so rubbish at the subject, it still felt new. πŸ™‚

From there it was Mike Dietrich presenting “Upgrade your Oracle databases fully unattended with AutoUpgrade”. I had a number of questions for Mike, both in the session and afterwards. From what I can see this features looks like it will be really useful.

Finally I watched Jonathan Lewis with “Why Oracle statistics aren’t enough”, where he showed a number of scenarios where statistics are ignored, leading to “interesting” decisions by the optimizer.

When the talks were done there was a social event with drinks and nibbles. We then went out to get some food, walked half way round the city by mistake, then went back to the hotel to crash!



OBUG Tech Days Belgium 2019

The BOUG Tech Days 2019 conference is happening on the 7th-8th February, which is Thursday and Friday this week. I see from the Twitter-verse that some people are already there and checking out the city.

I’ll be flying out on Thursday morning, and flying back Friday night, so it’s an overnight stay for me.

The list of speakers is pretty impressive, so it looks like it’s going to be a good one.

See you there!



Video : Extended Data Types in Oracle Database 12c Onward

Today’s video is a quick run through the Extended Data Types functionality introduced in Oracle Database 12c Release 1. Why such an old subject? Well, it’s a prerequisite for something I was planning to do a video on, so I thought I better do this first. πŸ™‚

For those that don’t like videos, you can find the same information and more here.

The cameo in today’s video if Martin Klier. πŸ™‚



PS. Subscribe to my YouTube channel here.

Pay to Present? I don’t think so!

There is some strong language and emotion here, and remember it’s just my opinion. Don’t read if you are easily offended!

Something interesting crossed my inbox last night. There was an email thread amongst a bunch of presenters about a policy of pay to present at Collaborate this year. I have, and never will present at Collaborate, as Apps is not really my scene, but I think anyone accepting this policy is helping to set a dangerous precedent and I would encourage them not to go. I know funding user group events is problematic, but NO!

Collaborate already do something that I personally think is quite scummy, which is to make you pay $200 extra if you don’t stay in an official event hotel. They’ve done this for a while. This year they are going a step further. If you work for an Oracle partner that isn’t exhibiting at the event, you have to pay to go to the event, even though you are speaking. It’s a reduced rate of $299, but you still have to pay. You can’t present more than one session unless your organisation is a member.

People go to conferences to watch presentations and get advice from presenters. If the presenters weren’t there, there would be no event! We are the commodity they are selling and we don’t get paid to speak. Some lucky people like me get to claim some of our expenses back from evangelist programs, but even then we lose money. I buy back extra holiday from work. Those working in consultancies lose consultancy money. My first two conferences of this year are fully funded by me. If someone were to then tell me, in addition to all the other expenses I incur, I had to pay to go to the event my reply would be something to the tune of, “Shove it up your arse and f*ck off while you’re doing it!”

“But it only affects people working for partners!” Loads of presenters work for partners. Not all partners are giant corporations.

“But think of all the free advertising partners are getting!” Newsflash! Most companies would rather you were working and earning them money than poncing around at a tech conference. Most companies aren’t getting loads of new leads as a result of you presenting at a tech conference. I think people outside the conference circuit have quite a skewed view of what it really is. On numerous occasions I’ve spoken to people about this, and letting their technical staff present is less about company profile and making money, and more about staff development and keeping them happy so they don’t leave and go somewhere else. Good staff come at a price, and not all of it is about wages.

“Times are hard for user groups!” Making the speakers you are relying on to make your event successful pay to attend is a scumbag move.

“But you don’t even go to this conference!” True, but if people start to see this as a revenue stream for their conference, others will follow. I honestly believe this is the thin end of the wedge!

“Why should you get the whole conference experience for free?” I understand this for someone that maybe presents once a year. You could see this as a free learning experience. Having said that, if you present a lot it gets increasingly hard to find something you’ve not seen several times already. Added to that, many presenters are still working during the events. Meetings with existing customers, or just going back to the hotel to do your day job between presentation commitments. It’s not like one long party! πŸ™‚ Update: Samuel Nitsche pointed out, even if you do one presentation a year, you still invest a lot of time to get ready for that, so you still deserve the free pass. I agree. As you say, at least for us we can use the same presentation multiple times, so the investment per event on preparation time is a little less.

“You’re a presenter. Of course you would say that!” I think most of my presenting days are behind me. What happens with user groups and the conference circuit is really of little concern to me personally, but how does this affect who comes next?

I know this might be hard for folks who see Collaborate as their main conference of the year, but I would suggest all speakers and attendees boycott this event unless they reverse this decision! It’s a slippery slope folks!

Just my opinion. You don’t have to agree!



Update : Some extra things coming out of the woodwork from private messages…

  • Two other reports of different user groups suggesting a pay to present model, then backing down when confronted.
  • Sponsor us, or you can’t present seems to be quite common.
  • Some speakers being paid to speak at regular user group events. I have heard this before, but I’ve never been paid. *
  • Some speakers getting travel expenses paid by the user group for regular user group events. I have been offered this a couple of times, but never taken it. One conference I go to pays the hotel bill for speakers, which is very welcome as I usually end up self funding that one. *

* I have no problem with a user group deciding to pay a speaker, or pay expenses, but I would be super-pissed if I had been asked to pay to present, then I found other speakers at the same event had been paid to be there. Screw that!

I’m telling you people. You’ve got to nip this thing in the bud!

VirtualBox 6.0.4

VirtualBox 6.0.4 has been released. Hot on the heels of version 6.0.2, we got this new release last night (UK time).

The downloads and changelog are in the usual places.

I’ve installed it on my Windows 10 laptop at work. I’ll do my personal Windows 10 laptop, old MBP and OL7 server when I get home, and post an update here to say how I got on.



Update: Everything went fine with the installation on my Windows 10 laptop, MBP running macOS Mojave and server running Oracle Linux 7.

Oracle REST Data Services (ORDS) 18.4

It’s hardly news, as Oracle REST Data Services (ORDS) 18.4 has been out for a while, but I thought I would mention a couple of things related to it.

First off, we’ve upgraded (almost) all of our ORDS installations to 18.4 at work. I say almost because we’ve got a couple of 11.2 databases that don’t work consistently with anything newer that ORDS 3.0.12, so they aren’t being touched until we’ve upgraded the databases. This is how I typically do the upgrades.

Regarding my GitHub stuff.

  • Vagrant : My 18c, APEX, ORDS and Tomcat installation uses ORDS 18.4 and Java 11.0.2.
  • Docker : My ORDS build has been upgraded to 18.4 and Java 11.0.2.

We’ve not had any drama related to this. πŸ™‚



Video : JSON Data Guide

Today’s video is an overview of the JSON Data Guide functionality introduced in Oracle 12.2.

If videos aren’t your thing, you can read the articles instead. This video focuses on the main features that were introduced in 12.2, but there are some nice additions in 18c also.

The cameo in today’s video is Toon Koppelaars of #SMartDB fame.



PS. Subscribe to my YouTube channel here.