Harmony 2015, day 2

The day started off with a keynote by Radu Parvua and Tarmo Alasoo from Accenture. Tarmo used to work at Enkitec and Enkitec is now part of Accenture. Radu told us that Accenture now almost has all the engineered systems from Oracle, except one.

Keynote from Accenture.

Keynote from Accenture.

Bryn Llewelyn showed us how PL/SQL can sometimes be faster than just SQL, which might go in against the usual advice that when you can do it with SQL, then do it with SQL. Graham Wood was also in the room, so he could immediately comment on this.

Bryn Llewelyn talking about table transformations with PL/SQL.

Bryn Llewelyn talking about table transformations with PL/SQL.

Luis Marques talked about an underestimated feature: the Resource Manager. It was a difficult topic, but I have worked with Resource Manager, so it wasn’t so hard for me. You use Resource Manager to assign resources (on non-Exadata only CPU, on Exadata also I/O (which is terrific news BTW, but that’s just my opinion)).

Luis showed what happens if you suspend the VKRM process, responsible for scheduling processes on the CPU queue. The processes will be waiting eternally on the CPU queue. When Luis disabled DBRM, the OS run queue increases (visible in vmstat) as soon as the number of sessions increase.

Luis created a Python script to investigate Resource Manager’s behaviour even further. You can download his script to test your own Resource Manager plan allocation. A very useful thing I learned on this session is how I can calculate the time spend on the OS run queue with AWR.

Luis Marques does some math.

Mathematical formula’s on Harmony 2015. Luis Marques shows what it means.

The last session I followed, was a session on APEX and ORDS by Øyvind Isene. APEX is often seen as a insecure platform, but Øyvind showed how Oracle REST Data Services (ORDS) can make this more secure. And it is actually not that hard to use.

Don’t forget to disable the development on production BTW and when you connect the application as a non-schema owner, so you separate code and data, you’re set to go.

 

Farewell

There was one short farewell session where we applauded the organization. They have done an outstanding job.

 

Actually, I’m staying

Not all of us went back home immediately after the conference. So Ilmar asked us if we would like to go for a crafts beer tour. So we turned up and went to a formerly industrial area of Tallinn, where now artists and other creative people live. You know, hipsters.

A view back on Toompea, the highest part of town.

A view back on Toompea, the highest part of town.

First we started at a beershop with a wide selection of Estonian beers. I had citra beer with a citrus-like aroma. It was good. Philip uncorked Saison, an ale, and served us all a drink.

Bryn discusses the topic of his presentation again with Graham.

Bryn discusses the topic of his presentation again with Graham.

Graham is a great guy to go for drinks with. You should invite him :)

Graham is a great guy to go for drinks with. You should invite him 🙂

When Øyvind isn't tweeting you can actually have a good conversation with him. (I'm pulling your leg, Øyvind)

When Øyvind isn’t tweeting, you can actually have a good conversation with him. (I’m pulling your leg, Øyvind)

By now we were getting rather hungry. With this high sun in the evenings, you sometimes think it’s only late afternoon, but your stomach will convince you otherwise at some point. So we went to this place and had herring (as far as I remember) on black bread with egg benedict on top as a starter:

Bistro Baar

Bistro Baar

Across the street was another café, which – the assured us – a non Saku zone (Saku is the beer most sold in Estonia).

Graham, Bryn, Philip and Øyvind

Graham, Bryn, Philip and Øyvind

A helpful flow diagram.

A helpful flow diagram.

A beautiful mural.

A beautiful mural. Lendav Taldrik means Flying Saucer BTW.

And with that we closed the evening.

Advertisements

About Marcel-Jan Krijgsman

Ever since I started working with Oracle, I had an interest in Oracle database performance tuning. This led, eventually, to a four day training I made and gave for customers of Transfer Solutions. Since 2012 I work for Rabobank Nederland. A few years ago I also became interested in Oracle database security. All technology aside, it is my experience that security usually plays out on a political level. I'm a Oracle certified professional for the 8i, 9i, 10g and 11g databases and Oracle Database 11g Performance Tuning Certified Expert.
This entry was posted in Conferences and tagged , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s