Presented at INSYNC 21

Session ID: 101360

What do you need to build a fully automated Oracle DBaaS stack? Hardware, Software and a heterogenous team with a passion for automation. I am proud to be part of the team which has ramped up in the last months a DBaaS for a large Swiss customer with a huge bandwidth of technology. From PCA to ZDLRA, from VMWare vRA to Ansible Tower, from Jira Tasks to Scaled Agile Framework, each team member brought in his expertise to bring the service to the market. I will show you what you need to build such a service from scratch. What we have learned when setting up DevOps tools like Ansible and git. And what I can tell you, the passionate team is the key to success. I am not talking only about tech stuff, we want to see what is required in the back, and how long the way is from the first sprint planning to customer readiness.

Presented at INSYNC 21

Session ID: 100750

Many developers/DBA’s are challenged by the limitations of the standard AWR tools.  Develop insight and command skill in the right application of the AWR toolset – or risk being drowned in the sea of performance metrics.  To handle the many varied cases where it is necessary to go beyond the standard toolset, the Oracle DB tuner must be able to creatively query the historic performance metrics and quickly discern root causes and provide solutions. 

Get a jump start by experiencing the presenter's process and tools, along with some case studies of real-life performance nightmares that were converted into success stories.  Learn where to look in the AWR data to solve the difficult performance problems.  See the solutions and learn how to apply a results-producing strategy for digging deep in the AWR repository to power past your own specific performance issues.  Additionally, the author will share his various scripts and SQL queries used to make the most effective use of AWR.

Presented at INSYNC 21

Session ID: 100080

With the increase in demand for application to be online 24x7x365, several tasks like upgrades and migrations are becoming a challenge. While keeping in mind that clients want a fool proof migration /upgrade we are also having to ensure we ask for no downtime. This is challenging enough to start with without adding the size of the database in question to be several terabytes. What are some methods that can guarantee a no downtime migration of 100T database? We will explore some options to successfully migrate large databases with zero downtime. Detailing the methods and illustration of the requirements to help audience understand options available to reproduce the migrations in their client space.

Presented at INSYNC 21

Session ID: 101460

This presentation will look at 12c to 21c new features that should be investigated for use which include Multitenant, IN-Memory and Oracle 19c Automatic Indexing and many more. I will discuss the 12c to 21c Journey for these new features with examples and sample code. Attendees can expect brief introduction of all the new features with deep dive into Multitenant, IN-Memory and Automatic Indexing.

Presented at INSYNC 21

Session ID: 101100

Multi-factor authentication (MFA) or 2-factor authentication (2FA) for database connections is frequently inquired about, but rarely implemented.  Yet is surprisingly easy to implement in the Oracle Database.

This session covers how to implement MFA/2FA for your Oracle Databases via common MFA platforms including Cisco Duo.  Including specifics of how to get started and test in your own DBA lab environment.

Presented at INSYNC 21

Session ID: 100840

This presentation will focus on what specific Algorithms that are inside Oracle can be applied to Business Problems. Robots may be the first to truly learn Machine Learning (ML) and expand into Artificial Intelligence (AI). Python is one of the keys to Machine Learning as we program the invention of Man's Mind to further replace man's most basic tasks. This session will focus on ML 101 and building the future ahead. Some business issues are seasonal, some relate to customers with certain attributes, some relate to customers we don't know exist, but all can be solved by using the correct algorithm to quickly prescribe a better corporate future.

Presented at INSYNC 21

Session ID: 101020

Oracle Sharding was further improved for linear scalability and complete fault isolation of OLTP workloads. With Oracle, sharding Data are partitioned horizontally partitioned across discrete  Oracle Databases (shards) in shared-nothing architecture that collectively forms a single logical database. Come to this session to learn its latest improvements and leveraging sharding for your business. We will share the experience and tips of configuring sharded database architecture with HA  replication for massive scalability and complete fault isolation. We will also discuss some of the considerations of choosing a sharding method in a global geographic distribution application and the experience of using Sharing Advisor.  We will also discuss some new sharding features that are in Oracle  20c/21c such as Federated Sharding and sharding with database in Persistent memory and Sharding Automation tool.

Presented at INSYNC 21

Session ID: 101600

Unified Auditing was introduced with the release of Oracle 12c and changes how Oracle database logging and auditing is accomplished.  In previous releases of Oracle, there were separate audit trails for each individual component.  Unified Auditing now consolidates all auditing into a single view.  For DBAs, IT Security, and auditors, Unified Auditing presents significant new opportunities for Oracle database activity monitoring and security.  This session will dive into Unified Auditing to highlight how it enhances database auditing and how to take full advantage of it to improve the security, compliance, and visibility into your database. Unified Auditing configuration, maintenance, performance, reporting, alerting, and archiving will be reviewed to provide a full understanding of its capabilities.

Presented at INSYNC 21

Session ID: 100290

The latest version of Oracle RAC includes features that enable better scalability and provide higher availability. In this session, we will cover the internals of new features and changes that DBA's need to make in their Pluggable Database deployment to benefit from the integration of PDBs with Oracle RAC.

Presented at INSYNC 21

Session ID: 100210

The database administration role as we knew it is dead.  DBAs who have been around for decades have become irrelevant in this data-driven economy.  Developers want autonomous management and executive leaders want to cut costs any way they can.  Join Oracle community experts as we discuss the next evolutionary role of the database administration role and what we must do to adapt and survive in this ever-changing dynamic technology-driven world.  Learn what future skills you need to possess and how you can stay on top of the demand.

Discussions will include how technical enhancements to autonomous databases, cloud innovations, and what you must learn to survive, how AI and machine learning can impact the database scene, and understanding which technologies you need to learn to adapt.