OUG Ireland 2017 : Day 1

I arrived at the Gresham Hotel, registered and went straight down to the first session of the day…

First up was Maria Colgan presenting, “What to Expect from Oracle Database 12c”, a quick romp through the cool features in Oracle 12c (12.1 and 12.2). The room was full so I had to listen form the corridor, with my head occasionally popping round the door to see the screen. Maria’s sessions are always great value, so definitely get to her if you can.

Next up was Marcin Przepiorowski with “Direct NFS for DBAs”. I’ve used this for some time, but only because Kevin Closson made me. 🙂 Marcin worked through some of the pros and cons and gave a bunch of numbers and graphs to prove is points. Graphs mean science! 🙂

I then moved on to Christian Berg with “Doing Oracle Analytics this way? STOP IT!”. We are transitioning to Oracle BI for the on-prem warehouse associated with our Oracle Cloud Apps stuff. I’m not part of the project and I don’t understand any of this stuff, but I just want to understand some of the vocabulary. I’m definitely understanding some more of the words now. 🙂

Next up was Martin Klier with “42 facts for Grid Infrastructure, ASM and RAC”. This was a quick-fire introduction to RAC and ASM. I’ve used both for some years, but I still find it really cool to see a summary like this, from someone who can actually do it for real.

Then it was me with back-to-back sessions. I brought my underwear, but forgot my pointer, so I had to borrow one from the mighty Maria Colgan. Thanks Maria! My first session was “Put your feet up and have a REST. Take a Tour of JSON Support in the Oracle Database”. The second was “It’s Raining Data! Oracle Databases in the Cloud”. Both sessions got a good crowd and I really enjoyed them. Judging by the reactions on Twitter some of the audience appreciated them too. 🙂

After my sessions I went to Gerald Venzl with “Supercharge Your Code to Get Optimal Database Performance”. He had the word Java on the title slide, but by his own admission it applied equally well to any programming language that interacts with a database. He discussed a number of things like the impact of commits, set processing, array processing and bind variables etc. For some of the points he did live demos to show the impact of getting it wrong. It’s exactly what you need every developer to hear before they are allowed to develop against a relational database. I think Gerald has spotted a gap in the market and is positioning himself as “The New Tom Kyte”, so from now on he will be known as Gerald Kyte… 🙂

Kamil Stawiarski with “Back to the basics: TABLESPACES… but a little bit low level style”. In this session he spoke about how different operations affect the contents of the datafiles on disk. Not the data you can query from SQL, but actually what is written (or not) to disk. He demoed it, by performing the operations in SQL and displaying the contents of the datafiles using a little C++ utility. It’s important for people to understand this stuff from a space-manangement perspective, but also from a security perspective. Just because you’ve deleted the row, it doesn’t mean you can’t read it from the datafile (assuming you are not using TDE) etc. 🙂

After the last session we got together for drinks. The queue was pretty big, so I went across the road and checked into my hotel, then came back and got a pint of Guinness. We headed off to the ACE Dinner at Rustic Stone, which was quite fancy. From there we moved across to a local bar and I was “forced” to have another Guinness. Then it was back to the hotel, where Christian “forced” us to eat rather expensive chocolate. I ended getting to bed really late. It was a really fun day at the conference and the evening. 🙂

Let’s see what tomorrow brings… 🙂

Cheers

Tim…

Author: Tim...

DBA, Developer, Author, Trainer.