Tusen takk til alle som hver og en bidro til året konferanse både som foredragsholder, deltaker og arrangør. Link til foredragene finner du her. Er det noen som mangler send melding til firstname.lastname@example.org så skal vi ta kontakt med foredragsholderen.
I slutten av mai arrangerte OUGN Bergen seminar hos TV2. Her kan du laste ned presentasjonene fra dette.
Eller du kan lese Guidebook på nettet her
Årets keynotes og litt til:
Andre “highlights” fra de parallelle faglige sesjoner:
Exadata Smart Scan Deep Dive
Oracle Security for DBAs and Developers
A 360-Degree View of Oracle Database Cloud Service
Connection Pool Concepts, and How to Size Them
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
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.
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.
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:
Trond Brenna – P99 Bli ekspert på Multitenant_scripts (ZIP-fil med script som ble gjennomgått live under presentasjonen)
All about Linux Memory usage by the Oracle Database by Frits Hoogland
Provisioning the Oracle Database in the Cloud by Frits Hoogland
Big Data and the multimodal database by Heli Heskyaho
The basics of Machine Learning by Heli Heskyaho
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.
Vårseminaret #OUGN18 til Kiel 8-10. mars! Del av din kunnskap og erfaring!
For innmelding av foredrag, logg deg inn på http://c4p.ougn.no.
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 email@example.com så tar vår programkomité dette videre.
Call for Papers for OUGN Spring Seminar March 8-10th 2018 is open.
Please submit yours at http://c4p.ougn.no/
Deadline for submissions are November 15th.
Her finner du foredragene fra #OUGN17
Er det noen du mangler send en epost til firstname.lastname@example.org så tar vi kontakt med foredragsholdere