This year our annual APAC Groundbreakers tour is going virtual. With the participation of many Oracle User Groups, and Java Communities in the region, this year's event is promising to be the biggest event ever done within the APACOUC Community.

This year our annual APAC Groundbreakers tour is going virtual. With the participation of many Oracle User Groups, and Java Communities in the region. This year's event is promising to be the biggest event ever done within the APACOUC Community.

Oracle Groundbreakers APAC Virtual Tour 2021

Australia

Another year goes by, and most likely, another data access framework has been invented. It will claim to be the fastest, smartest way to talk to the database, and just like all those that came before it, it will not be. Because the best database access tool has been there for more than 30 years now, and that is PL/SQL. Although we all sometimes fall prey to the mindset of "Oh look, a shiny new tool, we should start using it", the performance and simplicity of PL/SQL remains unmatched. This session looks at the failings of other data access languages, why even a cursory knowledge of PL/SQL will make you a better developer, and how to get the most out of PL/SQL when it comes to database performance.

Why PL/SQL is still the best data access language

It's never been easier to launch into building your applications on the Oracle Database. Just a few clicks and your Oracle Database is ready to go. But when those applications we build become the overnight sensation that we always dreamt about, it is often the case that the schemas we designed on a paper napkin and implemented on day 1 might not live up to the flexibility, maintainability and performance demands the database can offer at the very moment we need it most - when more and more customers are clamouring for our amazing app! This session walks through the tools to rapid prototype and deploy your database schema, and how to evolve that design to handle increasing demands over time.

The lost art of Physical Design - from Bit Bucket to Insane Performance

When external tables were first introduced, some DBAs and Developers responded with little fanfare because it seemed to only replicate functionality that had already available for decades with SQL*Loader. Moreover, the syntax seemed overly stringent on getting the keywords and their sequencing correct otherwise you were met with a generic "Nope, that isn't right" error message.

But external tables are definitely not just your everyday data loader. Each release of the Oracle Database adds to their functionality, and nowadays, the list of tasks you can do with external tables is mind-blowing. In this session, we'll see how they have evolved through the various release of the Oracle Database, and then we'll take external table usage to another level, for example, using them to load XLSX spreadsheets, monitor your database instance, run OS utilities from within the database, or even update the Oracle software on the fly!

External tables - so much more than SQL Loader

United States of America

Oracle MovieStream is a fictitious movie stream platform - like Netflix, Amazon, Hulu, etc., which have seen massive growth in the last 18-months. As a result, they face challenges typical to many organizations across industries, including understanding their customers better and anticipating their needs to ensure they love their service. This session will show how MovieStream designed its data platform using Oracle's converged database to generate value from the massive amount of structured, semi-structured, and unstructured data, retain their customers and ultimately improve profitability.

How Oracle's converged database helps MovieStream generate more value from data

Independently of the technologies you use, we are all in the same boat when it comes to security and compliances within IT. This session will take you through our journey and especially our challenges of our experience of our journey to achieve our PCI compliance, and could easily become your baseline towards any other types of security compliances available. It does not matter if you are an Architect,  a DBA, a developer, a project manager or a member of your company management, the ideas, tips, and suggestions in this session would for sure help you always in your security journey. Join us on this exciting topic that for sure would be a huge plus on any IT professional belt.

Taking your security to another level

This presentation will focus on the Oracle Database's ability to manage different types of data efficiently.  As we move into the future, the efficiency of Oracle in using InMemory, MachineLearning, Exadata, Documents, JSON, XML...etc. will be their main strength.  Converged Database strategy makes it simple to satisfy these demands. Join ACE Directors Nitin Vengurlekar, Rich Niemiec and Jim Czuprynski as they explore the facets of Converged Database from the perspectives of CEO, CIO, and DBA, and what it means for your career’s future path.

In the brave new digitally-driven world, IT organizations can no longer focus on internal-only RDBMS databases as the central pillar of their infrastructure; data must be accessed externally as well, regardless of format or location, with utmost security. Fortunately, Oracle’s Converged Database strategy makes it simple to satisfy these demands. Join ACE Directors Nitin Vengurlekar, Rich Niemiec and Jim Czuprynski as they explore the facets of Converged Database from the perspectives of CEO, CIO, and DBA, and what it means for your career’s future path.


Converged Database is Oracle's Best kept Secret (Workshop)

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. 

Machine Learning for Business Problems (Workshop)

Luxembourg

Exadata is in the market for 11 years and a lot of sessions talk about how to use smart scan, HCC, and how good these features are. But this session is not about that. Working with Exadata since 2010 in this session I will share some tips and tricks about details/features/topics that are not widely seen in other sessions.

In this session I will discuss how IORM is more important than just slice the resource, what are and how important the storage metrics are (and how to read and understand them). Also, details about ASM features that can help when an outage occurs and tricks about the Exadata patch.

The session is not about ExaCC, but you can use a lot of things from this session as well.

Tips & Tricks of using Exadata since 2010

Zero Data Loss Recovery Appliance (ZDLRA) is an Engineered System and part of MAA family too. But do you know that is the only product listed to be used in all MAA architectures, from Bronze to Platinum? And do you know why?

The focus is talking about the MAA architecture references and understands why RTO and RPO concepts are so important. Why (and how) you, with a single ZDLRA, bring down RPO to zero for all of your databases. This session is not about ZDLRA features, but why you need to look at ZDLRA beyond just a fast backup perspective.

I am not an Oracle employee, so, do not expect a marketing presentation. I will show you how to integrate ZDLRA and why you need to consider it for your next MAA architecture design.

There is no MAA without ZDLRA!

Switzerland

Lockdown Profile, PDB_OS_CREDENTIALS and other measures to enhance security and isolation of multitenant databases are available since Oracle 12c. Unfortunately only a part of the desired measures can be technically implemented. With the latest release of Oracle 21c a new features called DB Nest has been introduced. DB Nest introduced an other approach to security in PDBs. In this presentation we will discuss the new approach and its possibilities to increase database security of PDBs. The presentation will be completed by corresponding examples and live demos.
Notes: Based on the experiences from a private cloud project, we show how to implement PDB security and isolation for Oracle multitenant databases on premises and in the cloud. This covers existing security features but also new functions like DB nest. The presentation will be completed by corresponding examples and live demos.

DB Nest 21c - PDB Security and Isolation

Oracle Database Vault has been on the market for a few years now. The product has been constantly improved over the years. But where is it worthwhile to use it? Which security measures can be implemented with it? And from whom does DB Vault protect me at all? In this presentation, the technical possibilities of Database Vault 19c / 21c will be explained in addition to the experiences from two customer projects. We will try to show where the use of Database Vault is worthwhile under certain circumstances and under which conditions it is not. This also includes whether protection against snakes and thieves is ensured. PS: I asked my children what kind of presentation I should submit.The answers were snakes, thieves and cheetahs…

