Petek, 2. junij (26)

Petek, 2. junij

Seznam predavanj se še dopolnjuje, vabimo vas k spremljanju.

07:30 am - 09:00 am Registracija

9:00 - 9:45
(Single) Table Recovery

(Single) Table Recovery

Every DBA should know this situation. You receive a call from a user or customer. After executing a wrong command, for example, a DELETE without a correct WHERE clause or a script against the production database instead of the test database, the data of one or more tables have now a wrong state.

A rollback can solve this problem quickly, but what are the options when the transaction is already committed? In this presentation, I will explain possible ways to restore the state of a single table.

  • Flashback Query/Table/Transaction
  • Table Recovery using RMAN
  • Export/Import
  • LogMiner"
Speaker:
Christian Gohmann
Podjetje
Trivadis - Part of Accenture
14:50 - 15:35
Agilen razvoj spletnih aplikacij

Agilen razvoj spletnih aplikacij

Na Zavodu za pokojninsko in invalidsko zavarovanje se za razvoj informacijskih rešitev uporabljajo tehnologije JAVA, BPM in RASD.

Na konferenci bi predstavili uporabo RASD platforme za izdelavo spletnih aplikacij in REST servisov, ki ga na Zavodu uporabljamo. RASD (Rapid Application Service Development) je razvojna platforma, ki omogoča hiter in enostaven razvoj HTML5 spletnih aplikacij in REST servisov na ORACLE baznem okolju. Ker je orodje enostavno za uporabo lahko v RASDju razvijajo uporabniki z različnim nivojem znanja programiranja (low/no code programming).

Na kratko bi opisali zahteve za namestitev in potek namestitve, integracijo z Git in vpeljavo DevOps metodologije za avtomatsko nameščanje, večji del predavanja pa bi namenili samemu orodju za razvoj aplikacij in servisov, opisu funkcionalnosti, generiranju kode, poteku izvedbe in končni uporabnosti. Predstavili bi tudi enostaven testni primer izdelave aplikacije.

9:00 - 9:45
CI/CD of relational databases

CI/CD of relational databases

Continuous Integration and Delivery (CI/CD) for database applications is becoming more common. Many projects create CI/CD pipelines to make their work easier and improve integration and deployment quality. Many tools promise a comprehensive solution for implementing database CI/CD and solving all kinds of problems. But what is known about database CI/CD from a scientific point of view? What elements are necessary for efficient and effective CI/CD? What improves team performance and reduces the risk of releases? This talk will present the latest data from a database CI/CD research project and examples of database CI/CD pipelines.

Speaker:
Jasmin Fluri
Podjetje
Schaltstelle GmbH
11:55 - 12:40
Enemy of the Session State

Enemy of the Session State

This session will cover mistakes that are easily made - even by experienced developers - regarding the (mis)use of APEX Session State, database session contexts and caching. Hopefully this will prevent you to fall in a similar pitfall and stop you from being an enemy of the session state!

Speaker:
Roel Hartman
Podjetje
APEX Consulting
13:50 - 14:35
Is your database backup recoverable?

Is your database backup recoverable?

While concerns about new applications, end-user satisfaction, and the costs of IT all rightly get lots of press and IT attention, those concerns vary across businesses and fluctuate over time. Yet there are two constant headaches for all IT organizations: data loss and data recovery. Let’s face it, everything else in IT is replaceable. Data, if lost, cannot be replaced. Furthermore, when looked at in light of today’s demands and expectations of IT, the definition of “lost data” can reasonably be expanded to include data that is inaccessible to the business for long enough to significantly and negatively impact it. So, preventing data loss and providing rapid data/application recovery are equally important. Any data loss in Oracle Database environments—whether of the permanent or temporary variety—is likely to have a disproportionately harmful business impact. Oracle developed its Recovery Appliance to address the most common forms of potential data loss issues in Oracle Database environments. Its eponymous name is something of a rarity in IT marketing, but it emphasizes the system’s abilities to avoid permanent data loss and to greatly reduce temporary data lost to the business.

Our presentation is delivering real life reactive and proactive case studies and references from the Adriatic region which prove the need and value of Oracle’s Recovery Appliance engineered system.

Speaker:
Bojan Matijašević and Predrag Simovič
Podjetje
Oracle
11:55 - 12:40
JSON  Relational Duality

