Programmet for Vårseminaret 2018

Programmet til årets Vårseminar er nå lagt ut på Guidebook

Last ned Guidebook på din telefon eller nettbrett (Android / iOS) og søk etter “OUGN” da finner du “OUGN Spring Seminar 2018” som du kan laste ned og ha på din telefon under hele turen.

Eller du kan lese Guidebook på nettet her

og er er noen teasere:

Årets keynotes og litt til:

 Hans Olav Hamran, VP Technology Oracle Nordic, gir oss ett innblikk i hvordan Oracle ser på fremtiden? Digitaliseringens myter
med Anette Grande Urhamar, CEO for KnowIT Experience i Oslo. Erfaren foredragsholder, mentor og rådgiver.
Blockchain and Oracle?
med Luis Campos, Director Data Management Cloud, Oracle EMEA

Andre “highlights” fra de parallelle faglige sesjoner:

Uwe Hesse
Exadata Smart Scan Deep Dive
Daniel Morgan
Oracle Security for DBAs and Developers
Sai Janakiram
A 360-Degree View of Oracle Database Cloud Service
Toon Koppelaars
Connection Pool Concepts, and How to Size Them
Ricardo Gonzalez
Test and Development Environments provisioning with Oracle ACFS
Simon Haslam
Traditional Oracle Professionals: let’s talk about REST!
Maarten Smeets
Microservices on Application Container Cloud Service
Robert Marz
Automatically deploy schema changes with Ansible and Liquibase
Gianni Ceresa
Pimp your DevOps with Docker: an Oracle BA Example
GDPR & You: The Nightmare of Business Analytic (but Graphs DB Will Save You)
Christen Seeberg
Analytics & Big Data Data Discovery and Visualization on Machine Learning steroids
Magnus Fagertun 
What did Hadoop ever do for us?
Gurcan Orhan
How to solve complex business requirements with Oracle Data Integrator?
Pål Børseth-Hansen
Oracle og maskinlæring


Bryn Llewelyn master class on EBR

Arrangement sted: Scandic Bergen City, Håkonsgaten 2-7

It is our pleasure to welcome Bryn Llewellyn to Bergen. He will give us a one day EBR training on his Scandinavian EBR-tour:

Tuesday, November 28, 2017  –  8:30 AM to 5:00 PM

The seminar in itself is free of charge. Thanks Oracle!
OUGN will only charge for facilitating the event. NOK 200

Register here!

This is a training that at Oracle University would be billed as a master class with a much higher cost than an ordinary course. Being able to attend this is training at a quality you seldom get and getting it for free makes it one of the best training opportunities for Oracle specialists this year.

EBR as defined by Oracle:
Edition-based redefinition (EBR), enables online application upgrade with uninterrupted availability of the application. When the installation of an upgrade is complete, the pre-upgrade application and the post-upgrade application are able to be used at the same time. Therefore an existing session can continue to use the pre-upgrade application until its user decides to end it; and all new sessions can use the post-upgrade application. When there are no longer any sessions using the pre-upgrade application, it can be retired. When used in this manner, EBR enables hot rollover from the pre-upgrade version to the post-upgrade version, with zero downtime.

Background to Bryns mastery in EBR:
Bryn was part of the team that did the requirements analysis for EBR and that went on to do the conceptual design. He has been the Product Manager for EBR since before the GA of Oracle Database version 11.2 was announced at OpenWorld 2009. (This is the version that brought EBR.) He continues to participate in conceptual design work with each new database release. Bryn has presented on EBR an uncountable number of times, both at conferences and in web presentations for customers. He has advised many customers about their adoption and deployment of EBR.

As you can see, Bryn is THE person to teach you about this technology!

In general, patching or upgrading the artifacts in an Oracle Database that implement an application’s back end involves changing two or more functionally dependent objects. Because each DDL auto commits, such changes inevitably imply that the system is mutually inconsistent once the patching begins and that its integrity is regained only when patching completes. Before EBR, your only option, therefore, was to take downtime. EBR allows you to create a semantic copy of the live system within the same database so that you can make your changes to that while the live system remains in uninterruped use. Of course, the quota-consuming data must be mutually synchronized, transactionally. EBR supports this too. This workshop explains how it all works.

