Quest Forum Digital Event 2020

By this point, everyone has heard of pluggable databases.  But, what about Application Containers?  In this presentation, we will discuss what they are, why you might use them, and how to build and maintain them.  They are not heavily documented yet, so I will also discuss some tips, tricks, and lessons learned in my initial construction of this extension to the Oracle Multi-tenant Cloud Architecture.

Quest Forum Digital Event 2020

Learn the how and why of running Oracle on Windows, and some tricks to help you along the way.  This session will benefit the Beginner to Mid-Level Oracle DBA faced with running Oracle on a Windows Server, and may also teach some old hands a trick or two.  Instead of delving into topics that would be for Server Administrators, this talk will deal with issues directly related to DBAs running Oracle on a Windows Server.  Find out how to leverage many of the features that Windows has to help you as a DBA, including taking advantage of some of the command line and scripting options available.

Quest Forum Digital Event 2020

This presentation explains the functionality and administrative operation of the Multitenant (MT) option to the Oracle Database.  This overview of the MT architecture precedes the majority of the presentation content, which covers administration scenarios of the MT option with several examples.  The administration examples include common procedures related to pluggable database management, plus examples of new 18c and 19c functionality.

Quest Forum Digital Event 2020

Oracle Log Analytics Cloud Service offers an easy way to monitor, aggregate, analyze, and correlate log events from across your database and Exadata environment. In this session learn how DBAs can easily configure log collection and efficiently analyze logs from their database environment to rapidly troubleshoot problems. See how to use plain language analysis to easily find errors across different log sources. Experience the power of machine learning techniques to rapidly identify anomalies that can lead to a problem’s root cause and eliminate finger-pointing.

Quest Forum Digital Event 2020

Learn to use the new service model that Red Hat 7 is using instead of the run control from previous versions.  This presentation will give you the exact scripts that you need to automatically stop and start Oracle during a reboot.

Quest Forum Digital Event 2020

Oracle Databases are a target of cyber-attacks by hackers looking to obtain sensitive data such as credit card numbers and personally identifiable information used in identity theft.  Even though databases are not externally accessible, they are still a target as most cyber-attacks penetrate the network perimeter and look for high-value targets within your internal network.  This session will review and demonstrate the tools most used in database breaches including Metasploit, Nmap, database rootkits, and other tools.  Each tool will be demonstrated and the indications of such use against the database will be shown.

Quest Forum Digital Event 2020

Attend the New Generation Oracle RAC SIG meeting at Collaborate 2020! We will have an overview of the RAC SIG's goals and objectives including meeting of the new board, upcoming webinars, and the next iteration of RAC Attack.  We will also have Anil Nair, Oracle Senior Principal Product Manager (RAC), attend this meeting to offer a sneak preview of what's coming in Oracle RAC and why Oracle RAC 19c and later is the RAC for a New Generation.  Finally, we will have a Q&A, so come and share with us your questions that you might have around Oracle RAC.

Quest Forum Digital Event 2020

Use the latest technology on robotics, machine learning & Oracle chatbots to create the future with AI.  We will explore how to leverage and integrate robotics & machine learning into your companies tech plan.  We'll show the state of robotics and how you can test and use this technology to create the future.

Quest Forum Digital Event 2020

In this session, Blaine Carter will demonstrate how to REST enable your database using Oracle Rest Data Services (ORDS). He will demonstrate how to use SQL Developer to create and deploy REST services in ORDS. First, Blaine will "Auto Rest" enable a table and a PL/SQL package. Then, he will secure the API and create an OAuth2 client that can be used to access the service. Next, he will walk through the steps of creating a custom REST API using the REST Data Services wizard. This API will be used to POST image files into a BLOB column in the database and the GET handler will serve the image directly in a web page. You will leave this session with an understanding of how to quickly create REST services on your own database.

Quest Forum Digital Event 2020

Complex performance situations are not always quickly diagnosable using an AWR time-based analysis or an ASH sample-based analysis. And certainly, the diagnosis will not be completed the second new data becomes available or before a support ticket has been received!

A solution is to use a supervised learning classification machine learning model. We can train the model to recognize and "understand" a virtually unlimited number of Oracle performance and business-related data.

Once trained, we will present the model with just-available data asking, for example, if a support ticket will likely be submitted. Or perhaps, if the performance will likely be green, yellow, or red.

Join me as I build a "Poor Performance" indicator using 100% free industry-standard tools, such as Python and the "Always Free" Oracle Autonomous Database with Oracle ML SQL Notebooks. All presentation slides, scripts, and a recording of the demonstration are available!