Presented at INSYNC 21

Session ID: 100770

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.

Presented at INSYNC 21

Session ID: 101260

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.

Presented at INSYNC 21

Session ID: 100600

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.

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.