Vsebine na SIOUG 2017


jezik/language:language

Vrstni red vsebin na SIOUG 2017 je urejen po alfabetičnem vrstnem redu naslovov predavanj.

A Deep Dive into APEX JET Charts

Roel Hartman
Roel Hartman
APEX Consulting

 

Abstract

"In this session we will take a closer look on the options the new JET Charting engine brings to the APEX world. There are a quite a lot of declarative options to explore, but also the JavaScript API is worthwhile to investigate.

You will learn that with just a few lines of JavaScript you can change the look and feel of a chart to your own needs."

Application Express 5.1 and beyond ...

Carsten Czarski
Carsten Czarski
ORACLE Deutschland B.V. & Co KG

 

Abstract

"Application Express 5.1 is available since December 2016. Many users have already installed this new version which not only provides the new Interactive Grid or Oracle JET charts.

This presentation gives on overview on APEX 5.1 also highlighting the smaller features, which not everybody talks about. Beyond that the session will give a brief outlook on what's coming with future APEX releases."

Application Express and the REST of the world - Part 1

Carsten Czarski
Carsten Czarski
ORACLE Deutschland B.V. & Co KG

 

Abstract

"Learn how to access REST services from within Application Express. The presentation will show, how to invoke a REST Service, how to process JSON or XML responses and how to build reports or charts on top of this. Finally, attendees will get an outlook on future trends regarding APEX and REST.

In the old days, things were simple: Data was in the (Oracle) database and APEX applications worked with that data. But today, we have to integrate data from different sources all the time. These data sources can be on the internal network, but also on the internet.

Today, the REST architecture is commonly used to interface between different systems: REST services are often provided, so we want to use these REST services with the Oracle Database and APEX applications. The presentation will give a brief introduction to REST, cover the building blocks to invoke REST Services and to process the response and finally put everything together in Application Express."

Application Express and the REST of the world - Part 2

Carsten Czarski
Carsten Czarski
ORACLE Deutschland B.V. & Co KG

 

Abstract

"Learn how to access REST services from within Application Express. The presentation will show, how to invoke a REST Service, how to process JSON or XML responses and how to build reports or charts on top of this. Finally, attendees will get an outlook on future trends regarding APEX and REST.

In the old days, things were simple: Data was in the (Oracle) database and APEX applications worked with that data. But today, we have to integrate data from different sources all the time. These data sources can be on the internal network, but also on the internet.

Today, the REST architecture is commonly used to interface between different systems: REST services are often provided, so we want to use these REST services with the Oracle Database and APEX applications. The presentation will give a brief introduction to REST, cover the building blocks to invoke REST Services and to process the response and finally put everything together in Application Express."

Arhitektura Oracle in SQL Server podatkovnih zbirk iz vidika restavriranja podatkov

Urh Srenik
Urh Srečnik
Abakus plus d.o.o.

 

Abstract

V Abakusu kot Oracle DBA-ji večkrat naletimo na situacijo, da ima stranka več kot en tip podatkovne zbirke. V SQL svetu se kot konkurenca Oraclu najpogosteje pojavlja Microsoft SQL Server. Ker smo z našim produktom Deja Vu želeli zadostiti zahtevam strank, da bi na enoten način izvajali varnostno kopiranje različnih podatkovnih zbirk, smo letos za ta produkt razvili polno podporo tudi za SQL Server.

V letu dni, odkar smo začeli s tem projektom, smo se precej podrobno seznanili z razlikami in izzivi, ki jih različna tipa podatkovnih zbirk ponujata. Na predavanju bomo iz arhitekturnega in praktičnega vidika predstavil, kakšne te razlike so in kakšne prednosti prinaša eden ali drug.

Namen predavanja ni iskati boljše/slabše implementacije rdbms-ja. Namen je, da predvsem Oracle DBA-ji, ki imajo manj izkušenj z drugimi podatkovnimi zbirkami, dobijo vpogled v drugačen, še ne raziskan svet. Poleg tega bodo izkušenejši DBA-ji nedvomno dobili precej idej/vprašanj glede posledic, ki jih različne implementacije prinašajo. Te DBA-je po predavanju vabimo na pivo in nadaljnjo diskusijo.