Oracle Database Vault - Protection from Thieves, Snakes,... 

 Introducing Oracle Zero Downtime Migration 21.2, Oracle premier automated tool for moving your database from On-premises to the Oracle Cloud. Oracle Zero Downtime Migration (ZDM) is an automated tool that leverages the best of High Availability and Scalability solutions at Oracle , thus moving your Database to the Oracle Cloud with no database downtime. In this session, we will cover in-depth the full range of features and functionality of Oracle Zero Downtime Migration. How it was designed and built and how it can be leveraged for all your migration needs. We will showcase ZDM's latest release, with features and functionalities such as migration from Solaris/AIX Sources, migration from Oracle Databases on AWS RDS and Physical Direct Data Transfer. This session will also cover the overall migration workflows, such as Physical Offline with RMAN Backup and Restore, Physical Online with Data Guard, Logical Offline with Data Pump and Logical Online with GoldenGate and Data Pump. Join this session and get to know about Oracle's overall Cloud Migration roadmap and how ZDM can help you be successful in your Cloud Migration Journey.

Oracle Zero Downtime Migration 21.2

Oracle Zero Downtime Migration, ZDM, allows for In-Flight Upgrades of your Oracle Database when migrating to the Oracle Cloud. In this session, we will cover step by step a migration, from product installation, to configuration and all the different options and parameters to take into the account. We will the showcase a demo of a migration using ZDM with a source database on-premises being upgraded at the same time. Join this session and learn how-to migrate and upgrade your Oracle Databases to the Oracle Cloud.


How to Migrate your Database to the Oracle Cloud and Upgrade it at the Same Time with ZDM (Workshop)

India

Goldengate is a leader in database replication technologies. Besides being an easy to-use tool, now it's available on the Oracle Cloud Infrastructure. Not only that it's now even more easier to use, but the monitoring and configuring is now just so easy. This presentation will introduce OCIGG to the participants. We will see the steps how to setup OCIGG using the new GG Deployment and also will see how it can be monitored.  

Say Hello to GoldenGate in Oracle Cloud Infrastructure

What's new in OGG 21c? Eager to Know about it? Then this is the right session which explains and covers the major features of Oracle GoldenGate 21c.  Each and every feature or enhancement is explained in Detail with an example. The session also covers the comparison of older version of OGG and OGG 21c (new release).

Oracle GoldenGate 21c - What's new?

CDR - Conflict Detection and Resolution is used in Oracle GoldenGate Bi-Directional Replication (Active-Active). The conflicts are detected by the process and resolved as per the configuration. In OGG 12.3 version Auto CDR was introduced which simplifies the CDR configuration and everything is taken care automatically by the OGG itself. This session explains you about the Auto CDR functionality and how it differs from the manual CDR. It also explains the advantages of Auto CDR and steps to configure Auto CDR with demo.

This talk covers,

1. The Auto CDR functionality and how it differs from the Manual CDR
2. The pros and cons of Auto CDR
3. The steps to configure Auto CDR with Demo

OGG - Auto CDR

This paper would like to focus on many small, but not so trivial things that often go under the radar during Migration & Upgrade Projects, but later can potentially come back to haunt us. These can be changes in behavior of features (eg. RESOURCE ROLE or database jobs) between database versions, or changes in OS (e.g. the new tempfiles.d daemon with OEL7) that could impact the database operations. Some of the things on our checklist includes Database Credentials, scheduler or cron jobs, how to capture information about clients connecting to your database, performance considerations, database auditing , database links and various such Migration Best Practices. Accompanying our checklist would be, examples from real world migrations, and the various tools and automation that can help us with this task. These are some of the aspects of migrations and upgrade projects that are seldom given due importance & yet often are the yardstick that a truly successful migration is measured against.

It's the little things that matter!! ..... A look at Database Migration Gotcha's

Finland

Oracle database 21c came with 211 new features and 3 major ones are directly related to tables and indexes in the database: Blockchain Tables, Automatic Index Optimization and Automatic Zone Maps. The presentation covers all these 3 in detail with several examples including also Data Pump new features and how to upgrade to 21c.

Oracle 21c New Features for DBAs: Tables and Indexes

The presentation covers 2 main topic: #1 why to use Oracle Autonomous Database in the Cloud and #2 how Oracle Autonomous Database performance compares to other major databases in the Cloud

Comparing Oracle Database Performance in the Cloud

New Zealand

Oracle Visual Builder is the tool used by Oracle to build the user interface for the next generation of Oracle Cloud Apps. Learn how you can leverage the same tool to build the next generation of your application too. In this demo focused session we'll show you how the visual approach to app development help you create and host web and mobile apps quicker. Learn about the architecture and the development experience.

Faster HTML/JavaScript Development - with Oracle Visual Builder

Oracle APEX is the world's most popular enterprise low-code platform, used by every industry across the globe for solving problems of all scale, from departmental applications to enterprise-wide systems.

We will review real-world examples of Oracle APEX apps helping the fight against the pandemic by managing the logistics of vaccination programs, vaccine safety monitoring, and understanding the spread of COVID-19 variants. These are large-scale mission-critical systems that have millions of end users and they need to be secure, scalable, and developed fast.

This session will provide an overview of Oracle APEX with a complete demonstration of how you can build applications on the same cloud infrastructure and database technology as these essential pandemic response systems.

Learn how Oracle APEX eliminates the enormous complexities of developing and deploying enterprise apps and enables to focus on solving your business problems with less code.

Enterprise-class Low-Code with Oracle APEX

In this workshop, you learn how to quickly and easily create a Shopping Cart application with Oracle APEX. Using the Shopping Cart app, administrators can manage products, customers, and stores. On the other side, customers can review and add products to the Shopping Cart and eventually proceed to checkout. You start with installing a sample dataset and then build the app with some pages such as Dashboard, Products and multiple reports. Then, you add pages such as Orders and Shopping Cart. Lastly, you will be updating some of the components to improve the initial app.

Building a Shopping Cart App in 90 mins with Oracle APEX! (Hands-On Lab)

Oracle APEX is a low-code development platform that enables you to build scalable, secure enterprise apps, with world-class features, that can be deployed anywhere. Using APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value. APEX 21.2 includes a plethora of new features designed to make it faster and easier to build and deploy web apps. In this session, attendees will learn about the new built-in support for progressive web apps (PWA), New Smart Search and Filters Component, REST Service Catalog, Data Packaging and Migration and many more! Through live demo, Chaitanya will take you through some of the most compelling new features of APEX.

Oracle APEX 21.2 New Features

Oracle APEX aims to empower developers with the tools they need to build beautiful, responsive, accessible apps without becoming experts in HTML, CSS, or JavaScript. In this session, you will see first-hand how you can build compelling apps that use the same design patterns used by some of the most popular apps. However, we'll do all of this in a fraction of the time while using native out-of-the-box capabilities of APEX with a pinch of CSS. Along the way, we'll also explore several new features and improvements to APEX and Universal Theme and how you can apply them to build apps that are a delight to use.

Delivering a World-Class User Experience with Oracle APEX

Canada

Cloud bill could be an unwelcome surprise at the end of the month if you didn't keep eyes on the resources and cost. We have some native tools and reports embedded into the cloud management layer, but it might not be sufficient if you want to analyze and predict the cost. One way is to use the Oracle cloud-free tier to create a data pipeline with APEX frontend for the custom billing and usage reporting interface. I will share my experience and challenges working with Oracle usage reports and cloud API while creating my APEX billing application.

Billing dashboard in the cloud using APEX and OCI free tier.