What you can expect:
You will appreciate the conceptual and practical challenges that any technology that aims to support zero-downtime application patching must meet. You will understand how EBR meets these challenges. And you will realize that no other conceivable approach could meet these. You will gain a deep understanding of EBR’s key features: the edition, the editioning view, and the cross edition trigger. The workshop will prioritize giving you a robust mental model so that you will be able confidently to design how you will adopt EBR in your database and then implement EBR exercises to meet your zero-downtime patching requirements. You will be shown the SQL statements and PL/SQL subprogram calls that you need in sufficient detail to make your new understanding concrete and immediately usable.

Format of the training:
The format will be upfront teaching using ordinary slides and on-the-fly Q&A. You will see various SQL*Plus demos and discuss code. But you will not need to bring laptops to do your own hands-on work. After the event, you will be able to download, from the Oracle Database PL/SQL and EBR blog, a carefully written whitepaper, current as of Oracle Database version 12.2, that covers all of the workshop’s content—and more—in detail. And all the code that you see will be published there too.

About Bryn:
Bryn Llewellyn Distinguished Product Manager Database Server Technologies, Oracle HQ

Bryn Llewellyn has worked in the software field for more than thirty-five years. He joined Oracle UK in 1990 at the European Development Center to work on the Oracle Designer team. He transferred to the Oracle Text team and then into consulting as the text specialist for Europe. He relocated to Redwood Shores in 1996 to join the Oracle Text Technical Marketing Group. He has been the product manager for PL/SQL since 2001. In 2005, he became responsible, additionally, for edition-based redefinition (EBR for short). This is the Oracle Database capability that supports online application upgrade. It’s hard for Bryn to remember his life before Oracle. He started off doing image analysis and pattern recognition at Oxford University (programming in FORTRAN) and then worked in Oslo, first at the Norwegian Computing Center and then in a startup. In Norway, Bryn programmed in Simula (its inventors were his close colleagues). This language is recognized as the first object-oriented programming language and was the inspiration for Smalltalk and C++.

Bryn is an Oak Table member.

Presentasjoner fra OTN Nordic Tour 2017

OUGN arrangerte OTN Nordic Tour onsdag 25. oktober 2017 på Felix Konferansesenter, Aker Brygge i Oslo. Omlag 40 deltakere fikk med seg en rekke gode sesjoner med dyktige foredragsholdere. Her er presentasjonene som ble holdt:

Bjarte Brant – Container Technology

Frits Hoogland – Linux memory explained

Frits Hoogland – Provisioning the clouds

Heli Helskyaho – Big Data And Multi model db

Heli Helskyaho – Design Your Databases Straight To The Cloud

Lasse Jenssen – Many roads to Rome

Lasse Jenssen – Case Study: PLSQL TRAIN MIGRATION

Trond Brenna – Multitenant 12.2 v1.0

Trond Brenna – P99 Bli ekspert på Multitenant_scripts (ZIP-fil med script som ble gjennomgått live under presentasjonen)

Vidar Eidissen – GDPR – Hvordan få jobben gjort?

Øyvind Isene – Open Data and XE

Øyvind Isene – Visual Data In APEX


OTN Nordic Tour 2017








Oracle User Group Norway har gleden av å invitere til høstens faste fagkonferanse 

OTN Nordic Tour

Onsdag 25. oktober 2017
Felix konferansesenter, Aker Brygge, Oslo
Kl. 08:30 – 16:00 (pluss mingling)

Pris: NOK 1500,-

Påmelding her!

Vil du lære fra noen av de beste?
Oracle har et program for utnevnelse av ACE Directors hvor teknisk kyndighet og fremragende innsats som foredragsholder, blogging etc er en del av kriteriene.
OUGN har nå gleden av å ha noen av disse som foredragsholdere under OTN (ACE) turnèen. I tillegg får også vi besøk av kjente lokale Oracle-guruer.

Fokus er rettet mot Core Database og DB Development, og i år, er våre foredragsholdere:

  • Heli Helskyaho, Fritz Hoogland, Øyvind Isene, Lasse Jensen, Vidar Eidissen, Trond Brenna og Bjarte Brandt

Meld deg på og lær fra noen av de beste i verden!

Påmelding her!


All about Linux Memory usage by the Oracle Database by Frits Hoogland