Automate DBA Tasks With Ansible

Ivica Arsov

 

Abstract

Every time you find yourself doing the same thing over and over, have you asked your self: How can I automate this? Nowadays cloud vendors are a major driving force for automation in our industry.

This presentation focuses on the increasing role of automation and how it impacts the way Database Consultants and Administrator job is evolving. You will learn how you can decrease boring tasks and free up time for value-add work. We will take a detailed look at Ansible framework with which we can automate repetitive tasks.

Automating Oracle database administration, practical examples with Ansible

Ilmar Kerm
Ilmar Kerm
Kindred Group


Mikael Sandstrm
Mikael Sandström
Kindred Group

 

Abstract

As the demand for Continuous Delivery and Cloud Computing increases, so to does the repatative nature of DBA work. This is where automation can help you. One of the most popular Devops Tools for automation is Ansible. Ansible allows you to automate workflows using YAML an easy to use language, that can also serve as documentation.

This session is a practical "no-slides" hacking session where the presenters will implement basic DBA workflows using Ansible automation software. The presented examples will give the audience the necessary skills to get started with Ansible so that they can implement their own custom workflows.

AWR Warehouse: the Good, the Bad and the Ugly

Patrick Jolliffe
Patrick Jolliffe
Li & Fung Trading Ltd

 

Abstract

"In the presentation we will start with some a high level overview of the functionality provided and how it enhances the feature-set of Enterprise Manager. We will discuss the licensing advantages of offloading historical AWR data and processing into a separate database instance.

Then we will review how the ETL process is actually implemented, particularly the tables which store metadata for the extract and load portions. Build on that we will provide some ideas about how to troubleshoot when things don't work as expected, and how to workaround some of the limitations of the product."

Back to the basics: TABLESPACES… but a little bit low level style

Kamil Stawiarski
Kamil Stawiarski
ORA-600 | Database Whisperers

 

Abstract

"There are a lot of myths and legends about storing segments in tablespaces - should we keep indexes separated from the tables? Can we stop worrying about segment fragmentation? What is real difference between MOVE and SHRINK?

At this session I will present you my free C++ tool to visualize the contents of the datafile. We will disassemble a database block and try to understand how Oracle is really managing space inside tablespaces."

Backup z dodano vrednostjo

Boris Oblak
Boris Oblak
Abakus plus d.o.o.

 

Abstract

Dodana vrednost backupa je nič oziroma je celo negativna, saj za backup rabimo resurse (disk, trak, čas... ), torej predstavlja strošek. Ali lahko vrednost backupu povečamo?

Be a Hero with Your DBA: Database Performance Tuning for Admins and Architects

Randal Sagrillo
Randal Sagrillo
Oracle Corporation

 

Abstract

Be a hero with your DBA! Learn how to identify database key performance indicators, classify relevant workloads, and analyze AWR/STATSPACK reports to make meaningful recommendations for what is needed in your database system infrastructure to meet your performance service-level objectives. The methods discussed will apply equally to on-premises and cloud based infrastructure.

This technical session focuses principally on transactional and analytics workloads, with some discussion of data warehouse workloads.

Common Pitfalls in Complex Apps Performance Troubleshooting

 

Abstract

"Faced with a performance issue in complex systems people tend to look at things they find easy to get and interpret: CPU & IO usage, Load, Wait Events. The numbers may help in finding what is going wrong - *sometimes*, and hide the real issue easily.

This session is going to discuss simple things to remember while tackling performance issues in complex applications deployed in multiple tiers."

Deadlocks

Peter ampa
Peter Čampa
Četrta pot d.o.o.

 

Abstract

Predavanje bo na temo deadlock-ov. Pogledali si bomo, v katerih situacijah pride do deadlock-ov, kaj nam sporoča tracefile, ki ga generira deadlock in kako ga pravilno interpretirati. Na praktičnih primerih bomo prikazali, kako pridemo do deadlock-ov in kaj lahko naredimo, da do njih ne pride več.

Design your databases straight to the Cloud

Heli Helskyaho
Heli Helskyaho
Miracle Finland Oy

 

Abstract