How can we consolidate our data from different Oracle OLTP systems in a cloud data lake or data warehouse? What tools should I use for that? How is Kafka different from the Google Data Stream and GoldenGate? We will try to answer those questions and discuss differences and similarities between the Confluent Oracle CDC connector for Kafka, Google Datastream and Oracle GoldenGate.  We will use an example of replication data from an Oracle database to the Google Big Query.

Three bridges to the cloud. Moving data from Oracle database to the cloud.

Regardless if you are new to APEX or have some doubts working with Dynamic actions this might be a session for you. Today's users have high expectations of modern, rich and responsive apps from they day today exposures. This is exactly what Dynamic actions are for and why they are so loved by devs and end users.

In this session we tack all corners of DA and how they can be utilized in your applications.

Things we will cover:
	Triggering dynamic actions
	Passing data between your DA and PL/SQL
	Debugging
	Best/Bad practices

Any of this does not sound familiar then bring a laptop and join me for this workshop based session

The Usual Suspects - APEX Dynamic Actions ( Workshop)

For some reason we Oracle developers either love JavaScript or we try to avoid using/learning it. This is across the board first hand experience. Why is this?

In this session we will try to look into pure concepts, clarify, close this gap and show why we all should be opened to using it. 

We will touch on things like: 
- how it is included on an APEX page 
- client side vs server side data 
- how to organize code for better re-usability 
- call PL/SQL and passing values  
- built in Universal Theme JavaScript APIs 
- future

Take the next step in your APEX JavaScript familiarization. 

JavaScript in APEX for PLSQL developers

Oracle APEX low-code platform delivers on the promise of low code with capabilities that are sought after by many data and developer personnel, who are short of time, and value a fast and quick turnaround response.  Low code is not the answer for every enterprise application, but for many use cases, low code delivers a better app in less time and with less effort. To help illustrate a variety of fast low Code capabilties, we will discuss the following: Building an App from a Spreadsheet, Building an App from QuickSQL, REST APIs, JSON, and also kick starting from an existing Application.

Oracle APEX, Low Code Platform

You will hear how to Get on a Minimal Viable Product (MVP) Journey with Oracle's Cloud Platform, where the horizontal and vertical engineering nature of our Cloud Capabilities means organisations can fast learn and validate, what is possible both from a Business and Tech outcome perspective. We will discuss Example Iterative Approaches, that guides the learning and validating through the MVP Journey, using a variety of recent Organisation Engagements.

Creating a Minimal Viable Product with Oracle Cloud

A volunteer team is tracking COVID-19 exposures in Finland. The data is stored in the Oracle Autonomous Database and shown using Oracle Application Express (APEX). 
How was the the application built and how does it work?

Tracking COVID-19 Exposures in Finland using Oracle Technology

Oracle offers several tools for machine learning. 
There are several options for in-database machine learning: OML4SQL, OML4R, OML4Py, or OML AutoML.
Or you can connect to Oracle database from your favourite IDE with libraries such as cx_oracle.
You can use Oracle Data Science Cloud, or Oracle Analytics Cloud.
So many different options and so hard to choose the right one!
In this presentation we will talk about these options and discuss which of these might be the best fit for you.


Oracle Tools for Machine Learning

In this session you will learn how to develop Data-Driven microservices using your favorite programming language (Java, JavaScript, Python, .NET, and Go) , your favorite framework including Springboot, Micronaut, Eclipse MicroProfile (Quarkus, Helidon) in details then quickly Django, Flask, React, Express, …), and your favorite data model (including relational, JSON, Text, Graph, Spatial, and so on).
The session also discusses how to simplify polyglot data access (multi data models, atomicity of persisting events and state; guarantee exactly once message delivery, data consistency, and parallel updates) in a Cloud Native microservices environment (Kubernetes, …), the related patterns (bounded contexts, event sourcing, CQRS, …) and finally, how to simplify transactions across microservices (SAGA, Eclipse MicroProfile Long Running Actions and compensation).
Examples and references to related code and workshops will also be given.

Design Data-Driven Polyglot Microservices, The Easy Way

Hear the epic story of the Oracle R2DBC Driver: An open source project from Oracle five years in the making.

The first part of this presentation will cover how we got here, from an R&D prototype of an asynchronous JDBC driver to an R2DBC driver on GitHub.

The second part of this presentation will describe the techniques we used to take Oracle JDBC’s code base from synchronous to reactive.

Audience members will learn how to take their own code from synchronous to reactive.

The Making of the Oracle R2DBC Driver and How to Take Your Java Code from Synchronous to Reactive

Learn and watch demos about new Oracle Data Provider for .NET (ODP.NET) 21c features for JSON, bulk copy, and user-defined types support. The new binary JSON data type is optimized for query and DML processing, yielding performance improvements. Managed ODP.NET and ODP.NET Core bulk copy feature enables fast data transfer between .NET and Oracle databases equivalent to a direct path load. And user-defined types in core and managed ODP.NET allow .NET apps to easily use VARRAYs, Spatial objects, and other custom complex data types. This session demonstrates ODP.NET’s newest support for .NET 6 and Entity Framework Core 6.

What’s New for Oracle .NET and Entity Framework Core Developers

The Oracle and Microsoft cloud interoperability partnership enables customer workloads to run across Azure and Oracle Cloud seamlessly. Developers can manage common Oracle Cloud and Oracle Autonomous Database design-time tasks with either Visual Studio or VS Code tools. In this demo-focused session, we will present the Oracle Cloud tool capabilities in both development environments. Then, we will develop and deploy a working Azure web app that connects to Oracle Autonomous Database.

Multicloud Development with Azure and Oracle Database Cloud

In this session learn what histograms are and how they can be useful to you. Topics covered for Oracle Database 11g histograms include frequency histograms and height-balanced histograms. Topics covered for Oracle Database 12c Histograms include challenges with Oracle Database 11g histograms, top frequency histograms, and hybrid histograms. The session also covers Oracle Database 18c/19c/21c histograms

Histograms (In Oracle Database 11g to Oracle Database 21c) Could Be Your Friend

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.

Multitenant 12.1 to Multitenant 21c: Technical Deep Dive

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

Database 12c to 21c, Journey of key feature sets

Java 17 is the latest version of the world’s number one programming language and development platform. Java 17 delivers thousands of performance, stability, and security updates, as well as 14 JEPs (JDK Enhancement Proposals) that further improve the Java language and platform to help developers be more productive.
In this session we will review the essential things you need to know about Java 17.

Java 17 is Hot!

United Kingdom of Great Britain and Northern Ireland

This session describes the journey of migrating critical custom Java applications from Oracle Fusion Middleware and Oracle Databases running in a private data center to Oracle Cloud Infrastructure. Along the way decisions had to be made at all tiers, from the web tier to the database layer. The Oracle Cloud Infrastructure services evaluated included Load Balancer, Oracle Cloud Infrastructure Web Application Firewall, Oracle Java Cloud, Oracle Cloud Infrastructure Container Engine for Kubernetes, Oracle Database Cloud, and connectivity options. Hear about the cloud architecture and deployment patterns that were considered, the challenges overcome, the benefits, and how Oracle Cloud might apply to your use case.

Moving Business-Critical Java Applications to Oracle Cloud

