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.

Presented at INSYNC 21

Session ID: 101250

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.

Presented at INSYNC 21

Session ID: 101210

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.

Presented at INSYNC 21

Session ID: 101660

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.

Presented at INSYNC 21

Session ID: 100690

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.

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.