"Everybody is talking about Cloud. How does the Cloud change my work as a database designer? What should I know and what new to learn?

In this session we will talk about these concerns and design a small database to the cloud using Oracle SQL Developer Data Modeler and Oracle SQL Developer."

dNFS for DBA's

 

Abstract

"Direct NFS is an Oracle implementation of the standard NFS protocol inside Oracle Database. Using this native solution Oracle instance is able to better handle IO traffic and bypass a kernel layer of operating system. dNFS is commonly used for Exadata backups into ZFS Appliance and for Oracle databases using a NFS based solutions (like NetApp or Delphix ).

The goal of this presentation is a show DBA’s what is a Direct NFS, how to configure, use and monitor it. Proper configuration and monitoring are important to achieve a maximum performance and easy problem diagnostic. There will be examples of configuration with and without direct NFS.

NFS protocol is based on the TCP/IP protocol and this presentation will also show a recommended configuration of the TCP stack and explain how network should be monitored."

Dobre prakse pri reševanju izzivov upravljanja identitet

Matja Premerl
Matjaž Premerl
Unistar LC d.o.o., Ljubljana

 

Abstract

"Pri upravljanju identitet je izbor avtoritativnega vira ključnega pomena. Na primeru dobre prakse na tehnični univerzi na Cipru, vam bomo z rešitvijo Oracle Identity Manager povedali, kako smo se lotili posameznih podatkovnih virov in kako smo jih postopoma vključevali v sistem upravljanja identitet.

Z rešitvijo sedaj tehnična univerza razpolaga z možnostjo upravljanja virov na centraliziran način in z vnaprej definiranimi pravili in tako končni uporabniki posameznih sistemov vedno razpolagajo samo z ustreznimi pravicami, kar bomo prikazali tudi na uporabniškem portalu z možnostjo pregleda in »nakupovanja« posameznih informacijskih virov, vključno z možnostjo potrjevanja zahtevkov, kjer se vključuje tudi rešitev Oracle SOA za potrebe določanja poslovnih pravil."

Docker for Dummies

Roel Hartman
Roel Hartman
APEX Consulting

 

Abstract

"You might (or might not) have heard of Docker. But you have no idea what it is and why you should care. But if you are a database or APEX developer and still work with Virtual Machines, it is about time to broaden your horizon.

In this session you'll learn what Docker is and how you can benefit from it in your daily work."

Efficient Test Data Management

 

Abstract

Testing is an important part of every development projects unfortunately there are still projects that are not doing it right. Based on my experience two of the most common problems are: size of data and data accuracy. If test with production like data sets are performed at the end of time deployment cycle, in the pre production phase, cost and time used for fixing potential bugs will much higher than if same errors were found at the beginning of the deployment cycle. Both problems mentioned above are typically related to an infrastructure and/or organization issues.

Modern software and hardware solutions can address typical problems of cloning full data sets and provide an easy and cost effective solution for data cloning. But cloning a production data for testing will create another serious issue with has to be addresses. It’s data confidentiality and potential access to a sensitive data for development and testing teams. This issue has to be addressed with a data masking solution so data can be anonymized before released into non-secure zones.

This presentation want to address a necessity of providing a proper data to developers and testing team in the fast and reliable way. In addition to that integration of data management with a common code control mechanism will be presented.

Ensure Performance Stability when Upgrading Databases

Mike Dietrich
Mike Dietrich
Oracle Corporation

 

Abstract

The biggest fear of DBAs upgrading or migration database is bad performance afterwards.

This presentation will guide you through a simple and straight forward approach to ensure performance stability when upgrading or migrating Oracle database from one release to another. It will also talk about know pitfalls and how to avoid them successfully.

Exadata on-premises or in the Cloud? The reasoning for our decision.

Heli Helskyaho
Heli Helskyaho
Miracle Finland Oy

 

Abstract

The current Exadatas are getting old and they must be replaced but with what? Better, cheaper, easier... which one to choose: physical Exadata or Exadata Cloud Machine?

There are so many challenges for a customer when making the decision. Demands from the own organization, demands from the officialauthoroties as well as the experience on the previous Exadatas.

From 0 to APEX - APEXify your Newbies

Dietmar Gabauer

 

Abstract