The Co-op is the UK’s leading convenience retailer, with 15 distribution centers and a turnover of £11.2B, servicing more than 10,000 outlets through its retail, wholesale, franchise and home delivery proposition. This session explores the platform built for its mission-critical logistics network including Oracle Real Application Clusters 19c, Oracle Active Data Guard, Oracle Grid Infrastructure bundled agents, and Database File System (DBFS) combined with Oracle Multitenant and Oracle GoldenGate 19c microservices in a Oracle Maximum Availability Architecture configuration, providing real-time replication between operational and analytical systems and the ability to upgrade without downtime. It also examines how the platform evolved with design and pilot plans to migrate its mission-critical platform to Oracle Cloud and also incorporating Oracle Autonomous Database and OCI GoldenGate 21c into its target deployment reference architecture  

On-Premises or Oracle Cloud: How to build a Highly Available and Scalable Logistics Platform with Oracle 19c and Goldengate 19c/21c

Germany

Unit testing is fine, but without proper integration testing, especially if you work with external resources like databases and other services, you might not know how your application will actually behave once it has been deployed to the real production environment. 

Before Docker, configuring the environment for integration testing was painful – people were using fake database implementations, mocking servers, usually it was not cross-platform as well. However, thanks to Docker, now we can quickly prepare the environment for our tests. 

