POUG2021, 10th-11th September, Warsaw

Changing "colors" happens in IT frequently and is driven by various reasons. In this session we will talk about using production database running on IBM POWER/AIX on-premises platform as a source for building multiple testing environments running in Microsoft Azure (x86/Linux). All fully automated using Azure DevOps Pipelines and in accordance with security standards imposed on banking sector.

Unit tests are useful. Unit tests are essential. All of us are doing the UT, aren’t we? We try to do our best but in real life, UTs are expensive and consume a lot of time. When we finally find a bug - it turns out that the bug is in the test itself. And the deadline is coming… Can we do the UT easier, less expensive, and more effective? YES, WE CAN! I would like to show you how to design your application, write your PL/SQL code and prepare test cases in a way that will help to build Unit Tests and perform them in a fast, efficient, and exciting way!

Oracle database 21c came with 211 new features and 3 major ones are directly related to tables and indexes in the database: Blockchain Tables, Automatic Index Optimization and Automatic Zone Maps. The presentation covers all these 3 in detail with several examples including also Data Pump new features and how to upgrade to 21c.

Oracle Fleet Patching and Provisioning is a robust, reliable, automated and fleet capable solution that orchestrates the install, patching and upgrade of Oracle Grid Infrastructure and Oracle Databases. How does it work? What are the building blocks? How does the communication between client and server happen? How are the software homes transferred and stored? How are databases patched? In this session I will answer all these questions and give you a clear understanding of Fleet Patching and Provisioning architecture.

Performance problems come in many varieties. Most can be solved by the Wait Interface, but sometimes that’s not enough. Enter session counters to the rescue. And in rare occasions even those don’t help you have to use O/S tracing and profiling tools. The talk introduces all of these in depth.

Oracle database 18c introduces Polymorphic Table Functions. This session will tell you about Polymorphism. How can you apply this in pre-18c databases? I will show you what problem and the solution when your data or structure changes. I will also show you an example of a Polymorphic Table Function and how this can help protect you from changing table structures and how you can apply the same code to different table structures without changing or even recompiling the code. After this session you will understand when to use which technique.

Organizations using modern approaches to code development are using CI/CD pipeline to speed up and automate all processes. There are a lot of solutions to help developers to manage code, changes or building an artifact. It is not that easy with managing databases and more specifically data. Using containers, it’s pretty easy to create a new empty database but it’s not a solution for data especially if development or bug fixing requires real production or masked data. This presentation is trying to address this issue and show what can be done to resolve this problem. The following techniques will be presented: - Cloning / snapshot-ing using Oracle Containers Databases - Building dockers with some data - Snapshots on file system / storage / 3rd party products

Moving from Oracle to PostgreSQL creates some wonderful opportunities and there are countless features you will find useful and elegang on the PostgreSQL side. This talk covers the most exciting and powerful things PostgreSQL has to offer from an Oracle perspective

With the release 19.2 of Oracle REST Data Services Oracle introduced functionalities for DBAs to operate a database via a REST API. The main focus of this presentation is on the architecture and what a DBA needs to know to run this API safely. It enables automation processes to directly communicate with the database without interaction with the server but there are some questions to be answered before we implement ORDS. Who can use this API? How do they authenticate? Where should the Webserver be placed? Is it safe?

Over the last few years we’ve been automating parts of the regular security patching of a bunch of Fusion Middleware installations. The code covers ~80% of the regular tasks. I’ll cover the past experiences, some history, and issues faced during development, and actual use of the code for patching.

Microservices are a useful concept, and the supposed advantages are often cited. But there are a few things to consider when microservices need to interact with a “traditional” database or RDBMS.

In some cases, you can even have your RDBMS (Oracle, PostgreSQL or mySQL) take up the role of a microservice, and achieve remarkable efficiency.

We will provide a few use-cases and examples where it may be interesting to use the DB as the main component of the microservice.

After the presentation, the audience will have a better idea of the Advantages, and hopefully some ideas to to avoid the Disadvantages of Microservices. And in particular use cases, may choose to use the Database as the base for a microservice.

How do you take your database schema and your data to the next release? Do you herd a collection of delta scripts? Do you know exactly which version of which object was deployed in your different environments at a certain point in time?
Find out how the open-source tool Flyway can help you manage your database schema changes in an agile environment and how easy it is to get started.
After several years of using Flyway Community Edition in combination with an Oracle database I would like to share my insights about
- How to write scripts for Oracle database in Java, DDL and PL/SQL
- How to organise your scripts
- Potential pitfalls and workarounds
- Good and not-so-good practices
- A short comparison with Liquibase
Flyway integrates with various build frameworks like Ant, Maven or Gradle but for demo purposes we will stick with the command line.
This session will give you the basic knowledge and a collection of sample scripts to start right away.
I promise – once you’ve started using a database deployment tool you'll never want to go back!

Low-code platforms such as Oracle APEX were invented to deliver value to business as fast as possible.
However, delivering something fast often causes a lack of control in database changes and lower code quality.
We will show You, how to automate deployment process (DevOps) saving more of Your time for development and tests instead of wasting it for preparing release scripts.

One of the frequent complaints developers receive from DBAs is about misconfigured connection pools and insane number of connections applications tend to allocate. This session explains basics about connection pooling, why they are used, and how to configure them for availability and performance.

Learn In-Database machine learning embedded in the Oracle Database . Through an example, to learn the process to develop the Machine Learning with Oracle machine learning for SQL and Oracle machine learning notebook environment. Learn new In-Database Machine Learning features in Oracle 21c.

The talk will give an introduction into basics of queueing theory, and how it affects latency and throughput. A straight overview from the impossibility of linear scalability to Amdahls law until the Universal Sacability Law is provided. By these tools and with reasonable measurements specific characteristics of any system can be described in a comparative way.

This presentation will focus on writing secure PL/SQL code. We will define and identify sql injection bugs along with other common coding bugs that can lead to a data breach. Once we have defined these bugs, we will go through a design and coding architecture that drastically improves your infosec posture.

The Internet of Things (IoT) has deep use cases - energy grids, communications, policing, security, and manufacturing. I’ll show how to use Oracle 19c’s Fast Ingest and Fast Lookup features to load IoT data from “edge” sources to take immediate advantage of that information in nearly real time.

We have missed human contact so much, I believe it’s more important to sort that out than talk about some silly little computers.

I will therefore use my cuddly frame to hug any and all audience members either individually or using a more advanced option of clusters of 3, 4 or even 5 people.