"Experienced APEX developers are rare on the market - let's educate some! This presentation gives an overview, how FOEX enlarged the development team.

What is APEX? What's needed in addition? SQL, PL/SQL, HTML, CSS, JavaScript......what else? How can this be trained? How do I phase-in a new, basic trained employees into running project work? Answers to these questions are out of our experience in phasing in new employees and employees having different knowledge."

Function Result Cache - Fixed.

 

Abstract

On troubleshooting a particularly Complicated PL/SQL-based system, a so-called thick-db system, we found that the Function-Result-Cache did not work as advertised. A Colleague found the cause, and devised an inventive Fix.

This presentation is must for developers struggling with over-complicated systems, and for the architects that design them. We can help you avoid some Mistakes.

Histograms are Evil like Chocolate is Evil

Neil Chandler
Neil Chandler
Chandler Systems

 

Abstract

Continuous Delivery is a topic that can become very complex in big environments - but starting with this subject is not that difficult as many may think.

Are you using Histograms? Yes, of course you are - even if you didn't know it. Did you want to use them? Are they helping you get to the optimal optimization plan, or making life harder for the optimizer? I will explain the benefits and threats associated with histograms, how the new 12.2 histogram types make them more acceptable, where they are still a threat and how I usually handle them for greatest benefit in large systems.

How to build the perfect dashboard

Pavel Glebov
Pavel Glebov
FRT Consulting GmbH

 

Abstract

Dashboards have become a standard business and operations tools. Unfortunately, many of them are overloaded and difficult in daily use.

This presentation covers high-level know-how to build focused, thoughtful, and user-friendly dashboards. Namely it includes base principles and graphical design, explanation of practical usage of APEX components, Charts, JET-technology, and Plugins. Also the approaches to modify Oracle DB, using both well-known and newest 12C features, to get answer almost in real-time are described.

Implementing incremental forever strategy for Oracle database backups

Ilmar Kerm
Ilmar Kerm
Kindred Group

 

Abstract

"When databases get ever larger and larger, backing them up using traditional RMAN backupsets will quickly get unfeasible. Completing a backup requires too much time and resources, but more importantly the same also applies to restores. RMAN has always provided a solution as incrementally updated image copies, but they are much less manageable than backupsets.

This presentation goes into detail on how to successfully implement incremental-forever database backup strategy together with a capable storage system like Netapp or ZFS Storage Appliance, and on how to build more advanced features on top that platform, like automation and cloning."

It's a Disaster! Making it better with FarSync and Fast Connect Failover

Neil Chandler
Neil Chandler
Chandler Systems

 

Abstract

"When sat in a meeting discussing Recovery Point Objectives and Recovery Time Objectives, the CIO will always say "No Downtime! No Data loss!"

What is the most effective way of approaching this hard-to-achieve goal? How did we minimise downtime and data loss?

This presentation shows how we reached the decision points for the application, which options were discarded and the final implementation of technology to approach the requirements.

And what simply was not possible without application re-engineering."

Izgradnja modernih aplikacij z uporabo API, mikrostoritev in klepetalnih robotov

Toma Potuvan
Tomaž Poštuvan
Oracle Software d.o.o.

 

Abstract

Časi, ko se je razvoj programske opreme štel v mesecih, pisanje popravkov pa v tednih, so minili. Nove verzije aplikacij se razvijajo in nameščajo večkrat na dan, včasih celo večkrat na uro. Arhitekturne zasnove teh aplikacij niso več monolitne, temveč temeljijo na mikrostoritvah ter enostavnih protokolih za komunikacijo med njimi. Razvijalci razvijajo moderne aplikacije, ki so dostopne uporabnikom preko različnih kanalov. Normalno je, da se uporabniška izkušnja ne menja, če namesto klasičnih računalnikov uporabimo kar svojo mobilno napravo, bodisi tablico bodisi kar pametni telefon.

Pristop »Najprej API« (API first), kjer najprej razvijemo programski vmesnik API, šele nato pa nad njim aplikacijo, postaja vedno bolj dominanten. Istočasno je tudi kritičen, saj združuje med seboj vse komponente sistema ter omogoča, da aplikacije, razvite za oblak (»Cloud native«), lažje dostopajo do podatkov in procesov. Služi tudi kot način komunikacije med razvijalci zalednih (back end) in čelnih (front end) aplikacij.