Frits Hoogland is an IT professional specializing in Oracle database performance and internals. Frits frequently presents on Oracle technical topics at conferences around the world. In 2009 he received an Oracle ACE award from the Oracle Technology Network and a year later became an Oracle ACE Director. In 2010 he joined the OakTable Network. In addition to developing his Oracle expertise, Frits works with modern operating systems. Frits currently works at the Accenture Enkitec group.
Memory usage of a virtual memory systems like linux always have been shrouded in mystery, with admins setting parameters by best practice rather than based on measurable facts specific for that machine and workload. This presentation explains how memory is allocated and used on Linux (and when it isn’t!), after which different database memory scenario’s are replayed on a virtual machine showing how memory allocations behave. Because of the delayed allocation, oversubscription of memory will in most cases not become visible at database startup time, but rather after running for some time, depending on memory need, which can be minutes, but also very easily after a few days. Without awareness of linux memory allocation strategies, oversubscription indicators like sudden swapping will seem to happen random. The gist if the talk is not Oracle database specific, however, it will use Oracle database scenario’s.

Provisioning the Oracle Database in the Cloud by Frits Hoogland

Installing the Oracle database at massive (cloud) scale requires automation. This talk focusses on automation, local and remote/cloud. It shows how to build a VM, install the oracle database software and then patch it, after which a tarball is created from it to do a clone install. In 45 minutes.
This presentation provides a walkthrough on provisioning a full Oracle database software install using Ansible. The presentation also touches on automating local virtual machine provisioning for test and development using vagrant. Full not only means it is showing how to get Oracle installed, but also fully patched to the latest PSU. It goes beyond concepts and shows actual execution of deployment, step by step, via live demo’s. In today’s world, repetitive tasks like installing a database should be automated and not done manually using expensive administrative hours. Maybe even the most important aspect (more important than expensive hours being used) is that manual installations are guaranteed to have inconsistencies, which will make administration (and further automation) hard. This is a must see session for anyone who is serious about using Oracle databases at scale (which could be cloud)!

Big Data and the multimodal database by Heli Heskyaho

Heli Helskyaho is the CEO for Miracle Finland Oy and an Ambassador for EOUC (EMEA Oracle Users Group Community). Heli holds a Master’s degree (Computer Science) in the University of Helsinki and she is specialized on databases. At the moment she is working on her doctoral studies, researching and teaching at the University of Helsinki. Her research areas cover Big Data, multi-model databases, schema discovery and methods and tools for utilizing semi-structured data for decision making. Heli has been working on IT since 1990. She has been in several positions but every role has always included databases and database designing. Heli believes that good database design and good documentation reduces performance problems and makes solving them easier. Heli is an Oracle ACE Director and a frequent speaker in many conferences. She is the author of Oracle SQL Developer Data Modeler for Database Design Mastery (Oracle Press 2015) and a co-author of Real World SQL and PL/SQL: Advice from the Experts (Oracle Press 2016).
Multi-model database is a database that stores several data models in one single database allowing the user to query the data using one single query language and joining all data of different data models together. What is this multi-model database and how close is Oracle database to be one?
Gartner showing in their report, Top 10 Strategic Technology Trends for 2017, interesting things like Artificial Intelligence and Advanced Machine Learning, Intelligent Apps, Intelligent Things and Conversational Systems. All this added to the buzz on Big Data, the business people realize that data, in all forms and sizes, is critical for making the best possible decisions to win the competition over customers. According to Gartner (Magic Quadrant for Data Warehouse and Data Management Solutions for Analytics 2016), “Organizations now require data management solutions for analytics that are capable of managing and processing internal and external data of diverse types in diverse formats, in combination with data from traditional internal sources. Data may even include interaction and observational data — from Internet of Things sensors, for example. This requirement is placing new demands on software in this market as customers are looking for features and functions that represent a significant augmentation of existing enterprise data warehouse strategies.” These needs give a lot of pressure for the technology. One of the problems recognized is the different data models for different types of data but even more problematic is finding a single query language to query all the different data. Usually the user needs several query languages to query from different sources and then a query language to somehow join the data together to get sense of it. One of the solutions is multi-model database. That is a database that stores several data models in one single database allowing the user to query the data using one single query language and joining all data of different data models together. What is this multi-model database and how close is Oracle database to be one? In this session we will talk about the different data models and how well Oracle Database 12.2. supports them.

The basics of Machine Learning by Heli Heskyaho