In this talk, I would like to show how you can use Testcontainers ( https://github.com/testcontainers/testcontainers-java ) – a popular JVM testing library that harnesses Docker to easily, reliably, spin up test dependencies.

As a special focus, we want to have a deeper look at the development and the addition of new features to the Testcontainers library in the last year. But that’s not all, we will also share an outlook at the horizon of the future of Testcontainers and might even get a glimpse at some brand new features that are currently in active development.

Come and learn why Apache, Spring, ZeroTurnaround, JetBrains, Playtika, Zipkin and others already decided to use Testcontainers for their integration testing needs!


Testcontainers - The Past, the Present, and the Future (Workshop)

Netherlands

Software engineering is programming with the added dimension of time: programs that can evolve and scale, be maintained and be operated by multiple people over a longer period of time. What does it take to do software engineering in a professional manner - beyond mere programming?

As programmers, our main goal is to make IT work. To translate functional specification into executable code. And sure, that is the least we can do. But we have more responsibility than this. We have to produce software that is robust and will reliably handle expected and unexpected cases. Software that is scalable and can handle expected and somewhat unexpected load gracefully. With minimal operating costs and in the greenest way possible. Software that is observable and manageable and that can be evolved with changing and new functional requirements and with changing technology. Software that will be legacy in the original, positive meaning of the word. That does not depend on the one big brain in our team or on the guy that has been around for three decades. Software that we know is good and can comfortably be modified in a controlled and productive way. We have to grow from excellent programmers to professional software engineers.
 
This session talks about what it takes to create our code with honor. It discusses automation at every level in the build, rollout and monitoring of infrastructure (as code), platform and application, using CI/CD pipelines and DevOps procedures and tools. The session talks about testing – before and during development as well as after each change anywhere in the system and for both functional and non-functional aspects. Test driven development, regression testing and smoke testing are among the concepts discussed. The term ‘clean code’ refers to code that is readable, testable and maintainable. Through code analysis and peer reviews and by performing refactoring we constantly refine our software to be collectively adaptable.

The session demonstrates the concepts discussed with code samples in the context of cloud native programming.

 As software engineers, we have an obligation to society, to our peers and to ourselves to not only write software that does the job, but to create code that is good. Ours is a great and meaningful line of work, especially if we raise our game professionally to code with honor.


Software Engineering as the Next Level Up from Programming (Workshop)

Cloud native applications offer scalability, flexibility, and optimal use of compute resources. Serverless functions interacting through events, leveraging cloud capabilities for persistent storage and automated operations take organization to the next level in IT. This session demonstrates polyglot Functions interacting with native cloud services for events and persistence (Object Storage and NoSQL Database) and leveraging the Key and Secrets Vault, Monitoring and Notifications services for operational control. A lightweight API Gateway is used to expose APIs to external consumers. Infrastructure as Code is the guiding principle in deploying both cloud resources and application components, through OCI CLI and Terraform. This session leverages many cloud native (enabling) services in Oracle Cloud Infrastructure. The session will introduce concepts, then spend most of the time on live demonstrations. All sources are shared with the audience, to allow participants to create the same application in their own cloud tenancy.


What is so great about Cloud Native Applications? How do you create one? I will explain the first and demonstrate the second. On Oracle Cloud Infrastructure, using services that anyone can use for free, I will live create a cloud native application that streams, persists, notifies, scales, monitors


Benefits:
- get to know many different OCI services
- understand the meaning, purpose and benefits of cloud native development
- learn how to take your own first steps in OCI - for free!

Cloud Native Application Development-build fast, low TCO, scalable & agile software on Oracle Cloud (Workshop)

Understand Data mesh concepts and the right way of implementing data lake architecture in the organization

Speaker will discuss data engineering in the organization how data engineering evolves from legacy to modern world. Speaker will speak about data lake, data warehousing, and consumption of data. Explanation of important pillar of data mesh, domain-driven design (DDD), can help solve data lake implementation problems and challenges. How new architecture can solve the issues of data and integration platform.

Speaker will explain the architecture of modern data platforms using cloud technologies, i.e., Oracle/Azure. The session would discuss the future of data engineering and its impact on the organization itself.


Demystifying Data Mesh- Future of data engineering

Japan

In times of a pandemic, it is crucial to understand the spaces = if people have been close enough to each other for long enough to transmit the disease, and the networks = if people have been involved in any cluster or had interactions with each other via any path. Oracle Database is an evolving converged database, which integrates sophisticated spatial and graph capabilities, and it enables us to extract the contact tracing information from a massive amount of geospatial data as well as to analyze the large networks of people to detect the paths and clusters using graph algorithms and queries. Since privacy issues are the concerns over such systems, it is also important to discuss if Oracle Database, one of the most secure platforms, can technically protect the datasets using its access controls, data masking, and encryption. This session will discuss how to maximize the state-of-the-art database technologies to build advanced contact tracing systems against the future threats of infectious diseases.

Contact Tracing – How to Combine Spatial and Graph Technologies

Finding efficient distribution channels and building resilient supply chains have gained much importance these days as various suppliers are involved in different regions and the chain structures get more complex. Graph database technology is expected to be a solution because of its flexible and intuitive nature to manage such networks and hierarchical structures. However, not many people are familiar with data modeling based on graphs, unlike relational databases. For example, it is confusing for beginners what would be vertices or edges.In this session, we will provide a brief introduction to graph database and discuss the modeling techniques and tips using a sample dataset of processed food, Chinese dumpling. We will also explain the advantages of graph-based data models in supply chain analysis, such as the capability of tracing paths and finding the dependencies. 

 "Dumpling Graph" - How to Model Supply Chain using Graph Database

The design process for complex manufacturing products such as automobiles needs many experiments and simulations for step-by-step improvements. Therefore, it is important to manage the relationships between those trials, such as what is modified in this experiment because of the results of another simulation. Such information is often missing because of the lack of a system to handle various types of relationships with flexible annotations. To solve this problem, we developed a data lineage management system, which utilizes the graph features of Oracle Database and provides a unique user interface for visualizing and curating the relationships. The server-side application of this system is written in Java and runs with the database on OCI.
We will provide a brief introduction to and update on Oracle Graph features. Then, we will show demos of the data lineage management system, explaining why graphs are well suited here.  We will share our development experiences, and explore the flexibility and possibilities offered by graph databases. This talk will be co-presented by Ryota Yamanaka from the Oracle Graph Product Management team.

Develop a Data Lineage Management System using Oracle Graph

Graph technologies have become a groundbreaking way for organizations to address uses that other methods simply can’t address in an efficient manner. Gartner selected graphs as one of their top analytics and data trends because of the significant potential for disruption.

Cybersecurity is an important use case in the battle for the cloud. This involves complicated areas such as invalid traffic detection, cyber threat hunting, and malware detection. In this session, we will look at how Graphs can be exploited for modeling public network traffic to detect malicious activity. We will illustrate how we can use Oracle Autonomous Database to (i) build a graph of network activity of IP addresses interacting with other IP addresses, (ii) generate features for nodes (IP packets) in this graph using graph algorithms, and (iii) train a supervised machine learning model using built-in classifiers of Oracle Machine Learning to distinguish malicious packet captures from benign packet captures. We will provide a brief introduction to both Oracle Machine Learning and Oracle Graph. Then, we will show demos of the end-to-end analysis workflow in the notebook environments.

Graphs and Machine Learning for Cybersecurity

Abstract  

Introduction: Money laundering is one of the biggest challenges which creates not only financial impact but also social impact too. Due to the advancement of technology and globalization, this has become more challenging to counter money laundering. For a financial institution, it has become one of the top priorities to have stringent process equipped with right tools and technology to stop the money laundering. Financial institutions already faced a tough time due to fail to meet the AML regulatory compliance. There are so many cases being reported every year which is estimated around 2 to 5% of Global GDP. Recent case of Malaysia 1MDB where Goldman Sachs has to pay over $3bn to Malaysia Govt.  

Most of the AML tools are based on rule based engine. Based on industry standard various level of threshold has been set to generate the SAR and STR reports. The current mechanism is not efficient enough and generating high false positive reports. My research is focus on to recommend the right process, framework, tools and technology to strengthen the AML process. Throughout my research, I will be using Graph technology as how visually and machine learning perspective, it can help Industry to fix the short coming of current AML process. Precisely I want to reduce the high false positive rate by controlling false negative rates. Objective is how accurately I can classify reported SAR and STR reports as money laundering case. Relatively control the high operational and compliance cost. 

 

Methods: My research started with utilizing Graph Visualization reports and finding hidden patterns of transactions among accounts and extract features to improve the accuracy of AML classification modals (Logistic Regression, Random Forest and Multi-Layer Perceptron). Graph Visualization reports help us to find the hidden features layered in the deep of transactions which is contributing as a case of money laundering. Graph help to further enhance the feature extraction process. We further train our modal with new features to improve the accuracy of AML classification modal. Recently we have seen advancement of Graph with Deep Learning techniques. It has emerged as potential tool for AML. During our research, we are trying to leverage Graph Neural Network (GCN, EvolveGCN, SkipGCN, and FastGCN) to further test the accuracy of Logistic Regression and Random Forest modal. Thanks to open source community by exposing data to complete my research. I will use Elliptic Data[1] sets which is mostly related to Bitcoin and data generated by AMLSIM[2] (Simulator to generate mock AML data)

I will be presenting how Graph visualization and Graph Machine Learning  and Graph Neural Network can play a significant role in AML complainces 

Anti Money Laundering using Graph Technology

Graph database offers a different way of looking at data and has become very popular in recent years to gain new insights into the connections and relationships in data. Growing numbers of application developers and data scientists want to access graph capabilities of databases to find clusters, detect paths, and uncover unusual patterns in data, while DBAs need to understand the architecures of different database management systems. The graph feature of the Oracle Database is included without additional license cost, and it enables developers to create graphs from database tables, search for graph patterns, and apply graph algorithms to data. This session is a how-to for DBAs who need to support their organizations in using this feature. We will explain what the graph feature entails, how to install it, what components are necessary, what tools are available, how graph-based queries are translated to SQL, and how database administrators can leverage these capabilities from the command line tools such as SQLcl.

Introduction to Oracle Graph for DBAs

IT environments have evolved rapidly, but existing monitoring and management offerings have not kept up with the increasing complexity found with multicloud and on-premises .
Our integrated platform aggregates all observability data for holistic analysis and optimized ML algorithms that can identify anomalous system behavior, rapidly isolate and remediate performance problems, and prevent outages by providing accurate forecasting of impending issues.


Analyze Logs using Machine Learning techniques

This session explains how to setup Enterprise Manager 13.5 bridge and integrate with Oracle Cloud Infrastructure's (OCI) cloud services to easily utilize target-level data managed by Enterprise Manager and get a 360-degree insight into database and infrastructure resource utilization and capacity. Database Administrators, DevOps, and IT executives can make critical decisions about their databases and infrastructure by leveraging Machine Learning for their Enterprise Manager data. Learn how you can:
1. Analyze resource usage of databases/hosts across the enterprise
2. Forecast future demand for resources based on historical trends
3. Compare SQL Performance across databases and identify common patterns
4. Identify SQL performance trends across enterprise-wide database

Extend Enterprise Manager 13.5 to gain Machine Learning driven Insights

With containerized applications and distributed microservices, it can be challenging to efficiently integrate centralized logging and monitoring services with your application code.
Join this session to learn how Observability and Management platform can help improve efficiency and reduce complexity in OKE environments by adding ML driven actionable insights along with unified monitoring and alarm capabilities for logs, traces and metrics data.

Leveraging Observability and Management platform for OKE

'Extended SpreadSheet dataBASE', cutely known as ESSBASE is a favorite amongst finance users who loves to use Excel and perform rapid scenario analysis to generate insights from multidimensional data sets. Today, Essbase in the cloud extends its integration with Autonomous Data Warehouse and Oracle Analytics Cloud. We begin the session by introducing the audience to Oracle Analytics Cloud and self service their own way to a departmental data warehouse model sourced from Autonomous Data Warehouse. We then introduce the audience to Essbase, through a multi dimensional profitability and cost management model built on top of the departmental data warehouse model, and perform what if analytics and interactive slice and dice through Oracle Analytics Cloud. We end the session by taking the audience through rich mobile experience using the latest Oracle Analytics mobile application, enabling the business to perform visually rich analytics on the go.

Modern Analytics Experience using Essbase, Autonomous Data Warehouse and Oracle Analytics Cloud

Graphs enable intuitive detection of complex relationships and navigation of connections for new insights into your data. Powerful algorithms for ranking, centrality, community detection, and pathfinding are available to analyze data with graphs. In this session, we show you the example of a tax fraud, where modern technology presents new challenges for less-agile governments and provides easy ways to move money across international borders, thus incentivizing criminals even further. Graph technologies can uncover hidden properties and wages that people are trying to hide. For example, an individual may receive wages from several businesses and try to hide some of them. Or he or she may have other investment assets that weren’t disclosed. And when there is income from multiple sources, including rental properties, royalties, partnerships, estates, and trusts, it can be difficult to track all of it and ensure that the right taxes are being paid, especially when there are multiple people involved in the ownership of the assets. Graph technologies can lay out these assets and the people involved to make the relationships between them—and the money owed—clearer. We will walk you through the Tax Fraud Graph that provides an end-to-end view covering how to run graph-based queries and graph algorithms against large-scale graph data, and visualize a graph using built-in cloud-based tools.

Detecting Tax Fraud using Knowledge Graph of Citizens

Enterprises are moving all applications to the cloud; the last to move to the cloud are applications with an Oracle database in the backend. Oracle databases must inevitably move to the cloud. To be successful, you must have cloud knowledge in addition to the DBA skills, and some DBA tasks are not relevant in the cloud. What skills do you need to be a successful Oracle DBA to support Oracle database in the cloud (OCI/AWS/Azure)? What certifications should you aim for? Where do you get the training?

Take your Oracle DBA Career to the Cloud

Migrating Oracle to Azure is the easiest because there are no database services available. You migrate the database to Azure IaaS. When going to AWS, there are two options - EC2 or RDS. Within RDS, SE license included or not, and EE. When it comes to OCI, the choices are even wider, and you have the option to bring your own license (BYOL). Let's discuss the various OCI database services and choose the right database service for your workload. Learn about the Oracle database on Virtual Machine, Bare Metal, Autonomous Database, Dedicated Exadata, and Cloud at your data center. 

IaaS, Oracle DBaaS, Autonomous, ExaCS, Cloud@Customer: How to choose the right database service on OCI? (Workshop)

Security, scalability, and interoperability are few of the main challenges of today's blockchain platforms. Decentralization of services like finance, legal, media, healthcare and others is future, but it still requires trusted partners for mass adoption. This is where Oracle is making big strides to capture the market with some ground breaking products. This presentation covers Oracle's offering in blockchain with focus on smart contracts and cloud.

Oracle Blockchain With Smart Contracts in Cloud

Node.js and TypeScript users will learn how to use Oracle's node-oracledb module to write efficient applications and services for Oracle Database.  Learn about configuration and connection management.  See how best to work with relational data and also with Oracle's latest document-style JSON features.

Creating and Configuring Node.js Applications for Oracle Database

This technical, demo-rich session highlights the popular and full-featured
Python interface for Oracle Database, showing how to create database-backed
applications.  Learn techniques for efficient data loading and access.  Learn
best practices for database connection management.  See how features like Application Continuity improve the availability of applications.

Efficient Data Handling Techniques in Python for Oracle Database

Learn how to install and build Python applications that connect to Oracle Autonomous Database.  This session shows building a web service from the ground up.  It uses the popular Flask framework and shows how connection pooling, batch statement execution, and other unique Oracle features can make the web service scalable and highly available.

Getting Started with Python and Oracle Autonomous Database

This technical session covers performance, scalability and high availability features usable with the node-oracledb interface for Oracle Database.  Message queueing and data-driven notifications will also be discussed.  Node.js and TypeScript users will see how these and other high availability features such as Application Continuity can be used to build resilient applications.

Build High Performance Applications in Node.js for Oracle Database

Oracle Global Data Services (GDS) is an automated workload management feature of Oracle Database 12c/19c that 
provides workload routing, load balancing and inter-database service failover, replication lag based routing, role 
based global services and centralized workload management for a set of replicated databases that are globally 
distributed or located within the same data center. 

Oracle Global Data Services (GDS) - Next Level Services for Applications

Applications developed using APEX, ADF, MAF, JET, MAX, VBCS/VB Studio, Java, JavaScript, or any other development framework can benefit from using the development approach known as "Thick Database" (SmartDB). Thick Database uses the power of Oracle PL/SQL and SQL to centralize business logic in database code. One key technique that can be used to implement these principles is the Table Application Programming Interface (Table API).
 
This session provides an overview of the Thick Database approach and explains its benefits such as reduced cloud database costs, simplification of user interface code, and more efficient and secure applications.

The session then focuses on the code components and strategies in the Table API technique used to isolate code that accesses data. The presentation explains a number of methods for generating a large part of the Table API code and shows examples of generated code as well as code that calls the Table API code.

Using a Pl/SQL Table API to Implement Thick Database Principles

Mobile apps are now the Gold Standard for modern user interface design. Business users now expect the speed and intuitiveness of mobile apps to be in the applications they run at work. In addition, modern business applications may need to support multiple display devices and their mobile capabilities such as orientation change.

This session examines why our application user interfaces using popular development environments--such as APEX, JET, MAF, MAX, VBCS/VB Studio, JavaScript, Java, ADF, or even Oracle Forms--need to comply with principles used in mobile apps. It then reviews standards available from sources such as Oracle for guiding user interface design of new or existing applications so they fulfill expectations for device support and intuitiveness. The discussion includes the role of and principles used for the Oracle Redwood theme.

The presentation also shows examples that demonstrate mobile design principles, and it closes with suggesting resources for further study.

Modernize Your User Interface with Mobile Design Principles

Everybody needs to know about new features certainly. But we distilled the coolest features, not only for DBAs. Often those are not on marketing slides. Most of them are free of charge. And all of them will make your Oracle life much easier.

Brought to you directly from the Oracle Database Upgrade Development team. Of course, free of marketing and buzz words. Just facts and tips.

Oracle 21c Cool Features, not only for DBAs

You will need to upgrade to Oracle Database 19c. No doubt. And no escape. 
And this session is made for you. In 45 minutes you'll get a complete overview on the upgrade to Oracle 19c, with or without the migration to Multitenant. 

Of course, AutoUpgrade is THE tool. But we improved it massively over the past months. Your upgrade experience should be smooth and easy - and we will make sure you get everything important to know. Including tips and tricks from the guys who ran a ton of upgrades already. 

Brought to you directly from the Oracle Database Upgrade Development team. Of course, free of marketing and buzz words. Just facts and tips.

Upgrade to Oracle 19c: From zero to hero in 45 minutes

Did you receive a comment in an SR such as "It is fixed in Oracle 23c". And did you ask yourself what this means as you are just moving to Oracle 19c right now? 

We will shed some light. Such as talk has never been given before. We will give deep insights into the Oracle Database Development process and explain why you don't need to wait for Oracle 23c. We will explain backports and special situations with ports such as MS Windows. And as usual, you will get a lot of tips and tricks.

Brought to you directly from the Oracle Database Upgrade Development team. Of course, free of marketing and buzz words. Just facts and tips.

Why is it fixed in Oracle 23c? Insights into the Oracle development process

In this presentation Ron will introduce Kubernetes and explore the benefits of deploying databases in containers. 
Ron will discuss why databases and stateful applications need to be treated differently to traditional stateless containers and explain how Kubernetes Container Storage Interface (CSI) be used used to this. Ron will demonstrate how we can deploy an Oracle database on a Kubernetes Cluster, sharing code examples and an update on some new exciting Oracle Kubernetes innovations.  


Getting started with Oracle on Kubernetes

I would like to present a few consideration points regarding performance on Oracle 19c/ExadataX7 migration from my experience on a recent large enterprise project as follows:

1. Optimizer migration
 In order for most SQLs running fine with 11g also to run fine with 19c, optimizer has to be properly tuned. I will present how to tune optimizer related initialization parameters from old version.
2. Effective use of smart scan
 I will present the basics of smart scan and some of its restrictions such as fragmented table and delayed block cleanouts. I would also like to present the condition of direct path read and a way to figure out with NSMTIO trace.
3. Keeping stable execution plan with use of pending statistics
 I will present how we used pending statistics to stabilize execution plans, as well as a performance issue of gathering pending statistics and its workaround with SQL patch.
4. Test efficiency with PDB recovery and flashback
 Performance test is time consuming and part of the reason is the time to set up the large test data. I will present how we used multi-tenant PDB level backup/recovery and flashback technology to solve this problem and some lessons learned.

a few consideration points of performance on Oracle 19c migration (Japanese)

Most developers have wanted to contribute to OSSs that they use in their daily work. But it is a challenge for everyone. Sending our code to the big and famous community like OpenJDK makes us nervous. I used to be the same. Additionally I'm Japanese native speaker. So explaining about my code in English is hard. However, I've send patches to OpenJDK community since last year. My patches weren't elegant or cool. I made some mistakes in them, but people in the OpenJDK community properly pointed out my mistakes. After my patches were finally merged, I got fulfillment that I've never felt before. In this session, I will talk about how to start to contribute to OpenJDK and my experiences. Even if you aren't experienced java developer, you can contribute to OpenJDK. In addition, the OpenJDK repository moved to GitHub and changed the development method to pull request based one. It is easier to contribute than before. After this session, you will be able to start contributions!

Let's Start Contributing to OpenJDK from Today! (Japanese)

Korea (Republic of)

cloud security trend.
cloud security architecture ( SASE etc.)
container security and kubernets security
security for oci

Cloud Security 101 (Korean)

Oracle Verrazzano Enterprise Container Platform enables you to create and manage multi Kubernetes clusters with containerized WebLogic/Coherence/Helidon and other Java microservices as well as other java/non-java general applications. Verrazzano can span public cloud, private cloud and on premises environments and you can create hybrid cloud applications easily. This session shows you what benefits Verrazzano has and how to use it. 

Managing Multi Kubernetes Clusters with Verrazzano (Japanese)

Jordan

The data held in your Databases is an integral part of every application, so why aren’t we talking about it more when it comes to DevOps, and including DBAs in this important conversation? In this session learn why the database has been left behind and the special challenges it presents when it comes to delivering value quickly. Explore the similarities to application development and see that even though there are challenges, it is possible to include your database in DevOps processes such as version control, continuous integration, and continuous delivery.


Database Automation, is this even Possible ? 

Kubernetes is an open-source container orchestration platform that enables the operation of an elastic web server framework for cloud applications. Kubernetes can support data center outsourcing to public cloud service providers or can be used for web hosting at scale.

It's trending technology now Learn the basics of the kubernetes and try to understand how to use it.

Kubernetes in Depth But in simple way

Many Machine Learning tasks need to access a lot of data set, which in many cases are stored in a database such as Oracle Database.  It makes a more scalable solution to do the machine learning task in the database, which is called in-database machine learning.  Oracle Autonomous Database comes a library of Oracle machine learning algorithms and a set of building tools such as SQL notebooks  for machine learning.  This allows Data scientists to run Machine Learning projects in Oracle Database without moving data. This session will examine Oracle Machine Learning as part of Oracle database  as well as Oracle Autonomous Database . We will discuss process of machine learning:  analyze and prepare data set;  build and evaluate and apply machine learning model. We also will discuss the  Oracle machine learning features in Oracle 21c such as  AutoML for In-Database Machine Learning and newly added in-database machine learning algorithms for anomaly detection, regression, and deep learning analysis. 

In-database Machine Learning with  Oracle Database and/or Oracle Autonomous Database (Chinese)

The Latest Persistent Memory such as Intel Optane Persistent Memory (PMEM) combines near-DRAM performance with the data persistence of storage. It can be configured in memory mode or application direct mode.  When the memory mode is used, PMEMs can be considered as volatile and can be used as main memory and DRAM is treated as a write-back cache. PMEMs can also be configured in application direct mode to store database files and redo logs. This presentation will discuss the use cases of PMEM:1)  In memory mode use PMEMs for Oracle In Memory store ;2) in Application direct  mode to store the database files, namely persistent Memory Database in  Oracle 21c. We will discuss the significant performance benefits that can be achieved from either of these two modes. We will discuss the Persistent Memory Database feature that includes directly mapped buffer cache and Persistent Memory Filestore (PMEM Filestore) in Oracle 21c. We will also discuss how PMEMs are used in Oracle Exadata X8M

