Track B ⁽⁸⁾

.

empty

Kosilo

Migrating a TB Database from 11g Windows to 19c Linux in less than an hour

Upgrading a database with plattform migration is always challenging especially if you should hav a very short downtime. There are many ways to do this. In a recent project I used Transportable Tablespace for that. I'll show how I did this and what could go wrong.

Odmor - kava

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!

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

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!

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.