JSON Relational Duality

Oracle JSON Relational Duality technology allows developers to store and query JSON data in an Oracle database using SQL, while also preserving the hierarchical structure of the JSON data. This technology allows for seamless integration of JSON data with traditional relational data in the same database, providing a way to work with both structured and semi-structured data in one system.

Speaker:
Vili Tajnić
Podjetje
Oracle
11:00 - 11:45
Kako ukrotiti pobegle SQL stavke po nadgradnji baze, aplikacije ali hardvera?

Kako ukrotiti pobegle SQL stavke po nadgradnji baze, aplikacije ali hardvera?

Po nadgradnjah baze, aplikacije, hardvera in tudi po instalaciji patchsetov se rado zgodi, da nekateri SQL stavki pobegnejo - se ne izvajajo več tako kot pred spremembami. Če se izvajajo hitreje, to nikogar ne boli. Problem pa nastane, ko se začnejo izvajati počasneje.

Kakšne možnosti imamo, da izvajanje teh stavke "fiksiramo"? Kako to dosežemo tudi v Standard ediciji baze?

Ogledali si bomo tudi način, kako take stavke najti.

==============

After upgrading databases, applications, HW or even after installing patch-sets it often happens that some SQL statements go wild, meaning they start performing significantly different compared to their behavior before the change. If performance is better then no one will complain, but if it is worse then you might have a problem.

What options exist to confine the execution of such statements? How this can be done in DB Standard Edition environments?

You will also find out how such SQL statements can be located.

Speaker:
Boris Oblak
Podjetje
Abakus plus d.o.o.
10:05 - 10:50
Merjenje performanc pred in po Oracle migraciji

Merjenje performanc pred in po Oracle migraciji

Kako ugotoviti ali se baza na novem strežniku, drugi platformi ali celo na drugi ediciji (enterprise/standard), odziva hitreje ali počasneje? Kako identificirati SQL stavke, ki so bili po migraciji počasnejši? Zakaj in za koliko so bili hitrejši v novem okolju?

Marsikatera organizacija se za odgovore na tovrstna vprašanja zanaša na dolgoletne izkušnje DBA-ja. Mi pa bomo tokrat prikazali, kako lahko pridemo do teh odgovorov tudi brez pisanja SQL stavkov, tako na Standard kot tudi na Enterprise Edition.

Speaker:
Urh Srečnik
Podjetje
Abakus Plus d.o.o.
11:00 - 11:45
Oracle The Most Mysterious Cases

Oracle The Most Mysterious Cases

It was on a cold day in November when the silence was broken by a desperate scream: ‘Kill it! Kill it!”. The boss immediately pushed the button and brutally terminated the session. It has happened again… The Performance was murdered. Boss flicked through the case files. There were no usual suspects. Where is the murderer hiding then? The desk was buried under the cases’ files similar to this one. The File that hasn’t been seen in production for 6 months, the whole team has been looking for it, but there was no progress, not even a clue… Another reported missing - Data has left the Source System but never reached the Destination server…Nobody has seen it again… This is too much for one person. And that’s why I need YOUR help! During the session, we will solve all the mysterious cases together and we will find out what is responsible for the strange behavior of the system. Is the source of the problem a huge design error or a small decision at one of the stages of development? How minor design decisions can affect the system's performance and vulnerability to errors? Who is the murderer? The answer may surprise you!

Speaker:
Monika Lewandowska
Podjetje
freelancer
13:50 - 14:35
PLSQL's Believe it or not

PLSQL's Believe it or not

The basics of the PLSQL language are very easy to learn. Deceivingly easy. At one customer I saw what happens when people, after a brief introduction to PLSQL, think "This is simple, I can do this". I worked for this customer (no, I will not reveal their name) where the databases that I had to work with were built by people with obviously just a very basic understanding of the Oracle database and especially PLSQL. Many times a day I was shaking my head over the solutions that had been invented and the fixes if things didn't work. I would like to take you along on a journey through some of the things that I saw there. Come see how to not do a calculation in PLSQL, how not to get to know the number of rows in a collection, how not to repond when utl_file 'ignores line endings', why they claimed that Oracle's error messages have noting to do with what is actually wrong, and many more. And of course I'll also show you how it can be done better, just in case you don't know already. Mainly for fun, because I hope you will already know that these things are not the way to do it. However, if you see something and think "that's how I would have done it", don't be ashamed. None of us knows everything. We all make mistakes. We all do stupid things. But, if you think "I could have done that" with all of the examples ...... I know just the workplace for you :D