V predstavitvi si bomo ogledali, kako moderne aplikacijske platforme omogočajo razvijalcem, da enostavno gradijo ter povezujejo spletne ali mobilne aplikacije, le-te pa uporabljamo na različnih napravah."

Kakšno varnostno kopiranje potrebuje vaša podatkovna baza?

Primo Bedra
Primož Bedrač
Oracle Software d.o.o.

 

Abstract

Pristopov k varnostnemu kopiranju je Oracle podatkovne baze je veliko, kateri izmed njih je najbolj ustrezen pa vedno predstavlja svojevrsten izziv. Oracle kot proizvajalec podatkovne baze in strojne opreme ponuja tudi rešitve za njeno varnostno kopiranje. Kot proizvajalec podatkovne baze je Oracle v določeni prednosti, saj lahko ponudi tudi koncepte in tehnologije, ki jih ostali proizvajalci ne morejo. V zadnjem času se je obstoječim rešitvam pridružila še možnost varnostnega kopiranja v Oracle Cloud.

KEYNOTE: Oracle 12.2 Datatabase - novosti

Robert Koroec
Robert Korošec
Oracle Software d.o.o.

 

Abstract

Na verzijo Oracle 12.2 smo v Oracle ekosistemu čakali nekaj let in sedaj je čas, da si podrobneje pogledamo, katere novosti prinaša Oracle 12.2 primarno za Administratorje kot tudi tudi za razvijalce za čim boljšo izrabo vseh funkcionalnosti v Oracle 12.2

Little Red Riding Hood and GDPR : Who’s afraid of the big GDPR

Philippe Fierens
Pieter Van Puymbroeck
FCP EBVBA

 

Abstract

Wikipedia states :

The General Data Protection Regulation (GDPR) (Regulation (EU) 2016/679) is a regulation by which the European Parliament, the Council of the European Union and the European Commission intend to strengthen and unify data protection for all individuals within the European Union (EU). It also addresses the export of personal data outside the EU. The primary objectives of the GDPR are to give citizens and residents back control of their personal data and to simplify the regulatory environment for international business by unifying the regulation within the EU.

What does this mean for the Oracle DBA how can he help his company to be compliant with this regulation ? Which Oracle products can help you with this difficult task. This session will be a mix between practical experience and theory. Both speakers worked at a highly secured complex banking environment

Managing decisions in real time using Oracle Real Time Decisions

 

Abstract

Oracle Real-Time Decisions (RTD) is adaptive, real-time decision management solution, which uses a combination of your explicitly defined business rules and automatically identified statistical information to deliver the best possible content to your customers for every single interaction. Real-time analytics can be incorporated in any type of business process or customer interaction and provide the best offers and recommendations for each and every customer.

Moving traditional procurement process to the Cloud

Simon Jurecic
Simon Jurečič
OSIR-ERPIS, d.o.o.

 

Abstract

Typical procurement process, many would say „how complex could it be“. Company needs some goods or services, so just prepare RFQ, send it to potential suppliers and choose the „best one“. But the truth behind that proces is much more complex than that. Who are potential suppliers for some goods or services, do you know which suppliers are qualified to deliver some goods or services, based on what criteria will you decide which one is „the best“.Price and delivery term are just one part of the criteria. If your company is obligated to perform procurement according to public procurement prroces, every step of the process must be conducted according to strict law requiremtns. So, you need complete software solution which will support your complex business process, from collecting requirements, through preparation of negotiation and defining scoring criteria, to selection of best quote and placing an order or signing the contract. In our case, customer already had it all with on-premise solution. But can we advnace business even more? Customer already prepared the negotiation with all the requirements and scoring criteria. Let's publish the negotiation online, invite the suppliers and let them enter their quotations online. You can communicate with your suppliers online, or in case of Public Procurement, proces can be sealed so nobody will see the quote till negotiation is unsealed. Oracle Cloud Sourcing will give you all that possibilities, and at the same time, it will be fully intgrated with your existing on-premise solution.

