Agenda October 21
The Superpowers of the Oracle Database
Speaker: Philipp Salvisberg
PL/SQL combines static SQL with a procedural language. This makes processing within the database easy. But why inside the database? No unnecessary data transports. Consistent data. Optimal use of resources. Good response times. That’s why. However, the real superpowers of the Oracle database are its features. In this talk, I will connect a superpower of each founding member of the Justice League to an Oracle database feature. With live demos and links to more information to get you started. Some covered features are:
– Advanced Queuing
– Flashback Data Archive
– Virtual Private Database
– Oracle Spatial
– Oracle Text
At the end of the talk, I will cover the benefits of file-based development and show how you can use testing tools and static code analysis tools to achieve and maintain good code quality. Do you provide solutions based on the Oracle database? Then you must not miss this presentation. You will for sure learn something new, regardless of your level of experience.
Upgrade and Migrations 21c New Features
Oracle Database 21c is out – and there are a lot of new things regarding database upgrades and migrations. This includes certainly the migration to Oracle Multitenant but also a new default technique to upgrade PDBs. And much much more. We will cover it all and give you technical insights into the new 21c upgrade and migration features: The good, the bad – and some really cool ones.
This will be a technical talk free of any marketing or advertising. But we will include as many demos as possible to really demonstrate new features.
What a DBA should know about the Oracle REST API
Speaker: Julian Frey
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?
Managing DBA Applications With APEX
Speaker: Michael J Gangler
Are you in an environment that has more than ten databases with multiple environments and technologies?
If not, you’re lucky. However, this session can help you along with the DBA with many and multiple databases and environments. This presentation will attempt to gap the usage of Oracle’s Free tool—APEX—with normal database operations to organize and gather information from your database and identify performance, backup, and utilization patterns. This won’t replace Oracle’s OEM and AWR warehouse but act as a first step to understand where to look in the OEM or other 3rd party tools. This application can be used by DBAs or managers who want to understand the database resources that are currently used (total CPU, memory, etc.). Plus, it has multi-tier and department usage and can be set up by any level DBA.
Creating Order in the Database Patching Chaos
Speaker: Liron Amitzi
Have you ever found yourself staring at a list of patches and wondering what to do? What patch should I install? What are the risks? Is there anything I should do after the patch? This becomes even more stressful in a complex environment: How to install patches on RAC? What about standby databases?
This session will try to put things in order and help create a roadmap for patching databases. We will discuss the different types of patches (RU, RUR, DBBP, PSU, OJVM, One-off), installation types (RAC rolling patches, standby first patches), known issues and where to find them, and how to plan the patch installation in order to have as few surprises as possible.
Time to register for OGB EMEA by SwissOUC