Boosting Database Performance in Oracle 21c Database with Persistent Memory

Boosting Database Performance in Oracle 21c Database with Persistent Memory (Chinese)

In-database Machine Learning with  Oracle Database and/or Oracle Autonomous Database  

Oracle APEX 是世界上最流行的企业级低代码开发平台，在全球每个行业都有广泛采用。 它不但适用于公司部门小型需求，而且可以开发大型企业应用。

我们将会回顾用 Oracle APEX 开发的软件被在这次疫情里发挥的巨大作用： 管理疫苗分发，疫苗安全监控，和跟踪 COVID-19 病毒变种。
这些至关重要的大型软件被几百万人使用，必须安全，可扩展，且能被快速开发。

本次专题将展示如何在云服务（上述疫情响应系统使用的）上用 Oracle APEX 快速构建应用。
了解这个产品如何去除复杂性，部属企业级应用，专注于用更少代码解决问题。

用 Oracle APEX 实现企业级低代码快速开发应用 (Chinese)

带你创建一个购物车应用。由管理员来管理产品，客户和商店。客户可以浏览并购买。

用 Oracle APEX 快速开发购物应用 (Chinese - Hands On Lab)

Oracle Data Pump is one of the most widely used DBA-oriented features of Oracle Database, combining powerful flexibility with high speed movement of data and metadata into and between Oracle databases. Even if you already use Data Pump, have you ever wondered how it works internally, or why it behaves the way it does? If so, then this deep dive into Data Pump internals is for you! We will delve into the inner workings of this widely used utility to look at topics such as:
- the different types of parallelism: what are they, when are they used, what are the pros and cons of each?
- object filtering with EXCLUDE/INCLUDE: what is possible, what is not?
- dumpfile file versus network mode: what's the difference, and why?
- what is in the Data Pump Control table, and how is it used?