One click to rule them all - Continuous Delivery for everyone in 45 minutes

Christian Klingbacher
Christian Klingbacher
Altran Concept Tech GmbH

 

Abstract

Continuous Delivery is a topic that can become very complex in big environments - but starting with this subject is not that difficult as many may think.

The purpose of this presentation is to show, how fast and easy APEX Applications can be deployed automatically to different environments with only one click. Using Git, Apache Maven, and Atlassians´ Bitbucket, it will be demonstrated how to setup and run a complete deployment pipeline by the creation of only two text files. Furthermore, it will be shown how any Docker image can be used and configured as basis for the deployment process.

Until the end of the presentation the attendees will receive a comprehensive step-by-step description of how to introduce and maintain their own Continuous Delivery for their APEX applications.

Oracle 12.2 funkcionalnosti za DWH & BI

Robert Koroec
Robert Korošec
Oracle Software d.o.o.

 

Abstract

"Opis in demosntracija Oracle 12.2 funkcionalnosti za DWH & BI:

  • Analytical Views.
  • In-Memory 12.2 (Join Groups, In-Memory Exspressions).
  • Attribute Clustering.
  • Integracija s Hadoop (BigData SQL).
  • Exadata (Columnar Flache Cache, Zone Maps, ...)."

Oracle 12c for Developers

Alex Nuijten
Alex Nuijten
all APEX

 

Abstract

"Do you want to get up to speed with the most current release of the Oracle database? Then this session is for you.

You will learn the most exciting and most useful new features from the Oracle Database 12c which can make your work as database developer a lot easier. There is more to the Oracle database 12c than just pluggable databases."

Oracle Analytic Cloud

iga Vaupot
Žiga Vaupot
Qubix Svetovanje


Mojca Gros
Mojca Gros
Qubix Svetovanje

 

Abstract

Oracle Analytic Cloud (OAC) je integrirana platforma za poslovno analitiko, ki vključuje ključna 3 orodja poslovne analitike: Oracle Business Intelligence Cloud Service, Oracle Data Visualisation Cloud Service in Essbase Cloud Service.

OAC je oblačna storitev, ki vključuje vse ključne funkcionalnosti orodij, ki se jih sicer lahko uporablja v "on-premise" različici, pri čemer pa je ključna lastnost, da je mogoče celotno rešitev iz "on-premise" okolja preseliti v oblak, kjer deluje praktično brez sprememb, če odmislimo ponastavitve povezav do baz podatkov. Je pa v vseh orodjih v oblaku opazen bistven premik k poenostavljenju določenih funkcij orodij tako, da so le ta postala enostavnejša in bolj prijazna za uporabo. Na ta način lahko že malo bolj napredni uporabniki izdelajo zahtevnejše rešitve, kar v "zemeljski različici" orodij ni mogoče.

Oracle Cloud - Safe from Hackers?

Michal Wypych
Michal Wypych
ORACLE Poland

 

Abstract

Comming soon.

Oracle Enterprise Metadata Management – comprehensive metadata management platform

 

Abstract

Trying to find an answer to a question which data is used by which application, can be a real challenge for number of companies, due to the proliferation of different IT technologies, tools, applications and systems that companies have in place. So, tracking the data to its source, i.e. performing impact analysis is many times very difficult exercise even for a trained IT personnel, and mission impossible for business users.

Oracle Enterprise Metadata Management (OEMM) is here to help. OEMM is a comprehensive metadata management platform, which can "harvest", i.e. reverse engineer and catalog metadata from virtually any metadata provider, including relational, Hadoop, ETL, BI, data modeling, and number of others.

Oracle Innovation Management Cloud Service @ Addiko Bank BiH

unknown user
Nihad Velagić
Core d.o.o. & Addiko Banka (BIH)


unknown user
Adi Hadžiosmanović
Core d.o.o. & Addiko Banka (BIH)

 

Abstract

Predstavitev primera implementacije Oracle rešitve v oblaku in koncepta uporabe produkta Innovation Management Cloud, ki je del PLM (Product Lifecycle Innovation) Clouda, v Addiko Banki (BiH). Predstavljena bo rešitev v oblaku, ki omogoča zajem, obdelavo in analizo idej, katere iniciator je lahko vsak zaposleni, ter njeno dejansko uresničitev in spremljanje skozi celoten življenjski cikel. Prikazan bo koncept uporabe produkta v Addiko banki, katere poslovanje temelji na ponujanju storitev.

