Oracle 19c Hands-On Experience

Complimentary 6 Part Virtual Workshop | Multiple Dates

Viscosity Workshop Topics:

We are constantly adding new dates for all parts of this series. So be sure to check back regularly.  Sessions do not need to be taken in order.  Skip ahead to info/registration for a specific session:

Part 1: Oracle Database 19c New Features

Part 1: Oracle database 19c new features
Overview

This two hour class introduces new features and enhancements in the Oracle 19c Database. Students will get hands-on experience with Automatic Indexing, Performance Tuning and SQL Quarantine. Participants will also discover ways the Oracle 19c improves database security and protects data.

Outline
  1. Automatic Indexing
  2. SQL Performance Tuning Enhancements
    1. Automatic SQL Plan Management
    2. Real-Time Statistics and High-Frequency Statistics Collection
    3. SQL Repair Advisor
  3. SQL Quarantine
  4. Security Enhancements
    1. Schema-only accounts
    2. Passwords removed from Oracle-supplied accounts
    3. Privilege Analysis

 

Register Now:

Back to top of page

 

Part 1: 19c New Features

Wed June 24, 2020  |  10:30 AM – 12:30 PM Central – Registration CLOSED
Tue July 7, 2020  | 2:00 PM – 4:00 PM Central – registration CLOSED
Wed July 8, 2020  | 11:00 AM – 1:00 PM Central – registration CLOSED

Part 2: Upgrading to Oracle Database 19c

Part 2: Upgrading to Oracle Database 19c
Overview

In this two hour class, students will get hands-on experience with on how to upgrade databases to Oracle Database 19c.  

A virtual presentation will be followed by the hands-on practicum on performing an actual database upgrade.  Attendees will have access to a virtual machine with Oracle database versions 11.2.0.4 and 12.1.0.2 pre-installed with the latest PSU.  Attendee can perform database upgrades from Oracle versions 11.2.0.4 or 12.1.0.2 to Oracle Database 19c (19.7 or higher).  

Outline
  1. Installing Oracle Database 19c software
  2. Patching the database software to the latest Release Update (RU)
  3. Performing pre-upgrade tasks prior to the database upgrade
  4. Upgrading an Oracle 11.2.0.4 or 12.1.0.2 database to Oracle Database 19c with the latest RU
  5. Performing post-upgrade tasks after the database upgrade
  6. Learn how to perform AutoUpgrades to Oracle Database 19c

Register Now:

Back to top of page

Part 2: Upgrading to 19c

Wed july 22, 2020  |  11:00 AM – 1:00 PM Central – Registration closed
Fri august 7, 2020  | 11:00 AM – 1:00 PM Central – registration Closed
Wed august 19, 2020  | 9:30 AM – 11:30 AM Central – registration closed
Thu September 17, 2020  |  11:00 AM – 1:00 PM Central – Register Now

Part 3: Performance Tuning

Part 3: Performance Tuning
Overview

Oracle database upgrades often lead to performance related issues.  This is due to the number of underlying technical changes in software, introduction of new features, and general enhancement of the products.  With many 19c upgrades going on, it’s good to know how to use the many technical features in Oracle for dealing with or even eliminating performance issue.  In this lab we will go through some of the basic skills that every DBA should have around performance tuning from enhance explain plans and gathering statistics to using SQL Plan Management.  We will also cover the differences between SQL Baselines and SQL profiles.  This session should be good if you are an experienced DBA just brushing up on your skills, or new to using Oracle database performance tuning tools.

Two hour course: A virtual presentation will be followed by the hands-on practicum on SQL tuning.  Attendees will have access to a virtual machine with Oracle database pre-installed.

Outline
  1. 19c upgrade – be prepared
    1. MOS Reading
    2. Profiles vs Baselines
    3. SQL Explain Plan
      1. Normal
      2. Plan statics
      3. Monitor
      4. Finding you statements
      5. Object Statistics
        1. Automated jobs
        2. Checking object staleness
      6. SQL Plan Management (SPM)
        1. SPM finding performance regression
      7. SQL plan baseline
        1. Create a baseline
        2. Finding invalid baseline
        3. Changing baseline
      8. SQL Patch
        1. Grabbing a SQL profile
        2. Adding a patch (hint)
      9. SQL Profile
        1. Generated by SQL tuning advisor
        2. Transport to another DB

      Register Now:

      Back to top of page

      Part 3: Performance Tuning

      Thu August 27, 2020  |  10:00 AM – 12:00 PM Central – Class Full
      Fri September 11, 2020  |  11:00 AM – 1:00 PM Central – Register now
      Fri October 2, 2020  |  11:00 AM – 1:00 PM Central – Registration coming soon

      Part 4: Bullet Proof your Data Guard

      Data Guard: Configure and Best Practices
      Overview

      In this two hour class, students will get access to 2 VMs with Oracle Database 19c pre-installed to setup and configure Data Guard.

      Learn how you can setup Data Guard with all the best practices. Attendees will receive a brief history of Data Guard and how it became Data Guard. Then, dive directly into new features in Oracle Data Guard 12c Release 2/18c/19c. This workshop will disseminate Data Guard best practices and reference architectures that DBAs need to know to protect their Oracle ecosystem.  Viscosity will demonstrate how DBAs should setup, configure, and monitor mission critical Data Guard environments (including Active Data Guard).

      Outline
      1. Building the Physical Standby database
      2. Monitoring the Physical Standby database
      3. Maintaining the Physical Standby database
      4. Configuring Data Guard Broker
      5. Performing Backup and Recovery with RMAN
      6. Setting Archive Retention
      7. Switchovers
      8. Failovers
        1. FSFO
        2. Observer
      9. Active Data Guard
      10. Snapshot Standby

      Register Now:

      Back to top of page

      Part 4: Data Guard
      Tue September 29, 2020  |  11:00 AM – 1:00 PM Central – Register Now
      Thu October 15, 2020  |  11:00 AM – 1:00 PM Central – Registration coming soon

      Part 5: Pluggable Databases are Risen from the Dead

      Part 5: PDB is Risen From the Dead in Oracle Database 19c
      Overview

      In this two hour class, students willlearn the fundamentals to managing the new frontier of pluggable databases. Each student will be assigned 2 VMs to configure PDBs and work labs.

      With the recent announcement at Oracle OpenWorld, starting in Oracle Database 19c, we are allowed to have up to 3 pluggable databases per container database. Effective Oracle Database 20c, non-containerized databases will no longer be supported. As an attendee of this session, you will receive a free copy of the PDB Me to Oracle Cloud book written by Oracle ACEs. Come learn what it takes to effectively create, configure, manage and monitor Oracle PDBs while learning all the latest and greatest new features of Oracle PDBs from Oracle 12.2/18c/19c.

      Outline
      1. Migrate a non-CDB database to a singleton containerized database
      2. Setup Data Guard between the primary and standby environments
      3. Setup performance governors on the database tier
      4. Clone PDB databases from one container to another container without downtime
      5. Setup refreshable PDBs, Proxy PDBs, and to setup PDB Archives
      6. Configure lockdown profiles
      7. Configure snapshot carousels

      Register Now:

      Back to top of page

      Part 5: coming soon

       

      Viscosity is a proud Oracle software and hardware reseller that provides professional and managed services.