Tag: Oracle Database Appliance

Quest Forum Digital Event 2020

Join Oracle development for the latest updates on high availability (HA) best practices in this well-established technical deep-dive session. Learn how to optimize all aspects of Oracle Active Data Guard 19c. See how to use session draining, transparent application continuity, Oracle RAC, and Oracle GoldenGate to mask outages and planned maintenance from users and to accelerate time to repair for single database or your fleet of databases. Hear about the latest HA best practices with Oracle Multitenant and understand how the new sharded architecture can achieve even higher levels of HA and fault isolation for OLTP applications. Find out how everything you know about Oracle Maximum Availability Architecture (MAA) on-premises can be deployed in the cloud.

Quest Forum Digital Event 2020

Learn how POWER9 with the Oracle 19c DB In Memory features can help you accelerates performance and reduce CPU use when performing simple and complex analytics queries. After an overview of the newest capabilities of Oracle Database In-Memory feature, we'll share our experiences testing DBIM with simple and complex queries on POWER9. We will share the speed ups achieved 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.

Quest Forum Digital Event 2020

Since 2016, Nationwide Insurance has leveraged Oracle Enterprise Manager's Fleet Maintenance capability to effectively and proactively patch our Oracle database environment to address critical vulnerabilities and maintain version currency.  Over three years, using EM capabilities, Nationwide has patched more than 7000 databases with a success rate exceeding 99%.  This session will talk about EM's Fleet Maintenance capabilities and impart some of the lessons we learned to achieve success.

Quest Forum Digital Event 2020

With 19c we get the tiny little command line tool that will allow us to update our databases "hands free."  We can do all the prechecks, fix 99% of pre-update issues, and then do the update, and finally, the post-update, all without our manual little fingers on the keyboard, well almost no little fingers on the keyboard.  Wait there is more, it is not all for just Database 19c we can use this on prior versions like 18.5 and new as well as 12c Release 2 (12.2 + DBJAN2019RU and newer).

Quest Forum Digital Event 2020

Robots may be the first to truly learn Machine Learning (ML) and expand into Artificial Intelligence (AI). Python is one of the keys to Machine Learning as we program the invention of Man's Mind to further replace man's most basic tasks. This session will focus on ML 101 and building the future ahead.

Quest Forum Digital Event 2020

Data Pump is one of the most widely used features by DBAs and comes free as a part of every database edition. With each release, more features and functionality are added to help move large volumes of data and metadata between and into Oracle databases. This session will cover the new features added to Data Pump for Oracle Database 20c, and also recap highlights of new features in 19c, 18c, and even 12.2.0.1. Whether you use Data Pump for table-mode exports, schemas, full databases, or transportable tablespace migrations, you will find new features to make your work faster and easier than ever before!

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.