Oracle Next Generation Cloud Infrastructure Platform

Uro Beoanin
Uroš Beočanin
Oracle Software d.o.o.

 

Abstract

Oracle’s next generation cloud infrastructure platform brings together best practices and learnings from nearly a decade of public cloud IaaS. The combination of virtualized network, mix of bare metal and VMs, interoperable infrastructure stack in public cloud or cloud at customer, all together with advanced governance and management capabilities, brings to market a highly competitive public cloud IaaS option for the enterprise market.

We will present Oracle cloud infrastructure platform from technical and customer use-case point of view.

PaaS4SaaS demo case

Michal Wypych
Michal Wypych
ORACLE Poland

 

Abstract

This presentation will guide through extensibility of the functionality in Innovation Management using Mobile Cloud Service. This live workshop of the application development will give step by step instruction how to create the mobile application. Using online integration with Innovation Management, the solution will be shown in action.

Pimp my grid

Marko Goriki
Marko Gorički
BiLog d.o.o.

 

Abstract

We all waited a long time for "the grid" feature. Now when it's finally there it's time to use it in your projects. Is it ready for this?!

In this presentation I'll talk about my experience with the first project where I've used Interactive grid and I'll try to dig a bit deeper to show you some of the advanced features.

Regular Expressions: Say What?

Alex Nuijten
Alex Nuijten
all APEX

 

Abstract

"It has been possible since Oracle database release 10, Regular Expression support with its own set of functions. But getting started with Regular Expressions is not easy. Most database developers would avoid them if at all possible. With current release of the Oracle database, Regular Expression syntax becomes more important. You can use them to redact data with DBMS_REDACT and to search for patterns using the Match_Recognize clause.

This session covers the basic syntax and gives you an easy introduction with Regular Expressions with plenty of code samples."

Revizijska sled z Flashback Data Archive

Sunil Jayasinghe
Sunil Jayasinghe
Nova KBM d.d.

 

Abstract

"Predavanje o zelo aktualni temi hrambe in sledenju spremembam v bazi podatkov. Ena od obveznosti finančnih institucij (in tudi drugih) je hramba pomembnih podatkov ter zagotavljanje takoimenovane revizijske sledi. Flashback Data Archive (FDA) funkcionalnost baze 11g omogoča samodejno shrambo vseh sprememb na izbranih tabelah za daljše časovno obdobje. Vse to se dogaja v ozadju brez intervecije s strani uporabnikov ali aplikacij. Arhivski podatki so dostopni z navadnimi SQL ukazi. Z uporabo FDA dokumentiramo zapisovanje in spreminjanje zapisov v celotni življenjski dobi revizijske sledi, od izvornega zapisa do trenutno veljavnega zapisa. Iz revizijske sledi je razvidno, kakšna operacija je bila izvedena nad posameznim zapisom, s katerimi podatki in kdaj. Od Oracle verzije 12g pa dodatno še podatek o tem, kdo je spremembo izvedel .

Na predavanju bomo predstavili:

  • opis tradicionalne in najpogostejše metode sledenju spremembam z uporabo triggerjev v bazi,
  • predstavitev napredne metode z uporabo FDA,
  • konfiguracija in vklop FDA,
  • primer uprabe FDA,
  • prednosti/slabosti obeh metod,
  • kompresija zgodovinskih tabel (vrstic, LOB polj, deduplikacija LOB polj),
  • izvoz/uvoz zgodovinskih tabel."

So, my query plan says "Table Access Full" - what happens next?

 

Abstract

For some reports the fastest way to get them done is to use an index to go straight to the rows of interest, but sometimes the only way that makes sense is to scan the entire table. I'm the Oracle Architect for Smart Scan and the engineer in Oracle co-responsible for the table scan driver and this talk will show what happens under the covers in simple easy to understand steps.

