Tag: Database

Presented at INSYNC 21

Session ID: 100550

Oracle Database provides us with collections since a long as I can remember (Oracle 7.3.6.4). First as PL/SQL Tables in PL/SQL only. They have been been renamed (Index-by Tables, Associative arrays) and new implementations have been added since (Varrays, Nested Tables [SQL and PL/SQL]). Also the original Asscociative arrays have been updated, making them available in SQL as well. They play a key role in many of the newer Oracle features like BULK Processing (BULK COLLECT and FORALL) and Table functions. Using the bulk processing capabilities of your Oracle Database they can speed up your processing by an order of magnitude.

This session will show a little bit of history, how to use the collections, how to make collections available in SQL so they can be processed in other languages. How things can be done in what version and how things become easier with the newer versions of the database.

Presented at INSYNC 21

Session ID: 101920

Most modern computer applications include an “advanced search” screen that allows users to enter multiple criteria and parameters. Unfortunately, behind the scenes, this functionality can cause major headaches for implementing the back end, because the resulting queries may reference an unknown number of tables and/or columns and may return unknown numbers of rows. In addition, the results may mutate depending upon the parameters. There are multiple ways of solving this problem with various levels of efficiency. This presentation will demonstrate how to handle generic search functionality within an Oracle database by utilizing Dynamic SQL, object collections, and a bit of a creativity.

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.

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