Join Oracle Data Pump product management for a deep dive into these topics and perhaps more. You'll have a better understanding of this important tool for managing your databases.

Oracle Data Pump Internals

Oracle Data Pump is one of the most widely used features by DBAs, and comes free as a part of every database edition. With each release more features and functionality are added to help move large volumes of data and metadata between and into Oracle Database. This session will cover the new features added to Data Pump for Oracle Database 21c Cloud and on-premises and present two cloud migration demos. It also covers several Data Pump best practices and the 19c "SuperPatch" merge patch. Time and interest permitting, it can recap highlights of the new features in 19c, 18c, and 12.2.0.1. Whether you use Data Pump for table-mode exports, schemas, full databases, or transportable tablespace migrations, you will find new features to make your work faster and easier than ever before!

What's New in Oracle Data Pump?

Oracle Data Pump is widely used by DBAs to move tables, schemas, and even entire databases from one Oracle Database to Another. But, even if you are familiar with Data Pump, we will bet that there are some features that you might not be be using to their fullest potential. This session will cover some of the lesser known, "unsung" features of data pump that will help you unlock the power of this versatile utility. Some of the features we will discuss and demonstrate are
- the TRACE parameter and its use in debugging issues
- the interactive command line interface
- the DBMS_DATAPUMP API
- important and helpful patches for Data Pump on Oracle Database 19c