What is Machine Learning and why should I care? In this session we will talk about the basic concepts of Machine Learning.
What is Machine Learning and why should I care? In this session we will talk about the basic concepts of Machine Learning: Features, Instances, Binary classification, Scoring and Ranking, and beyond. There are different models used in Machine Learning: logical, geometrical, grouping, probabilistic models, and model ensembles. We will talk about those models and learn a little bit more about Concept learning, Tree models, Rule models, Linear models, Distance-based models, and probabilistic models. After we have learn the basics of the models used in Machine Learning we will talk about Experiments in Machine Learning: what to measure, how to measure, and how to interpret the results. And in the end of the session we will take a look to the future: What’s next?

Use APEX to Visualize Spatial Data by Øyvind Isene

Developing applications in Oracle Applications Express is easy compared to many alternatives. Showing data on maps is getting very popular now as the amount of mobile data is increasing every year. This practical presentation will show you how you can use the Oracle database to store and analyse spatial data and visualise them using APEX. One of the goals in this presentation is to show you how you can present data on maps using APEX, including your own beer data.

Having Fun with Open Data and Oracle XE by Øyvind Isene

There are a lot of open data sets on the Internet meant to be analyzed by people interested in data science, big data and who knows what. The fact is that many of these data sets are not really that big and can easily be imported into Oracle XE. This presentation will show you how you can have fun with SQL Developer, the SQL language and many of the rich functions in the Oracle database in order to discover new insight and become a better analyst. This presentation is for DBAs who needs to fresh up their knowledge on SQL, and for beginners who would like to have some fun with the database.

Case Study: Using PL/SQL and SQL features to meet timing requirements in migration project by Lasse Jenssen

This presentation shows how you could combine different PL/SQL and SQL features to meet project requirement, both functional and performance vice. The first version was killed after running for a couple days in test. How did we make this code finish in a couple of hours?

Several road which leads to Rome – also regarding performance by Lasse Jenssen

This presentation dive into several ways to work with performance. On one side, you have the Millsap or Method-R – just trace it. But there are also other ways that can help you diagnose performance issues or assist in tuning tasks. This presentation take a peek into alternative ways to look at performance, and when the different methods are suitable.

Multitenant by Trond Brenna

Med lanseringen av 12.2 av databasen har Oracle lagt til en mengde ny muligheter med Mulitenant. Denne sesjonen vil gå gjennom de viktige nyhetene og vise eksempler på hvordan dette kan utnyttes. Nyhetene er f.eks hot-cloning, refresh-clone, relocate PDB og Application container.

Autonomous Database by Trond Brenna

På Oracle Open World som ble nylig arrangert i San Francisco lanserte Larry Ellison siste innovasjon innen database teknologi – en Autonomous database. Denne sesjonen vil prøve å vise hva som ligger bak dette og hvilke teknologier benyttes for å kunne lage en selvgående database

Container technology. Let’s dive into the world of docker and kubernetes by Bjarte Brandt

If you haven’t been introduced to container technology yet, this will be the session for you! Docker will be explained where a demo of an Oracle Database in a container will be presented. What is the difference between an image and a container? Where are my datafiles? Container technology really starts to shine when we add some orchestration tool to it! A demo of an application deployment running through all the steps: git commit, build image, register image, deploy container to kubernetes cluster will be presented.      



Call for Papers til Vårseminaret 2018 – Frist 15/11

Vårseminaret #OUGN18 til Kiel 8-10. mars! Del av din kunnskap og erfaring! 

For innmelding av foredrag, logg deg inn på

Dette er en ypperlig anledning til å vise hva du/dere har jobbet med det siste året.

  • Er det noe dere er spesielt fornøyd med? Hvorfor ikke dele med andre Oracle-brukere?
  • Kanskje kunne du tenke deg å vise frem, og få tilbakemelding på, spennende ideer du sitter inne med eller tips/triks for å løse kjente/ukjente problemstillinger.

Du er velkommen til å holde foredraget sammen med f.eks en kunde eller en kollega.

Vi ønsker oss flere norske foredragsholdere, og gjerne kundehistorier. Frist for innmelding er 15. november

Har du innspill til andre foredragsholdere og tema kan du også sende en email til så tar vår programkomité dette videre.


Call for Papers for OUGN Spring Seminar March 8-10th 2018 is open.
Please submit yours at

Deadline for submissions are November 15th.