Presented at INSYNC 21

Session ID: 101330

During a large in-house cloud project with a large amount of developers and teams, Oracle was chosen to be one of the main data backends. This led to a huge demand of databases and schemata and thus resulting in lot of work for us as the DBA-Team.

Our "classical" approach to handle these requirements didn't work in this case efficiently enough. Therefore we needed an optimised solution to handle all these in shorter time and with less effort. We had chosen Ansible, RAC and the Oracle Multitenant Option to be the components to solve this.

This Talk highlights the challenges, as well as the solution we had implemented. It will be shown what the current status quo of the implementation is and if the improvements could be reached.

Presented at INSYNC 21

Session ID: 100670

Running out of support, security concerns, new features, coming operating system or hardware changes.... there is a long and versatile list of potential reasons for our customers, to change the version of their running Oracle Databases. The "choice" of situations, challenges and options for changing the version, is at least as long and as versatile as the reasons are.

Oracle ACE Director Martin Klier will deliver an unveiled overview about his adventures with logical dependencies, human sensitivities, technical skulduggeries and license traps. All this happens, when one or multiple databases are to be migrated or upgraded to a new version in a controlled fashion. For A as in AIX, L like Linux, S like Solaris, V like Virtualization, W twice in Windows ... there was trouble, there was a solution, and there was a new experience!

Presented at INSYNC 21

Session ID: 100140 

Oracle SQL Plan Management (SPM) is often overlooked and underused. This feature started in version 11.1 and has been enhanced with each new release. As of 19c, this should be your go-to method to help maintain well-performing SQL statements. In this session, we will cover what SPM is, how to use SPM from end to end, and how to monitor it. Once you start using SPM Baselines you will find them to an invaluable tool in your continuous goal to maintain database performance. 

Presented at INSYNC 21

Session ID: 100550

Oracle Database provides us with collections since a long as I can remember (Oracle 7.3.6.4). First as PL/SQL Tables in PL/SQL only. They have been been renamed (Index-by Tables, Associative arrays) and new implementations have been added since (Varrays, Nested Tables [SQL and PL/SQL]). Also the original Asscociative arrays have been updated, making them available in SQL as well. They play a key role in many of the newer Oracle features like BULK Processing (BULK COLLECT and FORALL) and Table functions. Using the bulk processing capabilities of your Oracle Database they can speed up your processing by an order of magnitude.

This session will show a little bit of history, how to use the collections, how to make collections available in SQL so they can be processed in other languages. How things can be done in what version and how things become easier with the newer versions of the database.

Presented at INSYNC 21

Session ID: 101920

Most modern computer applications include an “advanced search” screen that allows users to enter multiple criteria and parameters. Unfortunately, behind the scenes, this functionality can cause major headaches for implementing the back end, because the resulting queries may reference an unknown number of tables and/or columns and may return unknown numbers of rows. In addition, the results may mutate depending upon the parameters. There are multiple ways of solving this problem with various levels of efficiency. This presentation will demonstrate how to handle generic search functionality within an Oracle database by utilizing Dynamic SQL, object collections, and a bit of a creativity.

Presented at INSYNC 21

Session ID: 101480

Database 21c pluggable databases offer numerous options for the cloud. In this session walk through Multitenant for cloud/on-premises databases. Topics covered include container database (CDB)/pluggable database (PDB) concepts, PDB value, shared/exclusive components, and accessing CDBs/PDBs. The session briefly covers migration options to 12c/21c from previous versions and then delves into Oracle Database 12c R2/21c features including PDB relocate, lockdown profiles, system global area/program global area for PDB, memory I/O resource prioritization, snapshot carousel, dynamic lockdown profiles, CDB fleet management, and new features in Oracle Database 21c if time permits.

Presented at INSYNC 21

Session ID: 101950

Learn how the IBM POWER9 helps you accelerate performance of the DB In-Memory and reduce CPU use when performing complex analytics queries. After a brief overview of Oracle Database In-Memory we'll share our experiences testing this feature with simple and complex queries on POWER9. We have the speed ups achieved to share for a set of reporting queries run In-Memory compared to disk row format, as well as hints and tips for getting the best results with In-Memory.

Presented at INSYNC 21

Session ID: 101580

Oracle GoldenGate still maintains its status as the best replication tool in the industry. As environments and industry change, so has the model for deployment of Oracle GoldenGate.  Deployment models have changed from peer-to-peer to hub-n-spoke and currently moving to mesh architectures with these environmental changes, how Oracle is starting to support deployment models like Docker.  This session will provide an introduction to Oracle GoldenGate Microservices on Docker, including best practices and pitfalls.

Presented at INSYNC 21

Session ID: 101940

Big data analytic solutions play a pivotal role in improving business insight and enhancing consumer experience.  It is increasingly evident that organizations can realize the full potential value of their data assets by combining the structured transactional data with semistructured and unstructured data.  Low-latency transactional data brings additional value for business especially for dynamically changing operations that day-old data, structured or unstructured, cannot deliver. Oracle GoldenGate for Big Data offers a comprehensive platform that streams transactional data(residing in Oracle databases) into Big Data platform(Hadoop,Kafka,Hbase,MongoDB etc.) in real time,  without degrading the performance of the source production systems. It lays the foundation for more efficient operations and an improved customer experience.

Presented at INSYNC 21

Session ID: 100460

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, UT is expensive and consumes 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 prepare yourself, your application, and your code to perform Unit Tests in a fast, efficient, and exciting way! How to do Unit Tests and not go crazy (and bankrupt) - true story.