It is paramount to protect and secure your companies most valuable asset: your Oracle databases! Oracle Database Administrators often spend most of their time and resources dealing with multiple products, features—not to mention—complexity. Explore how you can simplify, and cost-effectively automate, data protection. Learn how to create frequent backups, and test failover and failback of critical databases and applications to or from DR site (in cloud or on-premises). See how to meet RPO and RTO=0 objectives and burst to cloud for test and development. ​

Presented by Ebin Kadavy, NetApp

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.