Presented at INSYNC 21

Session ID: 101040

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.

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

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.

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

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.

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.