Whether you are a casual user or a power user of Data Pump, you're sure to learn something that will come in handy in your export or import scenarios.

Secret Features of Oracle Data Pump

Learn how to migrate on-premises Database with confidence to Autonomous, to ExaCC, to DBCS bare metal or VM, and to Exadata on-premises. Use Oracle expertise built into the Enterprise Manager Migration Workbench to evaluate the readiness of database assets to migrate, then use recommended migration technology, and validate results meet your expectations. Make migrations secure, efficient, and agile while reducing the risks of human error. Find out how to assess source database configuration, leverage built-in migration technology to transfer data, and validate the performance of the migrated databases.

Use Oracle Enterprise Manager Migration Workbench to:
• Prepare: Evaluate database migration readiness, dependencies, shapes and pre-requisites
• Migrate: Prepare databases for migration, use appropriate migration methods
• Analyze: Validate results, compare performance and configuration to the source database

If you are migrating databases within a data center or to the cloud, join this session for insight from Oracle experts. This session will include demonstrations and dedicated time to answer your questions.

Migrate Databases with minimal downtime using Migration Workbench

Learn best practices to secure database estates while cutting manual effort for patching, and compliance using pre-built automation to address critical security vulnerabilities, minimize operational expenditure, and reduce maintenance window

During this webcast, attendees will learn how to:

- Use automation to stay current with software updates for your database fleet
- Proactively patch and upgrade database environments to address critical security vulnerabilities
- Identify vulnerable assets, prioritize vulnerability regression, and remediation management
- Achieve CIS, STIG regulatory compliance and security business objectives for databases

Are you a Security Administrator or Database Administrator? This session is for you, learn best practices to protect data and be compliant with enterprise policies.

Automated patching and compliance to improve database security

Discover how DBAs are scaling database lifecycle by standardizing and provisioning multitenant databases in their enterprise on Exadata and other platforms.

Gain technical insights into how to build a DevOps environment for end users to deploy standardized pluggable databases on-demand via self-service interface while achieving maximum resource utilization and standardization.

During this session, attendees will learn ways to use Oracle Enterprise Manager to automate provisioning for Multitenant Databases on Exadata, and Exadata Cloud@Customer

- Manage database configuration drift to improve security and performance
- Automate Multitenant database lifecycle management at scale to reduce DBA efforts
- Enable self-service provisioning for rapid deployment, standardization, and error proof deployments
- Improve storage utilization and performance efficiencies using Snap Clones

Are you a Security Administrator, System Administrator or Database Administrator? This session is for you, learn best practices to enable standardized deployment of multitenant databases on-demand



Automate Standardized Multitenant Database Operations to increase efficiency, scale, and security

One the most impressive and exciting database innovations introduced in Oracle Database 19c is "Automatic Indexing", an expert system built into the database engine that not only recommends potential new indexes to create, but will actually introduce new indexes in a safe and automated manner. This session explores in-depth this ground breaking feature, detailing how Automatic Indexing works, how it can be deployed and highlights a number of improvements and new capabilities that have been introduced since Automatic Indexing was first released. Attendees will gain an excellent appreciation of the power to Automatic Indexing and how this feature can substantially assist in reducing the risk of having an sub-optimal indexing strategy that causes performance implications.

Automatic Indexing: An Update On Improvements and New Capabilities

One of the critical questions with which business owners are faced is how quickly applications will be back online in case of a planned or an unplanned Disaster Recovery (DR) scenario, affecting an entire site hosting many components like Oracle Databases, Oracle Weblogic Servers, and Oracle as well as non-Oracle applications. An answer to this question will be challenging, as multiple factors have to be considered; for example, DR planning, runbook readiness for various components, availability of experienced personnel, level of established automation, etc. That is why Oracle provides a one-stop answer to automate your end-to-end disaster recovery operations - Oracle Site Guard. Join this session to discuss the challenges of business continuity and how Oracle Site Guard as part of Oracle's Maximum Availability Architecture (MAA) can help to overcome those challenges. The session also includes a demo.

Oracle Site Guard- Business Continuity at Scale

New features always sound great and slides always work, but can these features convince in real life? At Oracle, we do not believe in hiding behind fancy slides. Instead, we put our latest technology out there for you to test - via Oracle LiveLabs. This session will highlight and walk you through an overview of available Oracle LiveLabs, which will give you access to Oracle's tools and technologies to run a wide variety of labs and workshops. Experience Oracle's best technology, including high availability and disaster recovery solutions - live!

Testing is Believing - Oracle LiveLabs

Is your infrastructure composed by a mix of Oracle products and Open Source RDBMS such as MySQL, MariaDB, PostgreSQL, Galera Cluster? Do you want to have a single monitoring tool which supports in the same way several database technologies? Do you need to ensure that your system's healthy is good and to spot your performance issues at a glance? 
Percona Monitoring and Management tool (PMM) is a free and Open Source software for monitoring, alerting and graphing your databases using some integrated tools such as Grafana and VictoriaMetrics. 
Let's have a look...

Oracle Groundbreakers APAC Virtual Tour 2021

Speakers

Connor McDonald

Maria Colgan

Francisco Munoz Alvarez

Rich Niemiec

Fernando Simon

Stefan Oehrli

Ricardo Gonzalez

Aman Sharma

Veeratteshwaran Sridhar

Aishwarya Kala

Julian Dontcheff

Shay Shmeltzer

Christina Cho

Chaitanya Koratamaddi

Shakeeb Rahman

Gleb Otochkin

Lino Schildenfeld

Franco Ucci

Heli Helskyaho

Kuassi Mensah

Alex Keh

Anuj Mohan

Ali Parvini

Nikitas Xenakis

Kevin Wittek

Lucas Jellema

Vinay Kumar

Ryota Yamanaka

yuri hashi

Ashwini Raju

Gautam Pisharam

Biju Thomas

Fahd Mirza

Christopher Jones

Sharad Chandran Raju

Venkata Ravi Kumar Yenugula

Peter Koletzke

Mike Dietrich

Ron Ekins

Kazuhiro Takahashi

Koichi Sakata

suk kim

Takashi Ito

Osama Mustafa

Kai Yu

Kyle Huh

Roy Swonger

Harish Niddagatta

Richard Foote

Suraj Ramesh

Dominik Junkermann

Elisa Usai

Brian Spendolini

Karen Cannell

Adrian Png

Gustavo Gonzalez

Basheer Khan

Rampradeep Pakalapati

Venkanna Mittakanti

Abhijit Khuperkar

Olivier Perard

Maarten Mulders

Phil Wilkins

Bhupendra Mishra

Roy Salazar

Edelweiss Kammermann

Jinrong Ye

Yuan Yao

Tingkun Yang

Weizhao Zhang

Chen Chen

Jianrong Yang

Alex Blyth

Gavin Parish

GAVIN SOORMA

Patrick Barel

Nelson Calero

Sean Scott