Presented at INSYNC 21

Session ID: 101130

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.

Presented at INSYNC 21

Session ID: 101200

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.

Presented at INSYNC 21

Session ID: 100090

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.

Presented at INSYNC 21

Session ID: 100540

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.

Presented at INSYNC 21

Session ID: 100490

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.

Presented at INSYNC 21

Session ID: 101190

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.

Presented at INSYNC 21

Session ID: 100810

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.

Presented at INSYNC 21

Session ID: 100450

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.

Presented at INSYNC 21

Session ID: 101510

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.

Presented at INSYNC 21

Session ID: 100480

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.