Quest Forum Digital Event 2020

To properly secure an Oracle database requires significant effort and often expensive security add-on products.  The Thrifty DBA likes having secure databases but doesn’t like to spend money on expensive security products when equivalent zero or low-cost solutions are available.  The Thrifty DBA will review and demonstrate open source security solutions that are effective in solving your database security challenges such as tools for database auditing and checking database security as well as useful security-related SQL Developer extensions.

Database 19c pluggable databases offer numerous options for the cloud. In this session, walk through Exadata Multitenant for cloud/on-premise 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/18c from previous versions and then delves into Oracle Database 12c R2/18c 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 19c if time permits.

Quest Forum Digital Event 2020

New in Oracle 20c is the Autonomous Health Service that supports centralized diagnostic monitoring of your on-premise Oracle RAC database clusters. Learn how to free up local cluster resources and improve monitoring efficiency with this centralized service-based solution. Practical tips and best practices for setup will be covered along with a demonstration of its responsive browser-based dashboard and triage console. Specific RAC database, ASM, and cluster issues will be rapidly triaged utilizing the built-in support for Trace File Analyzer and ORAchk/EXAchk collections, Cluster Health Advisor problem diagnosis, Hang Manager and Memory Guard events and QoS Management workload performance metrics.

Quest Forum Digital Event 2020

Do you want to upgrade or get your DBA certification on the latest Oracle Autonomous Database? Autonomous Database is the next evolution in data management that eliminates complexity, human error, and mundane tasks that allows you to focus on the important stuff -- data. Join us for the Autonomous DBA Specialist certification cram session.  Oracle University will be offering Test Fests so you can complete your certification!

Quest Forum Digital Event 2020

Based on Oracle Generation 2 Cloud Architecture,  Oracle Autonomous Data Warehouse (ADW) provides a fully automated data warehouse specific features to deliver outstanding query performance. ADW also comes with a library of Oracle machine learning algorithms and a new set of tools such as SQL notebooks for predictive analytics and machine learning. This allows Data scientists to run Machine Learning projects in Oracle Database without moving data and also allows Database developers to pick up Machine learning with database tables, SQL, and PL/SQL. l This session will examine Oracle Machine Learning as part of ADW collaborative environment. We will discuss the process to develop machine learning applications in the ADW Oracle Machine Learning environment:  analyze and prepare data set;  build and evaluate and apply machine learning model. We also will discuss other Oracle Machine Learning family products and what new features are coming up in Oracle 20c.

Quest Forum Digital Event 2020

It is true. You can laugh your way to understanding queuing theory, performance analysis and why systems behave the way they do.

From driving in traffic to being served at a restaurant, every person feels the impact of queuing theory. Queuing theory beautifully relates time and work into terms we can feel, like utilization, workload intensity, response time, elapsed time and systems architecture design.

With only the basics we can use foundational queuing theory to derive targeted performance solutions and goals, filter and evaluate any performance solution thrown at us and help non-technical people understand why our solutions make perfect sense.

Join us for a shockingly practical and fun session that will impact your Oracle career and beyond.

Quest Forum Digital Event 2020

Learn how to set up and configure and utilize the Oracle Database Security Assessment Tool.  The tool can help with data and database security best practices and options.  The tool can also help you uncover the sensitivity in your databases so that you and implement ways to better protect your data.

Quest Forum Digital Event 2020

This presentation will look at which 19c new features that should be investigated for use.  This presentation will also have a few 20c new features such as AutoML.  This presentation will also look at which 18c new features that should be in use (such as Snapshot Carousel, PDB Switchover, In-Memory External Tables, Merge Partition Online, Advances in the Approximate Query, Polymorphic Tables, Standby Nologging, and Password-less Schema Creation - & others).  Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm that focus on the developer.  There will be simple examples, where possible, to show the basic functionality of the new features.  Some features are too new to show example, but only explain.  We will also look at the autonomous database and Oracle's focus on the future of security.

Quest Forum Digital Event 2020

Competitive businesses rely on database as a service (DBaaS) to provide the agility needed to meet quickly changing market requirements and respond to demands for additional services. In this session learn how customers create and implement a DBaaS platform on top of Exadata, which provides rapid provisioning of databases from a service catalog, as well as integrated Oracle Recovery Manager backup and automated security compliance checks. In addition, learn how to use Oracle Enterprise Manager 13c to deliver powerful DBaaS capabilities for consolidation.

Quest Forum Digital Event 2020

Large cities are often the most progressive adapters of technology of government institutions. Join us as we discuss the challenges of large, diverse user groups like finance, roads and transportation, public health and safety including fire and police, parks and recreation, and license and regulatory enforcement. We’ll review the most useful frameworks and methods that bring value to the analytic systems of cities and other similar government agencies. We’ll also use publicly available data to demonstrate how to leverage the power of Oracle Analytics in delivering powerful results and value.