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: 101030

Taking your customer's experience to the next level is a gargantuan task! Ensuring that your infrastructure and apps are healthy and performant, today, is a minimum requirement but the real insights are derived by deeper analysis of the usage patterns available in logs, among other sources, to inform business decisions which are measurable. Logs come in different variety and could be from few Gigabytes to Terabytes making it difficult for everyone to visualize and analyze. Enter OCI Logging Analytics.

In this workshop, we'll take you through the end-to-end Log Analytics value chain to show how you can use OCI Logging Analytics to do advance analytics and ML on log data.

Come to this session if you are a DBA, IT Analyst, IT Admin, DevOps or LoB Manager to learn how to quickly gain deeper insights from your log data quickly.  You'll learn how to use Logging Analytics' in-built ML features and integration with Data Science for custom ML models. No prior training is required.

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.