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.