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.
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.
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.
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.
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.
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.
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:
Across the street was another café, which – the assured us – a non Saku zone (Saku is the beer most sold in Estonia).
And with that we closed the evening.