Tag: Database & Technology

Presented at INSYNC 21

Session ID: 101480

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.

Presented at INSYNC 21

Session ID: 101950

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.

Presented at INSYNC 21

Session ID: 101580

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.

Presented at INSYNC 21

Session ID: 100390

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 [email protected] 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: 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.