We will look at (1) what is a granule in PQ (2) how exactly does the system decided whether to use buffer cache to direct read, (3) how is physical I/O done including Multi-Block reads and Async-I/O (4) what wait events and stats to look at (5) what tuning options are available to the DBA, and (6) for the truly curious how to trace what is happening.

SSD in Oracle

Sergej Roman
Sergej Rožman
Abakus plus d.o.o.

 

Abstract

Približno 10 let se v podjetju Abakus plus že srečujemo s SSD diski, ko smo v enem od poznanih podjetij nanje prvič namestili Oracle zbirko podatkov. O SSD diskih se je od takrat nabralo ogromno izkušenj. Začetni vtisi so bili zelo navdušujoči, sčasoma pa so se pokazale tudi nekatere slabosti.

Največja prednost uporabe SSD diskov je, da zbirkam podatkov zagotovijo neverjeten pospešek. Tudi cena je že zelo sprejemljiva. Slabosti naj zaenkrat ostanejo skrivnost in jih bomo razkrili na predstavitvi. Predstavili bomo tudi nekaj dobrih praks, s katerimi se težavam lahko vnaprej izognemo.

V splošnem pozitivne izkušnje prevladujejo nad slabostmi in danes SSD diske uporabljamo praktično povsod. Nedavno smo s SSD diski v infiniband SAN diskovnem sistemu lastne proizvodnje dosegli nove rekordne rezultate. Paket iz zbirke podatkov dbms_resource_manager.calibrate_io je pokazal pretočno hitrost prek 3 GB/s in 150.000 IO operacij na sekundo pri zakasnitvi 0 ms.

The journey of a BI database stack to the cloud

 

Abstract

"BI is and can be a complex matter in big organisations. This presentation will tell the story about a strategic business decision to move the on premise BI stack to the Microsoft Azure cloud. The main focus is on how the Oracle Database is moved as the application servers were moved using a lift and ship mechanism.

This presentation will cover: - how we managed to move +300TB divided over several multi Tb databases to the cloud, - which services were chosen to run the database servers and why, - how performance testing and sizing has been done - how automatic provisioning has been done for providing developers what they need in agreed SLA's, - how we dealed with the short deadline, - why the Azure Cloud was chosen over the Oracle cloud, - Cost savings?

The deadline of the project was end of the year 2016. This gives the opportunity to give you an insight in a very fresh project of the move to the cloud for a complete BI environment."

The new Oracle Release and Update Model

Mike Dietrich
Mike Dietrich
Oracle Corporation

 

Abstract

As of July 2017 Oracle changed its release and update model for the Oracle Database. But not even the release numbering changes, the entire schedule and naming for patches, BPs and PSU changes as well.

This presentation will shed some light on the new release and update model including recommendations for patches and how to find the most important patches for your environment.

Top 10 Features of Oracle SQL Developer everybody should use, even in the Cloud

Heli Helskyaho
Heli Helskyaho
Miracle Finland Oy

 

Abstract

"Oracle SQL Developer is a tool every Oracle user should be using. In Oracle SQL Developer there are excellent features that will make your life easier, does not matter if you are a dba, a developer or a database designer.

There is plenty of great features for everybody, Learn about my favourite features that will hopefully make your life easier too and make you a more profitable member of your IT team.

All the demos in this session are performed in the Oracle Cloud."

Upgrade to Oracle Database 12.2 - Live and Uncensored

Mike Dietrich
Mike Dietrich
Oracle Corporation

 

Abstract

Upgrading a database works fine on Powerpoint. But how about a real upgrade?

This presentation will introduce the news around Database Upgrade to Oracle Database 12.2 including the new preupgrade.jar. And the upgrade will be demonstrated live and interactively, on the command line and graphically with the DBUA.

Utilizing the data attribute: Client-side behavior in APEX

Richard Martens
Richard Martens
Smart4solutions BV

 

Abstract

"Creating an APEX application is easy, just follow the wizards to create all those reports and forms. But what if you want to add some client functionality like deleting a record using a form, or do some 'drag-n-drop' ordering of records.

The presentation will show you how to add client side and AJAX functionality to your apps."

 

Pokrovitelji


Veliki pokrovitelji:

Abakus

 

Mali pokrovitelji:

 

logo high resolution