Quest Forum Digital Event 2020

Application infrastructures are not becoming simpler; they are becoming more complex. As companies increase the granularity of application architectures via microservices and microsegmented networks, it becomes increasingly difficult to maintain constant connections from the application server to the database.

This presentation will explore those difficulties and provide some methods to understand how firewall timeouts and TCP KeepAlives interact.

Quest Forum Digital Event 2020

This presentation addresses the essential questions regarding JSON and the Oracle Database:
-How to load JSON documents into the database?
-Storing JSON documents or spreading the contents into relational tables?
-How do I create JSON files from data?
-How to query to large volumes of JSON documents fast and efficient?
-How do I publish JSON documents from the Database?

All those questions will be answered using examples and demos. This presentation contains detailed live demos. All demos will be made available for download.

Quest Forum Digital Event 2020

Anyone who’s familiar with tuning SQL knows that you need to get the execution plan for a query.  But once you’ve got an execution plan, what do you do with it?  Everyone understands that an execution plan is important for diagnosing, but almost no one knows how to answer questions like “which step in the execution plan is taking the longest?” “Which hardware component (CPU, Memory, Disk) is causing my query’s bottleneck?” “Is my parallel query making good use of its resources, or are they being wasted?”  If you have the Oracle Tuning and Diagnostic Pack license for your database and 30 seconds, you can find the answer to these questions--and more!

Quest Forum Digital Event 2020

This presentation explains the various data movement techniques of the Multitenant (MT) option to the Oracle Database.  The techniques discussed cover unplugging and plugging, cloning, CDB Fleet, Snapshot Carousel, CDB/PDB upgrades, and PDB refresh.  Related administrative topics such as charactersets, proxy PDBs, backup and recovery, Data Pump, RAC, and Data Guard topics are discussed.

Quest Forum Digital Event 2020

Learn best practices for upgrading Oracle RAC and GI. We will cover known issues and workarounds for critical components like ASM, GI, and Database.

Quest Forum Digital Event 2020

Your databases may contain sensitive personal data like Social Security numbers, credit card numbers, addresses, date of births, and salary information. Understanding in what tables and columns sensitive data resides is critical in protecting the data and ensure compliance with regulations like GDPR, PCI, and the new California Consumer Privacy Act (CCPA). However, sensitive data is like a weed and can spread quickly if not properly managed. The challenge is how to effectively and continuously find sensitive data, especially in extremely large databases and data warehouses.  This session will discuss methodologies and tools to find sensitive data such as by searching column names, crawling the database table by table, and performing data qualification to eliminate false positives.  Other locations where sensitive data might reside such as trace files, dynamic views (e.g., V$SQL_BIND_DATA), and materialized views will be reviewed.

Quest Forum Digital Event 2020

AsterionDB has pioneered the ability to seamlessly store and manage both structured and unstructured data in the Oracle Database.  We couple this with the ability to express any business logic required at the data-layer. These capabilities allow us to now build an architecture that can not be hacked. To be clear, hacking your API is not the same as hacking your architecture/platform. Hacking an API can be as simple as stealing a password - that's bad. Hacking an architecture is what happens when all of your files are stolen or locked up w/ ransomware. That's worse! This session will delve into the techniques required to build an impervious architecture that is easily adept at securing structured and unstructured data.

Quest Forum Digital Event 2020

Oracle Sharding is a technology for managing multiple, geographically dispersed databases in a shared-nothing architecture. Sharding is often associated with large, complex databases but that need not be the case. Based on Oracle Partitioning technology, sharding is a component of Oracle's Maximum Availability Architecture and boasts a rapidly growing user base. Its adoption is a result of the many database challenges it solves, including extreme availability, fault isolation, data tenancy, application response and latency, hybrid cloud deployment, migration, and data sovereignty. In this presentation, learn how Oracle's sharding technology works, its limits, implementation planning, use cases, and features and enhancements planned in Oracle 20c.

Quest Forum Digital Event 2020

Right from the first installation and configuration of the Oracle Clusterware, you need a good deal of expertise. This starts with the preparation of the operating system and ends with the various input fields and choice boxes in the graphical user interface that need to be completed. Although installation is certainly no bag of fun it should nevertheless be reproducible, so automating the procedure seems the obvious thing to do. This presentation explains a possible solution that avoids any graphical user interface interaction and whose efficacy has been tried and tested in numerous projects.

Quest Forum Digital Event 2020

Epsilon deploys real-time marketing solution for many customers, Application Uptime and Performance SLAs are key business measures. Using Oracle MAA technologies, RAC, Data Guard, GoldenGate, and Application Continuity, Epsilon is able to provide customers a platform where planned maintenance operations are completely hidden from application end users. This allows us to be fully compliant.  In fact, by using the Oracle high availability solution, Application Continuity, we even hide unplanned outages from end users.