INSYNC:
March 30 - April 1, 2021
INSYNC connects technologists, developers and DBAs to product experts, industry innovators, Oracle product teams, and technology leaders for 3 full days of online education and networking.
Education sessions at INSYNC
DevOps & Deploy
Working on database and/or application development means learning multiple languages and performing a balancing act between Web-based, wireless and client/server applications. What will give you the edge to create successful applications? Do you use the Oracle suite of tools, or do you need to look for something that you can integrate? And how will your applications be used? With wireless technology? Through a portal? Will your forms and reports be used on an intranet or on the internet? This track covers the topics that surround the development and deployment of your applications.
Keynote and Roadmaps:
INSYNC Kickoff: Oracle Data Management Strategy
Presented by Jenny Tsai-Smith, Oracle America, Inc
Abstract:
Oracle has a history of delivering data management solutions of choice for managing customers’ operational and analytical workloads on-premises and in the cloud. Jenny Tsai-Smith, Vice President of Database Product Management, shares Oracle’s strategy for continuing to deliver truly unique and innovative products and services to meet and exceed customers’ requirements.
DevOps & Deploy sessions at INSYNC:
Advance Analytics and Machine Learning on Logs for Everyone!
Presented by Kumar Gaureve Varun, Oracle America, Inc
Abstract:
Hands-On Lab: Using Oracle Machine Learning for Python on Autonomous Database
Presented by Marcos Arancibia & Mark Hornick, Oracle America, Inc
Abstract:
In this Hands-on Lab, join us to experience Oracle Machine Learning for Python (OML4Py) on Oracle Autonomous Database. OML4Py supports scalable, in-database data exploration and preparation using native Python syntax, invocation of in-database algorithms for model building and scoring, and embedded execution of user-defined Python functions from Python or REST APIs. OML4Py also includes the AutoML interface for automated algorithms, feature selection, and hyperparameter tuning. In this six-part lab, explore the range of Python-enabled functionality and see how Oracle technology can support your data science projects.
Introducing the New Faces of Oracle Machine Learning
Presented by Mark Hornick, Oracle America, Inc
Abstract:
In-database machine learning offers automation, scalability, and ease of deployment. With the arrival of 21c, there are a few new “faces” to Oracle Machine Learning (OML) to take you further in your data science projects. OML on Autonomous Database introduces a Python API, a no-code AutoML user interface, and a database-external model deployment REST interface. With OML for Python, data scientists leverage the database as a high-performance data science compute engine – minimizing data movement – as well as benefit from powerful automated machine learning. OML AutoML UI places a no-code user interface in the hands of data scientists and non-expert users as a productivity tool to automate the modeling and deployment process. OML Services provides REST endpoints for model management and deployment along with cognitive text analytics. Join us for this OML overview with demonstrations.
Microservices Distributed Tracing: from traces to operational insights
Presented by Avi Huber, Oracle America, Inc
Abstract:
Microservices delivered in containers are the de facto pattern for rapid development with scalable software deployment. Open-tracing and Distributed Tracing Systems help developers address the challenges involved with diagnostics of such deployments. Trace data gives the developer insight into the execution of individual transaction instances. Data mining of the vast number of collected traces, and the event data attached to them, can provide rich operational information, far beyond the diagnostic use case.
Learn how to implement Open-tracing utilizing the new Oracle O&M platform APM Service. Learn how to extend the monitoring to older, legacy java components, as well as modern Single Page Application. See how to use the trace data for EUM, diagnostics, monitoring, planning and reporting.
Learn how to implement Open-tracing utilizing the new Oracle O&M platform APM Service. Learn how to extend the monitoring to older, legacy java components, as well as modern Single Page Application. See how to use the trace data for EUM, diagnostics, monitoring, planning and reporting.
A developers guide to Oracle RAC
Presented by Anil Nair, Oracle America, Inc
Abstract:
This session will introduce Oracle RAC in the context of Developers attempting to use Oracle Database. The session will cover tips and tricks to ensure that developers can benefit from features like session failover, load balancing with minimal effort
Accelerating Oracle workloads on VMware Hybrid Clouds with Vmware vSphere Performance Accelerators
Presented by Sudhir Balasubramanian, VMware
Abstract:
Enabling and sustaining the highest possible performance along with continued application availability is a major goal for all mission critical applications in order to meet the demanding business SLA’s. Harnessing key features in the latest vSphere release 7.0 U1 including Persistent memory, Para Virtualized RDMA , 1GB Huge Pages, vNVME Controll ers, Improved Distributed Resource Scheduler (DRS), Assignable Hardware, Refactored vMotion etc helps achieve those stringent business goals. This session discusses accelerating Oracle Enterprise IO intensive workloads with vSphere 7.0 new features enhancing high availability, faster data loading etc and share key considerations and lessons learned.
Advanced Docker Recipes: Building Complex Oracle Environments
Presented by Sean Scott, Viscosity North America
Abstract:
Oracle provides a number of “vanilla” recipes in the Docker repository but these don’t cover the needs of modern enterprises. This presentation discusses methods for creating images to support Data Guard, OEM, APEX, Sharding, rapid container deployments, Gold images, and transportable datasets. Participants will learn how to develop and customize Dockerfiles and orchestrations and apply them to their needs.
Billing dashboard in the cloud using Apex and OCI free tier.
Presented by Gleb Otochkin, Eclipsys Solutions
Abstract:
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 cloud API and usage reports and creating my Apex billing application.
Building Generic Search Screen via Dynamic SQL
Presented by Michael Rosenblum, Dulcian Inc
Abstract:
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.
Building Reliable Oracle GoldenGate Environments using Docker
Presented by Bobby Curtis, RheoData
Abstract:
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.
Deep dive into SQL tuning
Presented by Gary Gordhamer, Viscosity North America
Abstract:
Have you had that one SQL statement that you just couldn’t figure out what the Oracle optimizer was thinking? In this session we will take a deep dive into doing a trace and talk about some of the sledgehammer methods to influence the optimizer. You may not find the solution to that one nagging SQL but we will cover how the optimizer frustrated you so. Using these tools along with Oracle’s SQL Plan Management or Profiles you may be able to achieve your goals.
Many developers do not understand how to dig into SQL beyond the basic explain plan. Here we will cover the somewhat gory details of going deep inside how the optimizer is making decisions.
Many developers do not understand how to dig into SQL beyond the basic explain plan. Here we will cover the somewhat gory details of going deep inside how the optimizer is making decisions.
From DBA to a DevOps Engineer – a DBaaS ramp up experience
Presented by Martin Berger, Trivadis
Abstract:
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.
Future of IT Monitoring – Observability and Management
Presented by Sai Penumuru, DXC Technology
Abstract:
For IT management, one of the most valuable changes in the transition from reactive to proactive and ultimately to predictive intervention – fix the faults before they occur – or at least before anyone knows. The simple truth is that IT monitoring will increasingly become a critical element in an organization’s overall digital business service delivery strategy. Attend this session if you want to not only survive but to thrive with the rapid pace of change occurring on the path toward an increasingly digital future. The presentation will cover Oracle Cloud’s new Observability & Management Platform. The Oracle Observability & Management provides comprehensive visibility and actionable insights across all stack layers, deployed on any technology, anywhere.
Getting Started with Oracle on Docker
Presented by Sean Scott, Viscosity North America
Abstract:
Docker is widely embraced in the developer community but less well known or understood in the database world. Database administrators and developers are beginning to realize how powerful containers are and the speed, flexibility, and portability advantages they offer over virtual guests.
This session is a practical course for those curious about or just starting out with Oracle on Docker. Attendees will learn terminology and understand how containers differ from virtual machines, followed by demonstrations of Docker’s speed and versatility. Explore basic commands and examples for building Oracle on Docker and making container databases visible on a network. Discover how to separate and preserve data, share and distribute database images and data, then how to create new databases in seconds (not an exaggeration). The session closes with advice on customizing container environments and a peek into orchestrated builds for multi-database needs posed by Data Guard and Sharding.
This session is a practical course for those curious about or just starting out with Oracle on Docker. Attendees will learn terminology and understand how containers differ from virtual machines, followed by demonstrations of Docker’s speed and versatility. Explore basic commands and examples for building Oracle on Docker and making container databases visible on a network. Discover how to separate and preserve data, share and distribute database images and data, then how to create new databases in seconds (not an exaggeration). The session closes with advice on customizing container environments and a peek into orchestrated builds for multi-database needs posed by Data Guard and Sharding.
Hands-On Lab: Building a Proof-of-Concept using the APEX Service
Presented by Monica Godoy, Oracle America, Inc
Abstract:
This workshop starts with a napkin design of data structures we would like to use for a proof-of-concept. Using Quick SQL you will quickly define the data structures and utilize various table and column directives to better define the tables and also create some dummy data. You will then be creating an application based on the new tables. Lastly, you will be updating some of the generated components to improve the initial app.
In this lab, you will learn how to:
-Create an APEX Service
-Define new tables and views
-Create an application on the new data structures
-Refine the application
In this lab, you will learn how to:
-Create an APEX Service
-Define new tables and views
-Create an application on the new data structures
-Refine the application
Insider’s Guide to Maximizing SQL Performance
Presented by Ashish Agrawal, Oracle America, Inc
Abstract:
Automatic Workload Repository (AWR), Active Session History (ASH) and SQL monitoring hold a wealth of SQL performance data. OOCI Operations Insights SQL Warehouse leverages the rich SQL data in AWR, ASH, data using purpose-built machine learning to provide unique insights into SQL performance problems for your enterprise databases running on premise or on cloud. In this session learn to recognize patterns of SQL performance issues across all your Oracle Databases; perform a historical, comparative analysis to find any SQL bottlenecks or plan regression; and identify SQL performance anomalies.
Keep Your Code Low, Low, Low, Low, Low: Getting to Digitally Driven With Oracle Converged Database
Presented by Jim Czuprynski, Zero Defect Computing, Inc.
Abstract:
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. This session explores the myriad facets of a Converged Database strategy and what it means for your career’s future path, regardless of whether you’re an application developer or DBA.
Through presentations and online demonstrations, this session illustrates how to:
– Leverage the strategy behind Converged Database to help your IT shop become truly digitally driven
– Access data in any format virtually anywhere with utmost security using Oracle’s EXTERNAL table methodology
– Take advantage of Oracle APEX application features like Web Source Modules and Plug-Ins to build robust applications without deep knowledge of JavaScript
Through presentations and online demonstrations, this session illustrates how to:
– Leverage the strategy behind Converged Database to help your IT shop become truly digitally driven
– Access data in any format virtually anywhere with utmost security using Oracle’s EXTERNAL table methodology
– Take advantage of Oracle APEX application features like Web Source Modules and Plug-Ins to build robust applications without deep knowledge of JavaScript
Managing the Earthquake: Surviving Major Database Architecture Changes
Presented by Michael Rosenblum, Dulcian Inc
Abstract:
Every long-term IT project reaches a point when one or more fundamental concepts that define the whole system are no longer true. If the business is lucky, this may lead to a brand new development project. If not, the current system must be altered to support requirements for which it was never designed. This presentation discusses how to mitigate possible design-time risks using available technologies and concepts from a database perspective, such as repository-based solutions, code generators, abstract models, micro-SOA, etc. The presentation will also cover real-life examples of best practices for handling unexpected architectural shifts based on systems with 10+ years of life span.
Migrate, Consolidate and Analyze Databases with Confidence using Enterprise Manager
Presented by Abilash Rengasamy, Oracle America, Inc
Abstract:
Oracle is revolutionizing how data is managed with the introduction of the world’s first self-driving database. Oracle Enterprise Manager offers a unified, cost-effective, and easy way to automate the migration of your on-premises database workloads to the next generation of the industry-leading database, Oracle Autonomous Database and Database Cloud Services running on Exadata Cloud@Customer and OCI, eliminating human labor and error. For Database Cloud Services, Enterprise Manager helps DBA’s move to Multitenant, consolidate Databases or Infrastructure on OCI Cloud and also assess the success of the migration. Reap benefits from seamlessly transferred configurations, periodic synchronization of data with production, and “time travel” capabilities such as rewind/refresh. Join this session to learn more.
Multitenant PDB and Schema Provisioning aaS with Ansible
Presented by Timo Giese, Fiducia & GAD IT AG
Abstract:
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.
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.
Oracle DB 21c, PMem and Caching
Presented by Douglas Hood, Oracle America, Inc
Abstract:
Learn how Intel Optane Persistent Memory works with Oracle Database 21c. See how to configure your Oracle database for faster writes with a PMem filestore.
Understand the difference between PMem App Direct Mode and Memory Mode. Compare Oracle 21c with DRAM + SSD vs PMem vs TimesTen Cache for OCI and JDBC workloads.
Understand the difference between PMem App Direct Mode and Memory Mode. Compare Oracle 21c with DRAM + SSD vs PMem vs TimesTen Cache for OCI and JDBC workloads.
Oracle Maximum Availability Architecture (MAA) SIG
Presented by Alfredo Abate, BBB Industries, Anil Nair, Oracle America Inc, & Markus Michalewicz, Oracle America Inc
Abstract:
Join us for the Oracle Maximum Availability Architecture (MAA) Special Interest Group (SIG).
Preparing for Oracle 21c
Presented by Rich Niemiec, Viscosity North America
Abstract:
This presentation will focus on preparing for the Oracle 21c database and new features such as AutoML, In-Memory Advancements, Data Guard standby DML, Result Cache on the Standby, Big Data SQL, and other features. This presentation will also look at a few 19c/18c new features that should be in use now before you get to 20c. We’ll look at how Machine Learning and Autonomous Database will change the role of the future DBA. Emerging information technology trends for the cloud have the power to transform organizations. In the data management and analytics space, a key cloud service offering has arrived. Oracle Autonomous Data Warehouse (ADW) Cloud & Oracle Autonomous Transaction Processing (ATP) simplifies the provisioning, maintenance, and optimization for data warehouse workloads in the cloud, and promotes low touch for database administrators and load and pull approaches to data analytics.
Voyage to Visual Builder Studio: Impressions from an APEX Gal
Presented by Karen Cannell, TH Technology
Abstract:
Hear lessons learned on an APEX gal’s voyage to Visual Builder Studio, Oracle’s updated cloud-based visual application development environment, the new path to using Visual Builder. VB Studio allows one to build web and mobile applications, extend Oracle cloud applications, and manage the full development life cycle in an integrated, collaborative environment. Sounds great – but how does it really work?
What is the difference between VB Studio and VB? When do I use one vs. the other? How hard is it to get started? How hard is it build a real production application? How hard is it to extend my cloud applications? Do I have to be a JavaScript expert? What investment – time, money, learning – is required to be productive? Was this voyage worth the effort? Can VB Studio make a difference for one’s Oracle cloud investment? Attend and learn about a long-time Oracle APEX developer’s continued adventure into VB and VB Studio.
What is the difference between VB Studio and VB? When do I use one vs. the other? How hard is it to get started? How hard is it build a real production application? How hard is it to extend my cloud applications? Do I have to be a JavaScript expert? What investment – time, money, learning – is required to be productive? Was this voyage worth the effort? Can VB Studio make a difference for one’s Oracle cloud investment? Attend and learn about a long-time Oracle APEX developer’s continued adventure into VB and VB Studio.
Observability and Management Deep dive for DevOps
Presented by Gagan Chawla, Oracle America, Inc
Abstract:
IT environments have evolved rapidly, but existing monitoring and management tools have not kept up with the increasing complexity found with multicloud and on-premises IT environments. Oracle Cloud Infrastructure(OCI) provides comprehensive visibility and machine learning-driven actionable insights to ease management across all layers of the stack deployed on any technology, anywhere. Oracle’s integrated solution for DevOps monitoring and IT operations management makes it easier to prevent and solve problems. Learn how to get started and improve IT efficiency, identify code level performance issues faster, and reduce complexity.
Terraforming the Cloud with OCI Resource Manager
Presented by Roopesh Ramklass, Eclipsys Solutions
Abstract:
Infrastructure as Code (IaC) is the future of cloud based architectures. This talk aims to empower learners to embrace IaC solutions. Leveraging Terraform and the OCI Resource Manager, attendees will deploy OCI infrastructure including VCNs, subnets, VMs and an autonomous database using a few lines of code. The opensource visual designer tool okit will also be introduced and shared with the audience.
From Cloud to Conversational: Transforming your Oracle Forms
Presented by Mia Urman, AuraPlayer
Abstract:
The death of Oracle Forms has been greatly exaggerated. Despite 2 decades of development, Forms is still the backbone of thousands of mission-critical applications worldwide. But where do our tried and true Forms stand while all systems are undergoing a user experience revolution or moving to the cloud? In this session, we will show how Oracle Forms is now a full member of Oracle’s cloud, mobile, and even Chat ecosystem. We will review the 4 ways that you can extend your existing Forms investments to the cloud, including:
1. “Lift-and-Shift” your Forms servers to Cloud Servers – OCI
2. Extending your applications using Oracle’s rapid development tool Visual Builder Cloud Service (VBCS)
3. Leveraging existing business logic through Chat interfaces using Digital Assistant cloud service
4. Doing DevOps using Developer Cloud Service.
The answer to how to bring your Forms into the next generation will be revealed during this session. Along with live demos and Q&A
1. “Lift-and-Shift” your Forms servers to Cloud Servers – OCI
2. Extending your applications using Oracle’s rapid development tool Visual Builder Cloud Service (VBCS)
3. Leveraging existing business logic through Chat interfaces using Digital Assistant cloud service
4. Doing DevOps using Developer Cloud Service.
The answer to how to bring your Forms into the next generation will be revealed during this session. Along with live demos and Q&A
Infrastructure as a Code with the help of emergent technologies
Presented by Francisco Munoz Alvarez, CloudDB & Avi Miller, Oracle
Abstract:
Infrastructure as code is the process of managing and provisioning computer data centers through machine-readable definition files, rather than physical hardware configuration or interactive configuration tools (by Wikipedia). On this vibrant session you would learn the differences between “configuration orchestration” and “configuration management” tools, and how emergent technologies such as Vagrant, Terraform, and Ansible fit and can be used to define, manage and provision a datacentre infrastructure or even build and maintain portable virtual environments.
The future is here, let’s take advantage of it today!
The future is here, let’s take advantage of it today!
Database
The relational database continues to evolve to include more new features, and as a result, has become even more complicated. On top of all the daily challenges of maintaining a high performance database, now you have to be sure the data are available 24/7 and compatible with other systems. This track is designed to provide DBAs of every experience level and industry with the tools to productively and creatively administer your data.
Keynote and Roadmaps:
INSYNC Kickoff: Oracle Data Management Strategy
Presented by Jenny Tsai-Smith, Oracle America, Inc
Abstract:
Oracle has a history of delivering data management solutions of choice for managing customers’ operational and analytical workloads on-premises and in the cloud. Jenny Tsai-Smith, Vice President of Database Product Management, shares Oracle’s strategy for continuing to deliver truly unique and innovative products and services to meet and exceed customers’ requirements.
Database sessions at INSYNC:
Accelerate Oracle Database analytics 80X and use less CPU and IO with the In-Memory feature
Presented by Wayne Martin, IBM
Abstract:
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.
Analytics Using Feature Selection for Anomaly Detection
Presented by Roger Cornejo, Accenture Enkitec Group
Abstract:
Experience an innovative approach which relies on big data and advanced analytical techniques to detect anomalies in performance metrics in order to improve Oracle DB performance. The approach represents a step-change paradigm shift away from traditional methods which tend to rely on a few hand-picked/favorite metrics or wading through a voluminous AWR report. With this innovative process, you can draw on all available performance data to help you draw impactful, focused performance improvement conclusions.
The process targets the most relevant metrics for the problem interval which results in event focused and actionable intelligence on the performance issue, and insight into possible solutions. This method improves on the typical/traditional approaches which monitor a standard set of hard coded metrics; which may cause you to miss important system behavior or configuration that is relevant to the root cause of the performance problem. The speaker will share his process and code.
The process targets the most relevant metrics for the problem interval which results in event focused and actionable intelligence on the performance issue, and insight into possible solutions. This method improves on the typical/traditional approaches which monitor a standard set of hard coded metrics; which may cause you to miss important system behavior or configuration that is relevant to the root cause of the performance problem. The speaker will share his process and code.
CDC Data Integration – Goldengate for Bigdata (Oracle Database to Hadoop, Kafka and MongoDB targets)
Presented by Vivek Pinyani, USCellular
Abstract:
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.
Cloud Computing SIG Meeting
Presented by Erik Benner, Mythics, Inc.
Abstract:
Join us for our Cloud Computing Special Interest Group meeting.
Converged Database Panel
Presented by Rich Niemiec, Viscosity North America
Abstract:
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.
Hands-on Lab: Five (5) Oracle Machine Learning Notebooks You Should Know
Presented by Charles Berger, Oracle America, Inc
Abstract:
Oracle Machine Learning comes free in every Autonomous Database. Oracle Machine Learning Notebooks provide easy to understand, reuse and repurpose ML methodologies that apply OML’s 30+ machine learning algorithms for in-database, parallelized implementations of classification, regression, clustering, anomaly detection, text mining, associations machine learning functions that can be used to tackle a wide variety of data-driven problems and to build “predictive” applications. This session will step through five (5) OML notebooks that can serve as the core of many data science projects: classification, attribute importance, time-series forecasting, text mining and anomaly detection.
In-database Machine Learning with Oracle Database and Oracle Autonomous Data Warehouse (ADW)
Presented by Kai Yu, Dell Technologies
Abstract:
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 Data Warehouse (ADW) 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 ADW . 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.
Introduction to Oracle Database 21c
Presented by William Hardie, Oracle America, Inc
Abstract:
The latest release of the world’s most popular database, Oracle Database 21c, was recently released on Oracle Cloud Infrastructure (including Autonomous Database Free-Tier Service). In this session, we’ll take a look at some of the new features and enhancements that further enable Oracle’s converged capabilities for data driven applications.
Machine Learning 101
Presented by Rich Niemiec, Viscosity North America
Abstract:
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.
New Features in Oracle Database In-Memory
Presented by Andy Rivenes, Oracle America, Inc
Abstract:
Oracle Database In-Memory is targeted specifically at speeding up analytic queries by orders of magnitude over traditional row-based queries. However, it is hard to appreciate all of the features that Database In-Memory uses to make this happen, so join Oracle Product Management in a deep dive that will take you through all of the latest features of Database In-Memory. This session will provide a quick review of Database In-Memory since its introduction in Oracle Database 12.1.0.2, but will primarily focus on the new features introduced in Oracle Database 19c and 21c. With the introduction of the new Base Level Feature, after seeing this session you can go back and try this out for yourself on your own 19.8 and higher databases without having to license Database In-Memory first.
Oracle Machine Learning: Overview, What’s New?, AutoML, Customer Use Cases, Appls & Road Map
Presented by Charles Berger, Oracle America, Inc
Abstract:
Oracle Machine Learning is now a free feature in Oracle Databases (on-premises, Cloud and Autonomous). As part of Oracle’s Converged Database strategy, OML “moves the algorithms; not data” processing data where it resides. Oracle Machine Learning extends Oracle Database(s) delivering 30+ ML algorithms and AutoML functionality via SQL (OML4SQL) and integration with open source languages: Python, OML4Py and R, OML4R. This OML presentation and demonstration(s) highlights existing and new OML features: AutoML, AutoML UI, new algorithms in 21c, OML4Py and OML Services. Now Oracle DBAs, users and application developers can leverage OML’s ML algorithms to discover new insights, make predictions and deploy ML models enterprise-wide via APEX, Oracle Analytics Cloud and embedded in Applications. Come learn how to get started taking immediate advantage of these free and powerful in-database ML capabilities.
SQL and Analytics: A Dynamic Duo
Presented by Roger Cornejo, Accenture Enkitec Group
Abstract:
We are in the midst of a digital disruption. Data-driven organizations are using analytics to add value and generate innovative business ideas using vast amounts of data. Operating as a “citizen data scientist”/“data entrepreneur,” the thoughtful tech person is finding creative new ways to enable companies across the globe to leverage ever-expanding digital repositories. From a data analysis perspective, SQL (a language firmly rooted in relational algebra) is an invaluable tool. It is ubiquitous, and while other languages have attempted to supplant it, SQL remains the language of choice. This is because it is a highly performant set-processing language with capabilities that can be used to produce results far beyond what many realize. Broadly speaking, SQL provides a capability to subset/aggregate/pivot/analyze data, make inferences, and answer questions. A skillful use of this language will enable you to propel your organization forward in this digital era.
Whats new with Oracle RAC
Presented by Anil Nair, Oracle America, Inc
Abstract:
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
19c Database Upgrade ACE Panel
Presented by Gary Gordhamer, Charles Kim & Sean Scott, Viscosity North America
Abstract:
Panel session with:
Charles Kim, Sean Scott, Gary Gordhamer
Oracle Database 19c is the current long term supported release. If you have not upgraded to 19c yet, it’s time to get to work. This panel of three Oracle ACE’s will answer questions and provide knowledge based on their real-world experiences of upgrading customers to 19c over the past two years. Bring your questions about the upgrade process, technical upgrade steps, and performance changes or challenges.
Charles Kim, Sean Scott, Gary Gordhamer
Oracle Database 19c is the current long term supported release. If you have not upgraded to 19c yet, it’s time to get to work. This panel of three Oracle ACE’s will answer questions and provide knowledge based on their real-world experiences of upgrading customers to 19c over the past two years. Bring your questions about the upgrade process, technical upgrade steps, and performance changes or challenges.
A Collection’s a Collection, no matter how small
Presented by Patrick Barel, Qualogy
Abstract:
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.
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.
A Gentle Introduction to Polymorphic Table Functions
Presented by Patrick Barel, Qualogy
Abstract:
Oracle database 18c introduces Polymorphic Table Functions. This session will tell you about Polymorphism. How can you apply this in pre-18c databases? I will show you what problem and the solution when your data or structure changes. I will also show you an example of a Polymorphic Table Function and how this can help protect you from changing table structures and how you can apply the same code to different table structures without changing or even recompiling the code. After this session you will understand when to use which technique.
Achieving Extreme Scalability &Total Fault Isolation with Oracle Sharding 20c/21c
Presented by Kai Yu, Dell Technologies
Abstract:
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 form 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 considerations of choosing 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 .
Best Practices to Maintain Oracle RAC DB Performance Using Oracle 21c Autonomous Health Framework
Presented by Mark Scardina, Oracle America, Inc
Abstract:
This session focuses on how Oracle is applying Machine Learning technologies in Oracle to prevent performance issues and maintain availability. Autonomous Health architectures and algorithms are covered for both Autonomous Database and on-premise deployments. Deep dive use cases detail their use to proactively detect performance degradation through the phases of detection, root-cause analysis and targeted corrective actions. Actual use cases protecting session, database instances, nodes and storage are presented. Next, diagnostic use cases for rapid recovery monitoring configurations, log and trace files where analysis is based upon anomalous events and record signatures. The final section will cover integration into DevOps processes.
Best Strategies To Audit Your Database System
Presented by Emad Al-Mousa, Saudi Aramco
Abstract:
Database Security is one of the most important topics nowadays as data breaches are on the rise, in this presentation I will discuss best strategies to audit your Oracle database systems. Moreover, Auditing will cover three layers: database layer, OS layer, and configuration layer.
Boosting Database Performance in Oracle 21c Database with Persistent Memory.
Presented by Kai Yu, Dell Technologies
Abstract:
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.
Building a Highly Available and Scalable Logistics Platform with Oracle 19c and Goldengate 19c
Presented by Nikitas Xenakis, Cooperative group
Abstract:
The Co-op is the UK’s leading convenience retailer, with 14 distribution centers and a turnover of $15.2 billion, servicing more than 10,000 outlets through its retail, wholesale, and franchise 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 by incorporating Oracle Autonomous Database.
Compression Usage Insights – Getting the Best Out of Oracle Compression
Presented by Gregg Christman, Oracle America, Inc
Abstract:
Understanding how Oracle Database data and index compression works, what has changed in the latest versions and discussing compression best practices can help you in getting the best results with Oracle Compression. Join Oracle Product Management to gain insights on compression topics that include: when compression occurs during bulk loads and DML inserts/updates, when to use Index Key (prefix) Compression versus Advanced Index Compression, how to track compression using AWR’s as well as recent Advanced Row Compression and Hybrid Columnar Compression enhancements with Oracle Database. This session is the perfect opportunity to get all your compression questions answered by Product Management.
Covid19 Patient Testing System – Real World Deployment of Autonomous Database, APEX and Data Safe
Presented by Nitin Vengurlekar, Oracle America, Inc
Abstract:
In 2020 An internal Oracle team along with several value-add Partners, assembled to develop a Patient Screening, Scheduling, and Testing System. This system was built in rapid development mode to deal with the much needed Covid19 testing. The Coalition executed Mockups, POCs, and deployment at unprecedented speed, and due to the short time frame and urgent need, critical decisions on platform stack components, data governance, and long term supportability were quickly made. This session will review how the Coalition addressed the design, governance, and security requirements necessary to implement this system. As part of this discussion, we describe the thought process for final stack design, how the CDC Covid19 guidelines impacted our solution, explain the overall configuration, cost savings and outline the deployment experience. Key areas of discussion will include Autonomous Database features, Data Catalog, Data Safe, and other Oracle Cloud Infrastructure Services.
Creating Order in the Database Patching Chaos
Presented by Liron Amitzi, GotoDBA
Abstract:
Have you ever found yourself staring at a list of patches and wondering what to do? What patch should I install? What are the risks? Is there anything I should do after the patch? This becomes even more stressful in a complex environment: How to install patches on RAC? What about standby databases?
This session will try to put things in order and help create a roadmap for patching databases. We will discuss the different types of patches (RU, RUR, DBBP, PSU, OJVM, One-off), installation types (RAC rolling patches, standby first patches), known issues and where to find them, and how to plan the patch installation in order to have as few surprises as possible.
This session will try to put things in order and help create a roadmap for patching databases. We will discuss the different types of patches (RU, RUR, DBBP, PSU, OJVM, One-off), installation types (RAC rolling patches, standby first patches), known issues and where to find them, and how to plan the patch installation in order to have as few surprises as possible.
Database 12c to 21c, Journey of key feature sets
Presented by Anuj Mohan, Big River Steel
Abstract:
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
DBA 3.0: The Next Evolution
Presented by Charles Kim, Viscosity North America
Abstract:
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 anyway 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.
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.
Exadata: Architecture and Internals Technical Deep Dive
Presented by Gavin Parish, Oracle America, Inc
Abstract:
Take a plunge into the technical details of Exadata. This session describes what has been done to enhance Exadata and its integrated database architecture, and how to take maximum advantage of some of the new capabilities. This session examines in detail Exadata’s hardware and software architecture, database extensions for Exadata, I/O resource management, Exadata’s Smart Scan and Smart Flash Cache features, as well as snapshot and virtualization capabilities.
Exadata: Strategy and Roadmap for New Technologies, Cloud, and On-Premises
Presented by Gavin Parish, Oracle America, Inc
Abstract:
The Exadata architecture is being transformed to provide the world’s most advanced cloud and in-memory functionality for both online transaction processing and analytics using remote direct memory access, dynamic random-access memory, nonvolatile memory, and vector processing. This session provides an overview of current and future Exadata capabilities, including disruptive in-memory, public cloud, and Oracle Cloud at Customer technologies.
Hands-On Lab: Keeping Data Safe: Hands-on with Oracle Data Safe
Presented by Bettina Schaeumer & Pedro Lopes, Oracle America, Inc
Abstract:
Abstract: Oracle Data Safe now helps secure databases on-premises and in the Oracle cloud. Data Safe helps you identify unnecessary security risks, detect configuration drift, find and monitor your riskiest users, assess the type and amount of sensitive data within your database, and remove risk from non-production databases. In this workshop, you’ll practice the main features in Oracle Data Safe, including Activity Auditing, Security Assessment, User Assessment, Data Discovery, and Data Masking.
High Availability and/or Standby Database – which solution should I choose?
Presented by Axel Vom Stein, BSS Bohnenberg GmbH
Abstract:
When using Oracle you will find more than enough solutions for High Availability and Data Security. If you have never been confronted with this topic before, you might ask yourself what solutions are there anyway and which one is right for my problem. Without delving too deeply into technical details such as setup and operation, a few of the most common solutions
(Standby Database with Standard Edition via Scripting, Dbvisit, Refreshable PDB, Oracle Data Guard, Oracle Failover Cluster, Oracle RAC One Node and Oracle RAC) will be touched upon briefly and compared with each other. The comparison of the different solutions provides a decision-making for your environment.
(Standby Database with Standard Edition via Scripting, Dbvisit, Refreshable PDB, Oracle Data Guard, Oracle Failover Cluster, Oracle RAC One Node and Oracle RAC) will be touched upon briefly and compared with each other. The comparison of the different solutions provides a decision-making for your environment.
Holistic Database Security in the Cloud
Presented by Robert Lockard, Self Employed
Abstract:
This talk is for database and information security professionals.
The database holds the crown jewels of the organization; however, the infosec security teams have little understanding of working of the database and database developers, designers, and DBAs have little understanding of security concepts. I get it, we get pressure from the top and the users to deliver a system with little time or budget to apply to database security. In this talk, we are going to take the 10,000 meter view of the database and look at the attack surface, attack vectors, and how to mitigate those attacks. At the end of the presentation, developers, designers, and DBAs will have action items they can take back to their shop and start improving security.
The database holds the crown jewels of the organization; however, the infosec security teams have little understanding of working of the database and database developers, designers, and DBAs have little understanding of security concepts. I get it, we get pressure from the top and the users to deliver a system with little time or budget to apply to database security. In this talk, we are going to take the 10,000 meter view of the database and look at the attack surface, attack vectors, and how to mitigate those attacks. At the end of the presentation, developers, designers, and DBAs will have action items they can take back to their shop and start improving security.
Implementing Business Rules Code with a PL/SQL Table API
Presented by Peter Koletzke, CompuServe
Abstract:
Business rules define the requirements of the organization such as what constitutes valid data. A PL/SQL Table API provides a centralized location for the code you write to represent those business rules. This technique has many benefits including better performance, reduced cloud database costs, simplification of user interface code, and more secure applications, and it can be used for any development environment: APEX, ADF, MAF, JET, MAX, VB Studio, Java, JavaScript, or any other framework.
Attend this session to hear about the benefits of this kind of centralized code in more detail as well as some advice about how to incorporate it into your development practices. The presentation focuses on the code components and strategies relevant to using a PL/SQL Table API and the methods used to call it. It also describes and demonstrates methods for automatically generating a large part of the code and shows examples of generated code as well as code that calls the Table API.
Attend this session to hear about the benefits of this kind of centralized code in more detail as well as some advice about how to incorporate it into your development practices. The presentation focuses on the code components and strategies relevant to using a PL/SQL Table API and the methods used to call it. It also describes and demonstrates methods for automatically generating a large part of the code and shows examples of generated code as well as code that calls the Table API.
Introducing the Oracle Converged Database
Presented by Sean Stacey, Oracle America, Inc
Abstract:
Are you a DBA or architect, or perhaps both, are your developers asking you to support their new application that is built on a single purpose data store? Are they convinced that this new small footprint single data store is the only way forward for the problem they’re trying to solve?
Well there’s good news. Only Oracle has a converged database that can meet their DevOps needs of CI/CD, event-driven and microservices while also supporting their data requirements whether it’s nosql key value pairs, or document store, or spatial and graph, or whatever other data persistence they’re seeking. Oracle’s converged database bridges the divide to embrace their needs with your mission critical enterprise requirements like security and high availability and performance.
Hear from Oracle Product Management about how the Oracle Converged Database can meet these requirements as well as why it should be the first platform to consider when looking to run with these development paradigms.
Well there’s good news. Only Oracle has a converged database that can meet their DevOps needs of CI/CD, event-driven and microservices while also supporting their data requirements whether it’s nosql key value pairs, or document store, or spatial and graph, or whatever other data persistence they’re seeking. Oracle’s converged database bridges the divide to embrace their needs with your mission critical enterprise requirements like security and high availability and performance.
Hear from Oracle Product Management about how the Oracle Converged Database can meet these requirements as well as why it should be the first platform to consider when looking to run with these development paradigms.
Most effective Database Tuning Tools, Techniques and Best Practice we have seen over the decade
Presented by Omar Faruq, Therap Services, LLC
Abstract:
Over the years, we have been following certain Oracle Database best practices which helped us to utilize database resources efficiently and run things smoothly minimizing unexpected downtimes. It is also important to use correct tools and techniques to quickly analyze and address any performance problems in the database. In this session, I’ll talk about different database performance best practices we follow for SaaS application databases as far as development and DBA teams are concerned. Along with that, would like to share Oracle Database tuning tools and techniques we found most effective to resolve database performance problems as situation demands.
Moving to the cloud with minimum downtime using Oracle ZDM.
Presented by Gleb Otochkin, Eclipsys Solutions
Abstract:
Moving to the cloud is not easy. It requires effort and skills and, in most cases, downtime. How can you minimize all three requirements and move your database with minimal downtime running just one command from the command-line? We will discuss the benefits and challenges of different migration methods and where the Oracle Zero Downtime Migration tool can save time and effort. The discussion will be based on real migration cases and on-hands experience of moving a large database environment to the new home.
Multitenant 12.1 to Multitenant 21c: Technical Deep Dive
Presented by Anuj Mohan, Big River Steel
Abstract:
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.
MySQL concepts for Oracle DBA
Presented by Matthias Crauwels, Pythian
Abstract:
MySQL is the largest open-source database in the world. It’s a product that resides under the wings of Oracle Corporation and still it survives with it’s big brother Oracle Database as the flagship product in Oracle Corp. This is an open-source product which means that, as opposed to Oracle Database, you can get it for free. We’ll discuss features and we’ll go into some details what we experience as the strong points and what are the weaknesses. I will guide you through the basic installation of the most recent release MySQL 8.0, we’ll go through the basic concepts of the database and we will set up a replica.
MySQL Indexes, Histograms, and Other Ways To Speed Up Queries
Presented by David Stokes, Oracle America, Inc
Abstract:
Nobody complains that the database is too fast. But speeding up queries is often seen as a ‘dark art’ and a mysterious process. You add an index but then things go slower. This workshop explains how indexes and histograms really work, how to use them efficient, and how to really speed up your MySQL queries.
New Features in Oracle Database 21c for Database Developers
Presented by Sean Stacey, Oracle America, Inc
Abstract:
Learn about what’s new in Oracle Database 21c for Database development. Oracle Database 21c is packed with innovative new features from Blockchain Tables and Native JSON support, but have you heard about any of the SQL and PLSQL innovations? Attend this session to learn more about what your missing.
No Downtime migration of large databases– 100T+
Presented by Valli Ramanathan, Attain Solutions Inc.
Abstract:
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.
Oracle Core: Base Technology for the Cloud and On-Premises
Presented by Martin Klier, Performing Databases GmbH
Abstract:
We will look under the hood of a famous monolith: How does the Oracle Database really work? The RDBMS has to keep many promises to ensure consistent transactional operations. Most of them are found in the acronym “ACID”.
We will hear explanations to terms like A in Archivelog or Alert Log or ASM, H as in High Availability, M like Multitenant, R like Redo Log, S as in spfile, T like Tablespace, and U like Undo.
We will hear explanations to terms like A in Archivelog or Alert Log or ASM, H as in High Availability, M like Multitenant, R like Redo Log, S as in spfile, T like Tablespace, and U like Undo.
Oracle Database & Multi-Factor Authentication – Good news: it’s easy!
Presented by Simon Pane, The Pythian Group
Abstract:
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.
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.
Oracle Database 19c SIG Meeting
Presented by Biju Thomas, Data Intensity & Anuj Mohan, Big River Steel
Abstract:
Join us for our Oracle Database 19c Special Interest Group (SIG) meeting.
Oracle Database 21c New Security Features
Presented by Stephen Kost, Integrigy Corporation
Abstract:
Oracle Database 21c has been released and is the latest innovation release of the Oracle Database. A number of new security features are included with this release and should be adopted when creating new databases or upgrading existing databases. Learn about the new security features and changes in security for this database release. Key new security features are blockchain table, gradual database password rollover, mandatory case sensitive passwords, and Unified Auditing enhancements.
Oracle DB security – Quick wins and what you should changing immediately!
Presented by Simon Pane, The Pythian Group
Abstract:
Security breaches are becoming more and more common. From both external and internal threats/bad actors. And while organizations spend considerable effort on perimeter security, the database is often overlooked or considered too fragile to touch.
But more effort needs to be directed towards Oracle database security. Both inside the database and out (i.e. operational practices). And regardless of whether on-premises or in the cloud.
This presentation covers common weaknesses and vulnerable areas of the Oracle database due to configuration and management issues which are easy to correct or remediate right away. Going well beyond the obvious like password rotations and having security policies.
But more effort needs to be directed towards Oracle database security. Both inside the database and out (i.e. operational practices). And regardless of whether on-premises or in the cloud.
This presentation covers common weaknesses and vulnerable areas of the Oracle database due to configuration and management issues which are easy to correct or remediate right away. Going well beyond the obvious like password rotations and having security policies.
Oracle Enterprise Manager Monitoring Best Practices
Presented by Ana McCollum & Karilyn Kao, Oracle America, Inc
Abstract:
Oracle Enterprise Manager is the management tool of choice for monitoring mission-critical infrastructure, databases, application servers and applications. Built on a scalable and highly available framework, Enterprise Manager offers a rich set of capabilities to meet the enterprise monitoring demands of today’s dynamic datacenters and support and automate many of its operational processes.
Join this session to learn our best practices for monitoring using Enterprise Manager — from basic monitoring to quickly set up monitoring with a few steps, to enterprise-level monitoring that enables you to implement your company’s monitoring requirements in an effective and scalable way.
Join this session to learn our best practices for monitoring using Enterprise Manager — from basic monitoring to quickly set up monitoring with a few steps, to enterprise-level monitoring that enables you to implement your company’s monitoring requirements in an effective and scalable way.
Oracle Enterprise Manager: 7 Robust Features to Put in Action
Presented by Rakesh Nagdev, Datavail
Abstract:
Oracle Enterprise Manager (OEM) brings your Oracle deployments together in a single management, monitoring, and automation dashboard. Oracle developed this solution, so it offers deep integration with many of its technologies. The ease of integration, coupled with the support of both on-premise and cloud-based Oracle databases, allows it to fit into many enterprise infrastructures. Oracle Enterprise Manager can also monitor and manage non-Oracle databases, making it a cost effective and central tool to manage IT environments with a mix of database platforms.This presentation takes on a brief history of OEM and then does a deep dive into seven robust features organizations should consider implementing:
1. Intelligent Incident Compression (Smart Alerting)
2. Chef Job Support
3. Always-ON Monitoring
4. Notification Blackouts
5. System Broadcast
6. Export & Import Incident Rule Sets
7. Metric Enhancements
1. Intelligent Incident Compression (Smart Alerting)
2. Chef Job Support
3. Always-ON Monitoring
4. Notification Blackouts
5. System Broadcast
6. Export & Import Incident Rule Sets
7. Metric Enhancements
Oracle on Azure: An Overview
Presented by Osama Mustafa, Gurus Solutions
Abstract:
In this interactive session see why Azure is a great cloud to run Oracle Databases and applications. You can confidently use Oracle Database supported by Oracle and certified by Oracle to run on Azure. Rely on field-tested reference architectures that can accelerate your deployment times while reducing risks. Build and deploy cloud native enterprise-class Java applications on Oracle WebLogic Server in Azure and on Oracle Linux. The session also explores in detail some of the lessons learned regarding Microsoft Azure and Oracle’s cloud interoperability based on early customer deployments and use cases.
Oracle on Windows – things to know plus a few tricks…
Presented by Mark Sorger, ASRC Federal Data Solutions
Abstract:
Learn the how and why of running Oracle on Windows, and some tricks to help you along the way. This session will benefit the Beginner to Mid-Level Oracle DBA faced with running Oracle on a Windows Server, and may also teach some old hands a trick or two. Instead of delving into topics that would be for Server Administrators, this talk will deal with issues directly related to DBAs running Oracle on a Windows Server. Find out how to leverage many of the features that Windows has to help you as a DBA, including taking advantage of some of the command line and scripting options available.
Oracle SQL Plan Management (SPM) your imperative performance tool
Presented by Gary Gordhamer, Viscosity North America
Abstract:
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 goto 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.
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.
PL/SQL 101: 5+ Basic Tips for Highly-Performant Code
Presented by Peter Koletzke, CompuServe
Abstract:
Efficient applications require the best performance from all components used to implement the application. If you are using cloud services, tuning of some components is out of your control, but regardless of your use of cloud, your job as an application developer is to ensure that your database code runs as efficiently as possible. It is so much easier to create highly-performant code in the first place than it is to have to fix the code later when you find that it is not performing well.
At this session you will hear an introduction to (or a review of) a set of PL/SQL coding techniques that help performance. Although these techniques have been known for years, if you are relatively new to the language you may not have been exposed to them. Examples of these techniques include: caching local variables, iteration handling, reducing context switching, datatype selection, and various methods for handling data manipulation. Sample code will illustrate the principles.
At this session you will hear an introduction to (or a review of) a set of PL/SQL coding techniques that help performance. Although these techniques have been known for years, if you are relatively new to the language you may not have been exposed to them. Examples of these techniques include: caching local variables, iteration handling, reducing context switching, datatype selection, and various methods for handling data manipulation. Sample code will illustrate the principles.
Practical Use of Active Session History
Presented by David Kurtz, Go-Faster Consultancy
Abstract:
This presentation aims to help you use the Active Session History (ASH) repository to investigate performance problems. Oracle have produced many presentations that explain how ASH works, so this presentation provides only a very brief overview of how ASH works. Instead, it looks at:
what information is collected by ASH and stored in the repository
where this data can be seen in Enterprise Manager and other delivered reports
the practicalities of how to directly query the ASH data to analyse and diagnose a range of performance and other problems.
the value of a consolidated AWR/ASH repository
the critical importance of application instrumentation
This session is proposed as a two-hour deep dive, although it can be done as two sessions that can also stand-alone.
what information is collected by ASH and stored in the repository
where this data can be seen in Enterprise Manager and other delivered reports
the practicalities of how to directly query the ASH data to analyse and diagnose a range of performance and other problems.
the value of a consolidated AWR/ASH repository
the critical importance of application instrumentation
This session is proposed as a two-hour deep dive, although it can be done as two sessions that can also stand-alone.
Scale Out made Easy -MySQL 8
Presented by Nisha Riyaj, UCI
Abstract:
As business application grows rapidly, scale out should be easy and contains few steps to implement.
In MySQL8 Source-Target setup , adding a 3rd or 4th ..nth server as part of replication is simple and easy. We will discuss about the steps/option available to scale out with no downtime to the primary/source server.
In MySQL8 Source-Target setup , adding a 3rd or 4th ..nth server as part of replication is simple and easy. We will discuss about the steps/option available to scale out with no downtime to the primary/source server.
Secure your Oracle Databases with Oracle Data Safe
Presented by Bettina Schaeumer, Oracle America, Inc
Abstract:
Oracle Data Safe is an exciting new service offering security capabilities for identifying and reducing risk in Oracle Databases. First introduced at Oracle Open World San Francisco in 2019, Data Safe has been continuously enhanced and is now available for all Oracle Databases, on-premises and in the cloud. Join us to learn how you can simplify managing the security of your databases. We will go through a real life use case to assess configuration risks, evaluate database users, manage audit settings, report on database activity, discover sensitive data, and remove sensitive data from non-production copies of the database. And the best part – no special expertise is needed to leverage the capabilities of Data Safe.
Sharing Experience from 24 Months of Database Upgrade and Migration
Presented by Martin Klier, Performing Databases GmbH
Abstract:
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!
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!
System Changes and Go-Live: Avoid Sleepless Nights Using Oracle Real Application Testing
Presented by Bjorn Bolltoft, Oracle America, Inc
Abstract:
Implementing system and infrastructure changes in a production environment can result in unwanted performance regressions and production instabilities. Therefore, these changes should be validated appropriately before deploying them in production. A new more powerful machine, faster CPUs or storage, or migrating to Exadata or Oracle Autonomous Database should not impact performance or business SLAs. In this session see a real-world customer case study that leverages Oracle Real Application Testing for infrastructure upgrade. Walk through the case study from the project plan down to final deployment, get tips and techniques, and hear about the pitfalls and lesson learned for successfully implementing system changes.
The Oracle Auto Upgrade
Presented by Michael Messina, Rolta AdvizeX
Abstract:
With 19c we get the tiny little command line tool that will allow us to update our databases “hands free”. We can do all the prechecks, fix 99% of pre update issues and then do the update and finally the post update all without our manual little fingers on the keyboard, well almost no little fingers on the keyboard. Wait there is more, it is not all for just Database 19c we can use this on prior versions like 18.5 and new as well as 12c Release 2 (12.2 + DBJAN2019RU and newer)
The Oracle Database Security Assessment Tool
Presented by Michael Messina, Rolta AdvizeX
Abstract:
Learn how to setup and configure and utilize the Oracle Database Security Assessment tool. The tool can help with data and database security best practices and options. The tool can also help you uncover the sensitive in you databases so that you and implement ways to better protect you data.
protect you data.
protect you data.
The Real Value of Oracle Health Checks
Presented by Zane Warton, Datavail
Abstract:
Checks
These days supporting business means always handling varied and shifting priorities. But, if you expect your Oracle databases to handle these changes and perform consistently at high levels, you need to have a maintenance process. The first part of that is an assessment: How are my databases performing, and are there any problems? It sounds simple, but for most modern complex database environments, a proper assessment requires a variety of tools and a lot of experience interpreting the results.
These days supporting business means always handling varied and shifting priorities. But, if you expect your Oracle databases to handle these changes and perform consistently at high levels, you need to have a maintenance process. The first part of that is an assessment: How are my databases performing, and are there any problems? It sounds simple, but for most modern complex database environments, a proper assessment requires a variety of tools and a lot of experience interpreting the results.
The Show Must Go On – Standard Edition High Availability (SEHA)
Presented by Liron Amitzi, GotoDBA
Abstract:
In Oracle Database 19c, Oracle Database Standard Edition no longer supports Real Application Clusters (RAC). However, Oracle introduced a new feature: SEHA (Standard Edition High Availability). This is not RAC by any means, but it provides a high availability solution that is easy to implement and manage.. This session will explain what SEHA is, the differences between RAC and SEHA, and will dive into how SEHA behaves in different scenarios.
The Tuning Process Using AWR and Custom Tools
Presented by Roger Cornejo, Accenture Enkitec Group
Abstract:
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 tool set – 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 cause and provide solutions.
Get a jump start by experiencing the presenters 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.
Get a jump start by experiencing the presenters 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.
Tools for Next-Generation Database Management
Presented by Sriram Vrinda, Oracle America, Inc
Abstract:
Databases running on the cloud are not exactly the same as on-premise databases. They have different deployment models and network architectures, the protocols for accessing them are strictly controlled, their configuration is locked down, and some administration commands are blocked. This raises a question on how to effectively monitor an Oracle Database cloud ecosystem. Join this session to learn practical examples of how to diagnose and resolve application problems using various tools that help DBAs with day-to-day tasks and master cloud database management.
Turbocharge Your Database Auditing with Unified Auditing
Presented by Stephen Kost, Integrigy Corporation
Abstract:
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.
Unleash the Top 19 New Features of Oracle Database 19c
Presented by Charles Kim, Viscosity North America
Abstract:
Oracle Database 12 Release 2 is packed with enhancements for DBAs and Developers. Come listen to all the pertinent new features in Oracle 12.2/18c/19c that will change how you perform maintenance and tune the database. This session is not the traditional Oracle 12.2/18c/19c database features. Be prepared to have mind overloaded with the following focused areas:
1. Oracle 20c New Features
2. Oracle 19c New Features
1. Why do you need to go directly to Oracle Database 19c and skip Oracle Database 12.2/18c
3. Oracle 18c New Features
4. Upgrade to Oracle 12.2/18c/19c/20c
a. Upgrade considerations
b. Zero downtime upgrade options
5. Multi-Tenancy (PDB) Option
1. Elimination of support for non-container databases in Oracle 20c
2. Changes in Oracle licensing policy with Oracle19c
6. Online Improvements
7. Partitioning Option
8. Data Guard
9. RMAN
10. General Database
11. RAC
12. ASM/ACFS
13. In-Memory
1. Oracle 20c New Features
2. Oracle 19c New Features
1. Why do you need to go directly to Oracle Database 19c and skip Oracle Database 12.2/18c
3. Oracle 18c New Features
4. Upgrade to Oracle 12.2/18c/19c/20c
a. Upgrade considerations
b. Zero downtime upgrade options
5. Multi-Tenancy (PDB) Option
1. Elimination of support for non-container databases in Oracle 20c
2. Changes in Oracle licensing policy with Oracle19c
6. Online Improvements
7. Partitioning Option
8. Data Guard
9. RMAN
10. General Database
11. RAC
12. ASM/ACFS
13. In-Memory
Upgrade from Oracle 12.2 to 19c with a Container/Pluggable Configuration
Presented by Chris Bradham, Applied Engineering Management Corporation
Abstract:
Oracle database upgrades can seem like a daunting task if you are like most DBAs who only upgrade every few years. What if you have a stand-alone (non-Oracle RAC) database and want to switch from a non-container database to a container/pluggable configuration? I know this sounds like a lot more work, adding to an already stressful situation. However, please know it only requires a few extra steps and results in greatly improved resource utilization.This presentation provides step-by-step instructions for upgrading from Oracle 12.2 to 19c and converting from a non-container to a container/pluggable configuration. I’ll even throw in the steps for upgrading an OEM repository to this configuration at no extra charge.
Who Moved My Cheese?: Where Do I Find The Best Oracle Development Tool?
Presented by Peter Koletzke, CompuServe
Abstract:
Not that long ago it was so simple: if you were a developer who wanted to work with an Oracle development tool, you used Oracle Forms. Period. End of story.
Now the number of Oracle development tools has grown to the point where it is natural to wonder which one to use. Each of Oracle’s offerings is a solid choice so the only real answer to the question of “which one is best?” is a not so helpful, “It depends.”
This session provides some guidelines for determining which Oracle development tool is best for your situation among the large crowd of: Application Development Framework (ADF), ADF Essentials, Application Express (APEX), Mobile Application Framework (MAF), PL/SQL Web Toolkit, Visual Builder Studio (VBS), Mobile Application Accelerator (MAX), JavaScript Extension Toolkit (JET), and, of course, Oracle Forms. In addition, the session will explain the role played by Alta UI, Oracle UX, and Redwood in developing modern user interface applications with any tool.
Now the number of Oracle development tools has grown to the point where it is natural to wonder which one to use. Each of Oracle’s offerings is a solid choice so the only real answer to the question of “which one is best?” is a not so helpful, “It depends.”
This session provides some guidelines for determining which Oracle development tool is best for your situation among the large crowd of: Application Development Framework (ADF), ADF Essentials, Application Express (APEX), Mobile Application Framework (MAF), PL/SQL Web Toolkit, Visual Builder Studio (VBS), Mobile Application Accelerator (MAX), JavaScript Extension Toolkit (JET), and, of course, Oracle Forms. In addition, the session will explain the role played by Alta UI, Oracle UX, and Redwood in developing modern user interface applications with any tool.
Working Effectively with JSON in the Oracle Database
Presented by Sean Stacey, Oracle America, Inc
Abstract:
JSON data is becoming increasingly prevalent in many enterprises today. As a result the world of data management now includes the need for storing JSON documents in a fast, reliable and secure way. What better place to store and manage this data then in the Oracle Database? …and best of all it’s totally free!
This session covers the different approaches to loading, storing, retrieving and managing JSON in the Oracle Database including the new native JSON datatype introduced in Database 21c.
The session will include live demonstrations.
This session covers the different approaches to loading, storing, retrieving and managing JSON in the Oracle Database including the new native JSON datatype introduced in Database 21c.
The session will include live demonstrations.
Adventures in Migrating a Legacy Database to Oracle Cloud
Presented by Sean Scott, Viscosity North America
Abstract:
It seemed so simple—migrate a relatively small legacy database from DB2 to Oracle Autonomous Data Warehouse. Nobody knew the dark secrets this database was hiding before the SOW was signed and the project was underway, but by then it was too late! Follow along as a well-planned project grows from unassuming and ordinary into a monster, devouring everything in its path and tossing aside timelines! A twisting tale, full of wrong turns and peril, heroes and villans, challenge, failure, ultimately ending with… Wait, you didn’t think I’d give away the ending, did you?
This session is not a reference or a how-to. It’s more of a what-not-to-do, reflecting and laughing (in hindsight) at a series of unfortunate circumstances and mistakes. It’s a set of lessons in resilience and determination. It’s about overcoming technical obstacles and human objections, and leveraging the tools and features in OCI so they all lived… Well, let’s not spoil things!
This session is not a reference or a how-to. It’s more of a what-not-to-do, reflecting and laughing (in hindsight) at a series of unfortunate circumstances and mistakes. It’s a set of lessons in resilience and determination. It’s about overcoming technical obstacles and human objections, and leveraging the tools and features in OCI so they all lived… Well, let’s not spoil things!
Constraint Optimization: The Difference A Comma Can Make
Presented by Oren Nakdimon, DB Oriented
Abstract:
A task can be done in a very short way and in a very long way.
Which one will you choose?
Knowledge is Power!
This session gives lots of interesting knowledge about an allegedly boring topic – Constraints.
And this knowledge will give you the power to optimize and make better decisions.
The behavior of adding columns and constraints to big tables in Oracle may vary significantly, in two aspects – duration and availability – based on the way we perform these operations. In addition, different constraints may have different impact, based on their syntax, types, states, locking, etc.
Attend this session to understand what happens exactly under the hood when we issue a simple ALTER TABLE statement, and how to utilize this knowledge for achieving better performance or higher availability.
Which one will you choose?
Knowledge is Power!
This session gives lots of interesting knowledge about an allegedly boring topic – Constraints.
And this knowledge will give you the power to optimize and make better decisions.
The behavior of adding columns and constraints to big tables in Oracle may vary significantly, in two aspects – duration and availability – based on the way we perform these operations. In addition, different constraints may have different impact, based on their syntax, types, states, locking, etc.
Attend this session to understand what happens exactly under the hood when we issue a simple ALTER TABLE statement, and how to utilize this knowledge for achieving better performance or higher availability.
How to do Unit Tests and not go crazy (and bankrupt).
Presented by Monika Lewandowska, Autonomous
Abstract:
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.
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.
A developers guide to Oracle RAC
Presented by Anil Nair, Oracle America, Inc
Abstract:
This session will introduce Oracle RAC in the context of Developers attempting to use Oracle Database. The session will cover tips and tricks to ensure that developers can benefit from features like session failover, load balancing with minimal effort
Accelerating Oracle workloads on VMware Hybrid Clouds with Vmware vSphere Performance Accelerators
Presented by Sudhir Balasubramanian, VMware
Abstract:
Enabling and sustaining the highest possible performance along with continued application availability is a major goal for all mission critical applications in order to meet the demanding business SLA’s. Harnessing key features in the latest vSphere release 7.0 U1 including Persistent memory, Para Virtualized RDMA , 1GB Huge Pages, vNVME Controll ers, Improved Distributed Resource Scheduler (DRS), Assignable Hardware, Refactored vMotion etc helps achieve those stringent business goals. This session discusses accelerating Oracle Enterprise IO intensive workloads with vSphere 7.0 new features enhancing high availability, faster data loading etc and share key considerations and lessons learned.
Advanced Docker Recipes: Building Complex Oracle Environments
Presented by Sean Scott, Viscosity North America
Abstract:
Oracle provides a number of “vanilla” recipes in the Docker repository but these don’t cover the needs of modern enterprises. This presentation discusses methods for creating images to support Data Guard, OEM, APEX, Sharding, rapid container deployments, Gold images, and transportable datasets. Participants will learn how to develop and customize Dockerfiles and orchestrations and apply them to their needs.
Billing dashboard in the cloud using Apex and OCI free tier.
Presented by Gleb Otochkin, Eclipsys Solutions
Abstract:
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 cloud API and usage reports and creating my Apex billing application.
Building Generic Search Screen via Dynamic SQL
Presented by Michael Rosenblum, Dulcian Inc
Abstract:
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.
Building Reliable Oracle GoldenGate Environments using Docker
Presented by Bobby Curtis, RheoData
Abstract:
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.
Deep dive into SQL tuning
Presented by Gary Gordhamer, Viscosity North America
Abstract:
Have you had that one SQL statement that you just couldn’t figure out what the Oracle optimizer was thinking? In this session we will take a deep dive into doing a trace and talk about some of the sledgehammer methods to influence the optimizer. You may not find the solution to that one nagging SQL but we will cover how the optimizer frustrated you so. Using these tools along with Oracle’s SQL Plan Management or Profiles you may be able to achieve your goals.
Many developers do not understand how to dig into SQL beyond the basic explain plan. Here we will cover the somewhat gory details of going deep inside how the optimizer is making decisions.
Many developers do not understand how to dig into SQL beyond the basic explain plan. Here we will cover the somewhat gory details of going deep inside how the optimizer is making decisions.
From DBA to a DevOps Engineer – a DBaaS ramp up experience
Presented by Martin Berger, Trivadis
Abstract:
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.
Future of IT Monitoring – Observability and Management
Presented by Sai Penumuru, DXC Technology
Abstract:
For IT management, one of the most valuable changes in the transition from reactive to proactive and ultimately to predictive intervention – fix the faults before they occur – or at least before anyone knows. The simple truth is that IT monitoring will increasingly become a critical element in an organization’s overall digital business service delivery strategy. Attend this session if you want to not only survive but to thrive with the rapid pace of change occurring on the path toward an increasingly digital future. The presentation will cover Oracle Cloud’s new Observability & Management Platform. The Oracle Observability & Management provides comprehensive visibility and actionable insights across all stack layers, deployed on any technology, anywhere.
Getting Started with Oracle on Docker
Presented by Sean Scott, Viscosity North America
Abstract:
Docker is widely embraced in the developer community but less well known or understood in the database world. Database administrators and developers are beginning to realize how powerful containers are and the speed, flexibility, and portability advantages they offer over virtual guests.
This session is a practical course for those curious about or just starting out with Oracle on Docker. Attendees will learn terminology and understand how containers differ from virtual machines, followed by demonstrations of Docker’s speed and versatility. Explore basic commands and examples for building Oracle on Docker and making container databases visible on a network. Discover how to separate and preserve data, share and distribute database images and data, then how to create new databases in seconds (not an exaggeration). The session closes with advice on customizing container environments and a peek into orchestrated builds for multi-database needs posed by Data Guard and Sharding.
This session is a practical course for those curious about or just starting out with Oracle on Docker. Attendees will learn terminology and understand how containers differ from virtual machines, followed by demonstrations of Docker’s speed and versatility. Explore basic commands and examples for building Oracle on Docker and making container databases visible on a network. Discover how to separate and preserve data, share and distribute database images and data, then how to create new databases in seconds (not an exaggeration). The session closes with advice on customizing container environments and a peek into orchestrated builds for multi-database needs posed by Data Guard and Sharding.
Hands-On Lab: Building a Proof-of-Concept using the APEX Service
Presented by Monica Godoy, Oracle America, Inc
Abstract:
This workshop starts with a napkin design of data structures we would like to use for a proof-of-concept. Using Quick SQL you will quickly define the data structures and utilize various table and column directives to better define the tables and also create some dummy data. You will then be creating an application based on the new tables. Lastly, you will be updating some of the generated components to improve the initial app.
In this lab, you will learn how to:
-Create an APEX Service
-Define new tables and views
-Create an application on the new data structures
-Refine the application
In this lab, you will learn how to:
-Create an APEX Service
-Define new tables and views
-Create an application on the new data structures
-Refine the application
Insider’s Guide to Maximizing SQL Performance
Presented by Ashish Agrawal, Oracle America, Inc
Abstract:
Automatic Workload Repository (AWR), Active Session History (ASH) and SQL monitoring hold a wealth of SQL performance data. OOCI Operations Insights SQL Warehouse leverages the rich SQL data in AWR, ASH, data using purpose-built machine learning to provide unique insights into SQL performance problems for your enterprise databases running on premise or on cloud. In this session learn to recognize patterns of SQL performance issues across all your Oracle Databases; perform a historical, comparative analysis to find any SQL bottlenecks or plan regression; and identify SQL performance anomalies.
Keep Your Code Low, Low, Low, Low, Low: Getting to Digitally Driven With Oracle Converged Database
Presented by Jim Czuprynski, Zero Defect Computing, Inc.
Abstract:
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. This session explores the myriad facets of a Converged Database strategy and what it means for your career’s future path, regardless of whether you’re an application developer or DBA.
Through presentations and online demonstrations, this session illustrates how to:
– Leverage the strategy behind Converged Database to help your IT shop become truly digitally driven
– Access data in any format virtually anywhere with utmost security using Oracle’s EXTERNAL table methodology
– Take advantage of Oracle APEX application features like Web Source Modules and Plug-Ins to build robust applications without deep knowledge of JavaScript
Through presentations and online demonstrations, this session illustrates how to:
– Leverage the strategy behind Converged Database to help your IT shop become truly digitally driven
– Access data in any format virtually anywhere with utmost security using Oracle’s EXTERNAL table methodology
– Take advantage of Oracle APEX application features like Web Source Modules and Plug-Ins to build robust applications without deep knowledge of JavaScript
Managing the Earthquake: Surviving Major Database Architecture Changes
Presented by Michael Rosenblum, Dulcian Inc
Abstract:
Every long-term IT project reaches a point when one or more fundamental concepts that define the whole system are no longer true. If the business is lucky, this may lead to a brand new development project. If not, the current system must be altered to support requirements for which it was never designed. This presentation discusses how to mitigate possible design-time risks using available technologies and concepts from a database perspective, such as repository-based solutions, code generators, abstract models, micro-SOA, etc. The presentation will also cover real-life examples of best practices for handling unexpected architectural shifts based on systems with 10+ years of life span.
Migrate, Consolidate and Analyze Databases with Confidence using Enterprise Manager
Presented by Abilash Rengasamy, Oracle America, Inc
Abstract:
Oracle is revolutionizing how data is managed with the introduction of the world’s first self-driving database. Oracle Enterprise Manager offers a unified, cost-effective, and easy way to automate the migration of your on-premises database workloads to the next generation of the industry-leading database, Oracle Autonomous Database and Database Cloud Services running on Exadata Cloud@Customer and OCI, eliminating human labor and error. For Database Cloud Services, Enterprise Manager helps DBA’s move to Multitenant, consolidate Databases or Infrastructure on OCI Cloud and also assess the success of the migration. Reap benefits from seamlessly transferred configurations, periodic synchronization of data with production, and “time travel” capabilities such as rewind/refresh. Join this session to learn more.
Multitenant PDB and Schema Provisioning aaS with Ansible
Presented by Timo Giese, Fiducia & GAD IT AG
Abstract:
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.
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.
Oracle DB 21c, PMem and Caching
Presented by Douglas Hood, Oracle America, Inc
Abstract:
Learn how Intel Optane Persistent Memory works with Oracle Database 21c. See how to configure your Oracle database for faster writes with a PMem filestore.
Understand the difference between PMem App Direct Mode and Memory Mode. Compare Oracle 21c with DRAM + SSD vs PMem vs TimesTen Cache for OCI and JDBC workloads.
Understand the difference between PMem App Direct Mode and Memory Mode. Compare Oracle 21c with DRAM + SSD vs PMem vs TimesTen Cache for OCI and JDBC workloads.
Oracle Maximum Availability Architecture (MAA) SIG
Presented by Alfredo Abate, BBB Industries, Anil Nair, Oracle America Inc, & Markus Michalewicz, Oracle America Inc
Abstract:
Join us for the Oracle Maximum Availability Architecture (MAA) Special Interest Group (SIG).
Preparing for Oracle 21c
Presented by Rich Niemiec, Viscosity North America
Abstract:
This presentation will focus on preparing for the Oracle 21c database and new features such as AutoML, In-Memory Advancements, Data Guard standby DML, Result Cache on the Standby, Big Data SQL, and other features. This presentation will also look at a few 19c/18c new features that should be in use now before you get to 20c. We’ll look at how Machine Learning and Autonomous Database will change the role of the future DBA. Emerging information technology trends for the cloud have the power to transform organizations. In the data management and analytics space, a key cloud service offering has arrived. Oracle Autonomous Data Warehouse (ADW) Cloud & Oracle Autonomous Transaction Processing (ATP) simplifies the provisioning, maintenance, and optimization for data warehouse workloads in the cloud, and promotes low touch for database administrators and load and pull approaches to data analytics.
Voyage to Visual Builder Studio: Impressions from an APEX Gal
Presented by Karen Cannell, TH Technology
Abstract:
Hear lessons learned on an APEX gal’s voyage to Visual Builder Studio, Oracle’s updated cloud-based visual application development environment, the new path to using Visual Builder. VB Studio allows one to build web and mobile applications, extend Oracle cloud applications, and manage the full development life cycle in an integrated, collaborative environment. Sounds great – but how does it really work?
What is the difference between VB Studio and VB? When do I use one vs. the other? How hard is it to get started? How hard is it build a real production application? How hard is it to extend my cloud applications? Do I have to be a JavaScript expert? What investment – time, money, learning – is required to be productive? Was this voyage worth the effort? Can VB Studio make a difference for one’s Oracle cloud investment? Attend and learn about a long-time Oracle APEX developer’s continued adventure into VB and VB Studio.
What is the difference between VB Studio and VB? When do I use one vs. the other? How hard is it to get started? How hard is it build a real production application? How hard is it to extend my cloud applications? Do I have to be a JavaScript expert? What investment – time, money, learning – is required to be productive? Was this voyage worth the effort? Can VB Studio make a difference for one’s Oracle cloud investment? Attend and learn about a long-time Oracle APEX developer’s continued adventure into VB and VB Studio.
Data Science & Analytics
Learn how organizations are using Data Science & Analytics to transform their operations and sustain their competitive advantage, addressing the challenges of managing rapid growth for data storage and availability, and how analytics are enabling organizations to function more efficiently. You’ll hear how other users are proactively using customer data to create opportunities, what how to make better, Big Data-driven decisions.
Keynote and Roadmaps:
INSYNC Kickoff: Oracle Data Management Strategy
Presented by Jenny Tsai-Smith, Oracle America, Inc
Abstract:
Oracle has a history of delivering data management solutions of choice for managing customers’ operational and analytical workloads on-premises and in the cloud. Jenny Tsai-Smith, Vice President of Database Product Management, shares Oracle’s strategy for continuing to deliver truly unique and innovative products and services to meet and exceed customers’ requirements.
Data Science & Analytics sessions at INSYNC:
“6 Clicks to Better ML” using Oracle Machine Learning’s New AutoML UI
Presented by Charles Berger, Oracle America, Inc
Abstract:
Oracle Machine Learning’s new AutoML UI makes ML easier than ever before. OML’s AutoML automates many of the time-intensive and repetitive aspects of a data scientist’s job including algorithm selection, feature selection, and hyperparameter tuning. AutoML UI enables “citizen data scientists” to leverage AutoML in ADW with a simple, intuitive, easy to use UI. Using AutoML UI, data scientists and citizen data scientists can focus on the important phases of ML: Defining the problem, assembling the “right data”, disseminating the model’s insights and predictions and deploying the model enterprise-wide. Come see the new AutoML UI and learn how easy it is to get started.
Cluster, Classify, Associate, Regress: Satisfy Your Inner Data Scientist with OML and Analytics
Presented by Jim Czuprynski, Zero Defect Computing, Inc.
Abstract:
The modern data scientist has a daunting task: Probing petabytes of data, figuring out which Machine Learning (ML) algorithms to apply to filter the grain from the chaff, and producing meaningful intelligence on which to base digitally-driven strategies for their organization. This session demonstrates how even a fledgling citizen data scientist facing few real-life opportunities to discover unseen patterns and relationships within sample data can quickly leverage the powerful ML capabilities already built into the Oracle Database and available for use at no additional cost.
Topics:
1. The Basics of ML Problem-Solving: Clustering, Classification, Association, Regression
2. Probing Data Sources, Wherever They Live And What They Comprise
3. Picking the Right Algorithm
4. Missed It By That Much: Determining ML Model Accuracy
5. AutoML in OML4Py
6. Putting It All Together: Demonstrations
Topics:
1. The Basics of ML Problem-Solving: Clustering, Classification, Association, Regression
2. Probing Data Sources, Wherever They Live And What They Comprise
3. Picking the Right Algorithm
4. Missed It By That Much: Determining ML Model Accuracy
5. AutoML in OML4Py
6. Putting It All Together: Demonstrations
Oracle Analytics Cloud: You can leverage it today!
Presented by Basheer Khan, Knex Technology
Abstract:
Transactions gather data, which when processed becomes information. Knowledge is accumulation of information, that empowers you. Imagine having a single platform that empowers your entire organization to ask any question of any data in any environment on any device. Regardless of which applications you use, imagine being able to use this in your organization today! Join Oracle ACE Director, Basheer Khan, as he introduces you to the capabilities of Oracle Analytics Cloud and provides an effective approach to start using it today. This session includes a live demonstration of Oracle Analytics and Oracle Quick SQL, a rapid design tool.
Accelerate Oracle Database analytics 80X and use less CPU and IO with the In-Memory feature
Presented by Wayne Martin, IBM
Abstract:
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.
Analytics Using Feature Selection for Anomaly Detection
Presented by Roger Cornejo, Accenture Enkitec Group
Abstract:
Experience an innovative approach which relies on big data and advanced analytical techniques to detect anomalies in performance metrics in order to improve Oracle DB performance. The approach represents a step-change paradigm shift away from traditional methods which tend to rely on a few hand-picked/favorite metrics or wading through a voluminous AWR report. With this innovative process, you can draw on all available performance data to help you draw impactful, focused performance improvement conclusions.
The process targets the most relevant metrics for the problem interval which results in event focused and actionable intelligence on the performance issue, and insight into possible solutions. This method improves on the typical/traditional approaches which monitor a standard set of hard coded metrics; which may cause you to miss important system behavior or configuration that is relevant to the root cause of the performance problem. The speaker will share his process and code.
The process targets the most relevant metrics for the problem interval which results in event focused and actionable intelligence on the performance issue, and insight into possible solutions. This method improves on the typical/traditional approaches which monitor a standard set of hard coded metrics; which may cause you to miss important system behavior or configuration that is relevant to the root cause of the performance problem. The speaker will share his process and code.
CDC Data Integration – Goldengate for Bigdata (Oracle Database to Hadoop, Kafka and MongoDB targets)
Presented by Vivek Pinyani, USCellular
Abstract:
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.
Cloud Computing SIG Meeting
Presented by Erik Benner, Mythics, Inc.
Abstract:
Join us for our Cloud Computing Special Interest Group meeting.
Converged Database Panel
Presented by Rich Niemiec, Viscosity North America
Abstract:
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.
Hands-on Lab: Five (5) Oracle Machine Learning Notebooks You Should Know
Presented by Charles Berger, Oracle America, Inc
Abstract:
Oracle Machine Learning comes free in every Autonomous Database. Oracle Machine Learning Notebooks provide easy to understand, reuse and repurpose ML methodologies that apply OML’s 30+ machine learning algorithms for in-database, parallelized implementations of classification, regression, clustering, anomaly detection, text mining, associations machine learning functions that can be used to tackle a wide variety of data-driven problems and to build “predictive” applications. This session will step through five (5) OML notebooks that can serve as the core of many data science projects: classification, attribute importance, time-series forecasting, text mining and anomaly detection.
In-database Machine Learning with Oracle Database and Oracle Autonomous Data Warehouse (ADW)
Presented by Kai Yu, Dell Technologies
Abstract:
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 Data Warehouse (ADW) 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 ADW . 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.
Introduction to Oracle Database 21c
Presented by William Hardie, Oracle America, Inc
Abstract:
The latest release of the world’s most popular database, Oracle Database 21c, was recently released on Oracle Cloud Infrastructure (including Autonomous Database Free-Tier Service). In this session, we’ll take a look at some of the new features and enhancements that further enable Oracle’s converged capabilities for data driven applications.
Machine Learning 101
Presented by Rich Niemiec, Viscosity North America
Abstract:
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.
New Features in Oracle Database In-Memory
Presented by Andy Rivenes, Oracle America, Inc
Abstract:
Oracle Database In-Memory is targeted specifically at speeding up analytic queries by orders of magnitude over traditional row-based queries. However, it is hard to appreciate all of the features that Database In-Memory uses to make this happen, so join Oracle Product Management in a deep dive that will take you through all of the latest features of Database In-Memory. This session will provide a quick review of Database In-Memory since its introduction in Oracle Database 12.1.0.2, but will primarily focus on the new features introduced in Oracle Database 19c and 21c. With the introduction of the new Base Level Feature, after seeing this session you can go back and try this out for yourself on your own 19.8 and higher databases without having to license Database In-Memory first.
Oracle Machine Learning: Overview, What’s New?, AutoML, Customer Use Cases, Appls & Road Map
Presented by Charles Berger, Oracle America, Inc
Abstract:
Oracle Machine Learning is now a free feature in Oracle Databases (on-premises, Cloud and Autonomous). As part of Oracle’s Converged Database strategy, OML “moves the algorithms; not data” processing data where it resides. Oracle Machine Learning extends Oracle Database(s) delivering 30+ ML algorithms and AutoML functionality via SQL (OML4SQL) and integration with open source languages: Python, OML4Py and R, OML4R. This OML presentation and demonstration(s) highlights existing and new OML features: AutoML, AutoML UI, new algorithms in 21c, OML4Py and OML Services. Now Oracle DBAs, users and application developers can leverage OML’s ML algorithms to discover new insights, make predictions and deploy ML models enterprise-wide via APEX, Oracle Analytics Cloud and embedded in Applications. Come learn how to get started taking immediate advantage of these free and powerful in-database ML capabilities.
SQL and Analytics: A Dynamic Duo
Presented by Roger Cornejo, Accenture Enkitec Group
Abstract:
We are in the midst of a digital disruption. Data-driven organizations are using analytics to add value and generate innovative business ideas using vast amounts of data. Operating as a “citizen data scientist”/“data entrepreneur,” the thoughtful tech person is finding creative new ways to enable companies across the globe to leverage ever-expanding digital repositories. From a data analysis perspective, SQL (a language firmly rooted in relational algebra) is an invaluable tool. It is ubiquitous, and while other languages have attempted to supplant it, SQL remains the language of choice. This is because it is a highly performant set-processing language with capabilities that can be used to produce results far beyond what many realize. Broadly speaking, SQL provides a capability to subset/aggregate/pivot/analyze data, make inferences, and answer questions. A skillful use of this language will enable you to propel your organization forward in this digital era.
Whats new with Oracle RAC
Presented by Anil Nair, Oracle America, Inc
Abstract:
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
Advance Analytics and Machine Learning on Logs for Everyone!
Presented by Kumar Gaureve Varun, Oracle America, Inc
Abstract:
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.
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.
Hands-On Lab: Using Oracle Machine Learning for Python on Autonomous Database
Presented by Marcos Arancibia & Mark Hornick, Oracle America, Inc
Abstract:
In this Hands-on Lab, join us to experience Oracle Machine Learning for Python (OML4Py) on Oracle Autonomous Database. OML4Py supports scalable, in-database data exploration and preparation using native Python syntax, invocation of in-database algorithms for model building and scoring, and embedded execution of user-defined Python functions from Python or REST APIs. OML4Py also includes the AutoML interface for automated algorithms, feature selection, and hyperparameter tuning. In this six-part lab, explore the range of Python-enabled functionality and see how Oracle technology can support your data science projects.
Introducing the New Faces of Oracle Machine Learning
Presented by Mark Hornick, Oracle America, Inc
Abstract:
In-database machine learning offers automation, scalability, and ease of deployment. With the arrival of 21c, there are a few new “faces” to Oracle Machine Learning (OML) to take you further in your data science projects. OML on Autonomous Database introduces a Python API, a no-code AutoML user interface, and a database-external model deployment REST interface. With OML for Python, data scientists leverage the database as a high-performance data science compute engine – minimizing data movement – as well as benefit from powerful automated machine learning. OML AutoML UI places a no-code user interface in the hands of data scientists and non-expert users as a productivity tool to automate the modeling and deployment process. OML Services provides REST endpoints for model management and deployment along with cognitive text analytics. Join us for this OML overview with demonstrations.
Microservices Distributed Tracing: from traces to operational insights
Presented by Avi Huber, Oracle America, Inc
Abstract:
Microservices delivered in containers are the de facto pattern for rapid development with scalable software deployment. Open-tracing and Distributed Tracing Systems help developers address the challenges involved with diagnostics of such deployments. Trace data gives the developer insight into the execution of individual transaction instances. Data mining of the vast number of collected traces, and the event data attached to them, can provide rich operational information, far beyond the diagnostic use case.
Learn how to implement Open-tracing utilizing the new Oracle O&M platform APM Service. Learn how to extend the monitoring to older, legacy java components, as well as modern Single Page Application. See how to use the trace data for EUM, diagnostics, monitoring, planning and reporting.
Learn how to implement Open-tracing utilizing the new Oracle O&M platform APM Service. Learn how to extend the monitoring to older, legacy java components, as well as modern Single Page Application. See how to use the trace data for EUM, diagnostics, monitoring, planning and reporting.
Professional Development
With so many emerging technologies on the horizon, it’s important to take a look at how your role is changing and evolving. Explore opportunities for improving or furthering your job role in today’s fast-paced and disruptive environment.
Keynote and Roadmaps:
INSYNC Kickoff: Oracle Data Management Strategy
Presented by Jenny Tsai-Smith, Oracle America, Inc
Abstract:
Oracle has a history of delivering data management solutions of choice for managing customers’ operational and analytical workloads on-premises and in the cloud. Jenny Tsai-Smith, Vice President of Database Product Management, shares Oracle’s strategy for continuing to deliver truly unique and innovative products and services to meet and exceed customers’ requirements.
Professional Development sessions at INSYNC:
Adventures in Migrating a Legacy Database to Oracle Cloud
Presented by Sean Scott, Viscosity North America
Abstract:
It seemed so simple—migrate a relatively small legacy database from DB2 to Oracle Autonomous Data Warehouse. Nobody knew the dark secrets this database was hiding before the SOW was signed and the project was underway, but by then it was too late! Follow along as a well-planned project grows from unassuming and ordinary into a monster, devouring everything in its path and tossing aside timelines! A twisting tale, full of wrong turns and peril, heroes and villans, challenge, failure, ultimately ending with… Wait, you didn’t think I’d give away the ending, did you?
This session is not a reference or a how-to. It’s more of a what-not-to-do, reflecting and laughing (in hindsight) at a series of unfortunate circumstances and mistakes. It’s a set of lessons in resilience and determination. It’s about overcoming technical obstacles and human objections, and leveraging the tools and features in OCI so they all lived… Well, let’s not spoil things!
This session is not a reference or a how-to. It’s more of a what-not-to-do, reflecting and laughing (in hindsight) at a series of unfortunate circumstances and mistakes. It’s a set of lessons in resilience and determination. It’s about overcoming technical obstacles and human objections, and leveraging the tools and features in OCI so they all lived… Well, let’s not spoil things!
Constraint Optimization: The Difference A Comma Can Make
Presented by Oren Nakdimon, DB Oriented
Abstract:
A task can be done in a very short way and in a very long way.
Which one will you choose?
Knowledge is Power!
This session gives lots of interesting knowledge about an allegedly boring topic – Constraints.
And this knowledge will give you the power to optimize and make better decisions.
The behavior of adding columns and constraints to big tables in Oracle may vary significantly, in two aspects – duration and availability – based on the way we perform these operations. In addition, different constraints may have different impact, based on their syntax, types, states, locking, etc.
Attend this session to understand what happens exactly under the hood when we issue a simple ALTER TABLE statement, and how to utilize this knowledge for achieving better performance or higher availability.
Which one will you choose?
Knowledge is Power!
This session gives lots of interesting knowledge about an allegedly boring topic – Constraints.
And this knowledge will give you the power to optimize and make better decisions.
The behavior of adding columns and constraints to big tables in Oracle may vary significantly, in two aspects – duration and availability – based on the way we perform these operations. In addition, different constraints may have different impact, based on their syntax, types, states, locking, etc.
Attend this session to understand what happens exactly under the hood when we issue a simple ALTER TABLE statement, and how to utilize this knowledge for achieving better performance or higher availability.
How to do Unit Tests and not go crazy (and bankrupt).
Presented by Monika Lewandowska, Autonomous
Abstract:
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.
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.
From Cloud to Conversational: Transforming your Oracle Forms
Presented by Mia Urman, AuraPlayer
Abstract:
The death of Oracle Forms has been greatly exaggerated. Despite 2 decades of development, Forms is still the backbone of thousands of mission-critical applications worldwide. But where do our tried and true Forms stand while all systems are undergoing a user experience revolution or moving to the cloud? In this session, we will show how Oracle Forms is now a full member of Oracle’s cloud, mobile, and even Chat ecosystem. We will review the 4 ways that you can extend your existing Forms investments to the cloud, including:
1. “Lift-and-Shift” your Forms servers to Cloud Servers – OCI
2. Extending your applications using Oracle’s rapid development tool Visual Builder Cloud Service (VBCS)
3. Leveraging existing business logic through Chat interfaces using Digital Assistant cloud service
4. Doing DevOps using Developer Cloud Service.
The answer to how to bring your Forms into the next generation will be revealed during this session. Along with live demos and Q&A
1. “Lift-and-Shift” your Forms servers to Cloud Servers – OCI
2. Extending your applications using Oracle’s rapid development tool Visual Builder Cloud Service (VBCS)
3. Leveraging existing business logic through Chat interfaces using Digital Assistant cloud service
4. Doing DevOps using Developer Cloud Service.
The answer to how to bring your Forms into the next generation will be revealed during this session. Along with live demos and Q&A
Infrastructure as a Code with the help of emergent technologies
Presented by Francisco Munoz Alvarez & Avi Miller, Oracle, CloudDB
Abstract:
Infrastructure as code is the process of managing and provisioning computer data centers through machine-readable definition files, rather than physical hardware configuration or interactive configuration tools (by Wikipedia). On this vibrant session you would learn the differences between “configuration orchestration” and “configuration management” tools, and how emergent technologies such as Vagrant, Terraform, and Ansible fit and can be used to define, manage and provision a datacentre infrastructure or even build and maintain portable virtual environments.
The future is here, let’s take advantage of it today!
The future is here, let’s take advantage of it today!
Networking is NOT just cables and fiber!
Presented by Stephen Andert, Stephen Andert Consulting LLC
Abstract:
Just the word NETWORKING leaves a bad taste in the mouth of many technical people. At least when you are not talking about TCP/IP, fiber or CAT6. After all, one thing that attracted many of us to the IT world was not needing to deal with people.
This session will help erase that bad taste by showing you how networking can help your career in more ways than you expect. It can also be pretty easy to do if you do just a little planning.
Employees with better networking skills are beneficial to employers as your network is a resource that you can use to be a more effective problem solver.
This session will help erase that bad taste by showing you how networking can help your career in more ways than you expect. It can also be pretty easy to do if you do just a little planning.
Employees with better networking skills are beneficial to employers as your network is a resource that you can use to be a more effective problem solver.
Oracle Cloud: Bridging the Skills Gap
Presented by Basheer Khan, Knex Technology
Abstract:
Cloud Computing already dominates the IT landscape. As Oracle Cloud adoption grows exponentially, a skills gap is also on the rise. Join Oracle ACE Director, Basheer Khan, as he introduces you the Oracle Cloud landscape, identifies skills that are in demand and provides a roadmap to bridge your skills gap. Whether you are an Oracle developer, database administrator, functional expert or manager: attend this presentation to understand how you can upgrade your existing skills to stay relevant in the Oracle Cloud Computing world.
SPOF (Single Point of Focus) or How to pay attention and get stuff done!
Presented by Stephen Andert, Stephen Andert Consulting LLC
Abstract:
Don’t miss another critical deadline that makes you look bad. Understand why this happens to you and what you can do to avoid it. The short version is focus, but this session will help you understand why it is not as simple as just telling yourself to focus. Don’t worry, you will walk out of this session learning ways to improve your focus. Whether or not you implement them is up to you.
The Future’s So Bright, I Bought A Sunglass Kiosk
Presented by Jim Czuprynski, Zero Defect Computing, Inc.
Abstract:
After the events of 2020 – a once-in-a-century pandemic, an unprecedented economic downturn, social upheaval, and several hotly-contested political races – it’s easy to become discontented with your IT career path, and maybe even consider a different line of work. But the truth is that the future of IT is so incredibly bright and its horizons so tremendously broadened that the exact opposite is true: You’d better get your sunglasses ready, and you might even want to buy a few more pairs.
Exhibitors at INSYNC include:
IBM
Since 1986, Oracle and IBM have been providing customers with joint solutions, combining Oracle’s technology and application software with IBM’s complementary hardware, software and services solutions. IBM, a Platinum and Cloud Elite member of OPN, has over 15,000 Oracle resources, 10 global delivery centers, 6,000 Oracle certifications, and has won numerous awards and accolades for Oracle. To learn how IBM can help optimize your business, visit ibm.com/oracle.
Spinnaker Support
Spinnaker Support is a leading and trusted global provider of Oracle and SAP third-party support. Spinnaker Support customers get more comprehensive and responsive service, save an average of 62% on their annual maintenance fees, and can remain on their current software releases indefinitely. A rising number of our third-party support customers are utilizing the incremental services we provide, which include application managed services, technology managed services, and consulting. We remain the only third-party support vendor to provide this unique blend of services. Our customers trust us to keep their enterprise applications running at peak performance while helping them navigate from on-premise to hybrid to cloud.
Nutanix
Whether upgrading existing infrastructure or deploying new environments, on public, private or hybrid clouds, Nutanix Enterprise Cloud is the ideal solution for Oracle deployments.
Datavail
Datavail is a tech-enabled data management, applications and business intelligence company. We are an Oracle Platinum Partner with 17 specializations. Datavail offers 24×7 managed services and support for Oracle Database and Oracle Applications.
We’re one of the largest remote data service companies in North America and as a result can provide services end-to-end.
Viscosity
Viscosity North America is a recognized premier consulting firm of database technologies. Viscosity was founded by industry and authored experts who are prominent thought leaders with backgrounds in Oracle, VMWare, VCE, EMC, and Informatica. Viscosity’s capacities include Oracle Database, RAC Development, Oracle Consulting and Oracle Technical Architecture, Design and Performance Tuning, and Custom Application Development.
Select education track:
DevOps & Deploy
Working on database and/or application development means learning multiple languages and performing a balancing act between Web-based, wireless and client/server applications. What will give you the edge to create successful applications? Do you use the Oracle suite of tools, or do you need to look for something that you can integrate? And how will your applications be used? With wireless technology? Through a portal? Will your forms and reports be used on an intranet or on the internet? This track covers the topics that surround the development and deployment of your applications.
- IoT and Chatbots
- Code Management
- Complimentary Technologies
- Data Modeling
- Database Cloud/PaaS
- Design Fundamentals
- Development Fundamentals
- Development Tools
- DevOps (Ci/CD, Docker, etc.)
- Emerging Development Technologies (Python, Rest API, etc.)
- Infrastructure Technology (IaaS/Storage)
Database
The relational database continues to evolve to include more new features, and as a result, has become even more complicated. On top of all the daily challenges of maintaining a high performance database, now you have to be sure the data are available 24/7 and compatible with other systems. This track is designed to provide DBAs of every experience level and industry with the tools to productively and creatively administer your data.
- Database 101
- Database HA / DR / Recovery
- Database Internals
- Database Performance
- Database Security
- Database Upgrades and New Features
- ML in DB
- Blockchain Tables
- NoSQL Databases
Data Science & Analytics
Learn how organizations are using Data Science & Analytics to transform their operations and sustain their competitive advantage, addressing the challenges of managing rapid growth for data storage and availability, and how analytics are enabling organizations to function more efficiently. You’ll hear how other users are proactively using customer data to create opportunities, what how to make better, Big Data-driven decisions.
- Big Data
- Big Data Modeling
- Cloud BI / Analytics
- Data Analytics
- Data Integration (Kafka, etc.)
- Data Visualization
- Data Warehouse
- Hadoop
- Machine Learning and AI
- On-Prem BI/Analytics
- System Architecture (Data Federation, Data Virtualization)
Professional Development
With so many emerging technologies on the horizon, it’s important to take a look at how your role is changing and evolving. Explore opportunities for improving or furthering your job role in today’s fast-paced and disruptive environment.
- Business Acumen (Presenting, leading teams)
- Evolving DBA
- Grow Your Role
- Networking for Success
- New to IT
- Prepare for Your Next Role
- Working with Others
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.