Tag: Database & Technology

Jul 10

Oracle Database 19c SIG

SIG Meetings & Calls

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

We are creatures of habit. We tend to stay the course concerning what we create and how we create it. But is this tendency causing us to settle for just good enough? From OBIEE to Data Visualization Desktop to Oracle Analytics Cloud… this is not your parent’s OBIEE. Maybe it’s time for a reboot?

In this presentation, we’ll explore the new face of Oracle Analytics, both literally by looking at Oracle Data Visualization, and figuratively with how advances in the platform can affect our approach and methodology. If you are new to Oracle Analytics, I’ll convince you that this product is capable of enabling a data-driven culture. If you’ve been around the block a few times with OBIEE, then I’ll make you question how you’ve delivered analytics in the past.

Quest Forum Digital Event 2020

First introduced in 12cR2, Oracle Sharding was further improved in 18c/19c for linear scalability and complete fault isolation of OLTP workloads. With Oracle, sharding data are partitioned horizontally partitioned across discrete  Oracle Databases (shards) in shared-nothing architecture that collectively form a single logical database. Come to this session to learn its latest improvements in Oracle 19c and 20c, sharding on database cloud(DBCS) and leveraging sharding for your business. We will share the experience and tips of configuring sharded database architecture with HA  replication for massive scalability and complete fault isolation. We will also discuss some of the considerations of choosing the sharding method in a global geographic distribution application and some experience of using the Sharding Advisor tool.  We will also discuss some new sharding features that are coming in Oracle 20c such as Federated Sharding and sharding with database in Persistent memory.

Quest Forum Digital Event 2020

Can you convert an integrated Data Warehouse to a set of Micro Services?

In this presentation we discuss the benefits of Micro Services, look at how we can convert a working Data Warehouse into independent microservices, discuss the pitfalls and demonstrate a real-life project where we converted our Data Warehouse to Micro Services.  This enabled a small team to provide frequent releases, increase automation, and become more agile.

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.