Speaker:
Erik van Roon
Podjetje
EvROCS
11:55 - 12:40
SQL: Good and evil are the same thing

SQL: Good and evil are the same thing

SQL is one of the most powerful languages. It gives us direct access to a database and allows us to manage the data: query, change, or delete it. We can join multiple tables, perform complicated calculations, and much more! That makes the possibility to use SQL directly from PL/SQL code one of the best features of Oracle. But, as Heraclitus said, Good and evil are the same thing - this possibility is one of the biggest problems in Oracle, too. Mixing SQL and PL/SQL code is so easy and tempting, that we do it all the time without giving it a lot of thought. The consequences, however, are serious and impact the clarity of the code, its testability, and the overall system performance.

In this talk, I will show that although SQL is a very powerful tool, it is not healthy for your system to have too much of it. I will show how you can get rid of some unnecessary SQL and therefore keep the good while avoiding the evil that comes with it.

Join me and see how to organize your database code to maximize the benefits of the powerful SQL and PL/SQL capabilities and avoid its hidden danger. Live coding and examples on demo!

Speaker:
Monika Lewandowska
Podjetje
freelancer
14:50 - 15:35
Supercharge your upgrade with AutoUpgrade

Supercharge your upgrade with AutoUpgrade

Upgrading your Oracle Database with AutoUpgrade is easy. But have you tried to use the advanced features in AutoUpgrade? You can easily supercharge your Oracle Database upgrade by using some of the advanced features. We will show you how to upgrade as many as PDBs as fast as possible and how you can leverage all nodes in your RAC cluster for optimal performance. You will also learn how to work with encrypted databases and how to deal with the encryption key. In addition, we will show you can migrate to the multitenant architecture using refreshable clone PDBs. Avoid a lengthy outage by allowing AutoUpgrade to copy the data files in advance and keep them in sync with redo. All that plus a few bonus features are covered in this session.

Speaker:
Daniel Overby Hansen
Podjetje
Oracle
15:45 - 16:30
To V or not to V? or.. using SQL Macros in APEX?

To V or not to V? or.. using SQL Macros in APEX?

The V function has been around APEX as long as ... let's say very long and that's a long time. The V function allows you to reference item values from session state in your SQL statements. When calling V there would always be a price to pay. With recent releases of the database there is a new way to do something similar; SQL Macro. With SQL Macro you can create parameterized views and this could be very interesting for APEX Developers. In this session I will give you an overview of this new functionality and how you can use it in your APEX applications.

Speaker:
Alex Nuijten
Podjetje
allAPEX
13:50 - 14:35
Understanding auto-rest (ORDS on steroids)

Understanding auto-rest (ORDS on steroids)

The Oracle Restful Data Services allow to "rest-enable" database objects like Tables, Views, Procedures and Functions. This includes data-retrieval and data-manipulation. Using a few simple directives in the URL you can search for specific records, order the result set or even limit the amount of records retrieved. On top of that the ORDS will automatically show you the resulting JSON The session focuses on the creation and use of autorest enabled services on objects. The creation section (1st half) focuses on the right format of your JSON result. The seconds half covers consuming these services; how to do CRUD operations, how to search the for data, how to paginate etc.

Speaker:
Richard Martens
Podjetje
SMART4Solutions BV
14:50 - 15:35
Using ORDS, REST webservices, PL/SQL and OAuth2 to Build, Deploy and Secure an API

Using ORDS, REST webservices, PL/SQL and OAuth2 to Build, Deploy and Secure an API

In this presentation, through building practical examples, attendees will learn how to build a secured REST API to enable searching on their application.

The resulting technology-independent REST API will be usable by both Oracle and by non-Oracle environments alike.

Topics to be covered include:

  • an architectural overview of the creation of ORDS web services in PL/SQL
  • setting up ORDS for your database schema
  • defining the search API in PL/SQL
  • creating ORDS module and templates for the API
  • management of HTTP return statuses and result pages pagination
  • securing the API via OAuth2 using ORDS clients, privileges and roles.
Speaker:
Niall Mc Phillips
Podjetje
Long Acre
Subscribe to this RSS feed