ODTUG Kscope21 Virtual Event

The ODTUG Kscope21 Virtual Event is the premier Oracle developer conference, attracting Oracle experts from all over the world. With cutting-edge technical sessions and opportunities to connect to the global ODTUG community, this event is perfect for Oracle developers who want to boost their skills at any stage of their career.

The ODTUG Kscope21 Virtual Event features presentations across a variety of technical content topics, including Oracle Database, Oracle Application Express, Oracle EPM-Hyperion, and Oracle Analytics, just to name a few. The conference offers a multitude of educational benefits for attendees. Among the highlights are:

  • Technical sessions with real-world solutions
  • Expert panels
  • Half-day Oracle Symposiums
  • Interactive small group breakouts
  • Video chat with the experts and your peers
  • Flexible agenda with half-day sessions and access to session replays
  • Live presentations, Q&A, session chat, and polling give you direct expert advice and feedback from industry leaders
  • An easy-to-use, web-based platform with nothing to download or install ahead of time and one-click easy login on show days
  • Access to our virtual exhibit hall

Along with educational opportunities, the ODTUG Kscope21 Virtual Event offers fun networking activities, including:

  • Engaging demos on the hottest tips, tricks, tools, and technologies in the virtual exhibit hall
  • Sponsor & exhibitor virtual events—bond with your peers and make new connections in an array of virtual settings, all thanks to our sponsors!

DB-Oracle 19c Hands-On Experience: Pluggable Databases are Risen from the Dead

Join ODTUG and Viscosity for a hands-on virtual class on Oracle Database 19c.

We have a limited number of user IDs available for the hands-on lab, so be sure to register quickly as a “Hands-On Participant” or for the HOL Waiting List.

Registration is unlimited for those interested in View and Listen only mode.

In this two hour class, students will learn 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.

Emerging Women in Tech Panel Discussion

Join us for an ODTUG WIT discussion about growing your career in tech and building your own brand. How do you find your space in the community, continue to learn and develop, and find a technology you are passionate about? Panel led by: Steisi Manco and Oracle ACE Kate Helmer, Huron, Ghaida Khader, Azdan Business Analytics, and Jennifer Nicholson, Oracle Corporation.

ODTUG EPM Webinar Configuring Oracle Projects

Presented by Jesse Martin, Alithya. Deploying the Projects module provides the ability to plan upcoming projects with the additional detail that’s often required but not always available. Whether planning revenue or expense projects, this module includes several project types and planning methods to support individual, project-level detail. In this webcast, we’ll take a look at some features and processes within the out-of-the-box Projects module, review the configurable artifacts, and demonstrate a simple application build.

Topics include:

• Configuring the initial deployment

• Setting up a new project and associated detail

• Revenue & expense planning: labor, materials, equipment, other

This webcast is for Hyperion admins and FP&A personnel who would like to understand the basics of the Projects module and whether detailed project planning is a fit for their organization.

DB Viscosity Training: Upgrading to Oracle 19c

Join ODTUG and Viscosity for a hands-on virtual class that introduces upgrading to Oracle 19c. In this two hourclass, students will get hands-on experience with on how to upgrade databases to Oracle Database 19c.</span>

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 OracleDatabase 19c (19.7 or higher).

We have a limited number of user logins are available for hands-on lab, so be sure to register quickly as a “Hands-On Participant” if you want to secure a login for yourself. Registration is unlimited for those only interested in watching/listening.

The hands-on-lab will consist of the following:

• Installing Oracle Database 19c software
• Patching the database software to the latest Release Update (RU)
• Performing pre-upgrade tasks prior to the database upgrade
• Upgrading an Oracle 11.2.0.4 or 12.1.0.2 database to Oracle Database 19c with the latest RU
• Performing post-upgrade tasks after the database upgrade

DB Viscosity Training (RESCHEDULED): Upgrading to Database 19c

Join ODTUG and Viscosity for a hands-on virtual class that introduces upgrading to Oracle 19c. In this two-hour class, students will get hands-on experience 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. Attendees can perform database upgrades from Oracle versions 11.2.0.4 or 12.1.0.2 to Oracle Database 19c (19.7 or higher).

We have a limited number of user logins are available for the hands-on lab, so be sure to register quickly as a
“Hands-On Participant” if you want to secure login for yourself. Registration is unlimited for those only interested in watching/listening.

The hands-on-lab will consist of the following:

• Installing Oracle Database 19c software

• Patching the database software to the latest Release Update (RU)

• Performing pre-upgrade tasks prior to the database upgrade

• Upgrading an Oracle 11.2.0.4 or 12.1.0.2 database to Oracle Database 19c with the latest RU

• Performing post-upgrade tasks after the database upgrade

DB Viscosity Training PART 3: ORACLE DATABASE PERFORMANCE TUNING

Join ODTUG and Viscosity for a hands-on virtual class that introduces upgrading to Oracle 19c. In this class, students will get hands-on experience with on how to tune your Oracle database 19c.

We have a limited number of user IDs available for the hands-on lab, so be sure to register quickly as a “Hands-On Participant” or for the HOL Waiting List. Registration is unlimited for those interested in only watching/listening.

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.

Outline:

1. 19c upgrade / Lab setup

A. MOS Reading

B. Profiles vs Baselines

C. Optimizer Decision Tree

2. SQL Explain Plan + Lab

A. Normal

B. Plan statics

C. Monitor

D. Finding your statements

3. Database Statistics + Lab

A. Automated jobs

B. Checking object staleness

4. SQL Plan Management (SPM) / Baselines + Lab

A. Create a baseline

B. Evolving Baseline

C. Viewing Baseline Plan / Usage

5. SQL Profile + Lab

A. Generated by SQL tuning advisor

B. Transport to another DB

6. SQL Patch + Lab

A. Grabbing a SQL ID

B. Adding a patch (hint)

DB Viscosity Training PART 2: Upgrading Oracle to 19c.

Join ODTUG and Viscosity for a hands-on virtual class that introduces upgrading to Oracle 19c. 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). Only 30 user logins are available for hands-on, so be sure to register quickly as a “Hands-On Participant” if you want to secure a login for yourself. Registration is unlimited for those only interested in watching/listening.

The hands-on-lab will consist of the following: 

• Installing Oracle Database 19c software •

Patching the database software to the latest Release Update (RU)

• Performing pre-upgrade tasks prior to the database upgrade

• Upgrading an Oracle 11.2.0.4 or 12.1.0.2 database to Oracle Database 19c with the latest RU

• Performing post-upgrade tasks after the database upgrade

Oracle 19c Hands-On Experience: New Features

Join ODTUG and Viscosity for a hands-on virtual class that introduces new features and enhancements in the Oracle 19c Database.

In this two hour class, 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.

Only 30 user logins are available for hands-on, so be sure to register quickly as a “Hands-On Participant” if you want to secure a login for yourself. Registration is unlimited for those only interested in watching/listening.

Outline:

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

Preparation: Students will need to have internet access, a web browser and a PDF reader if they are participating as a hands-on student.

EPM Webinar – Configuring Workforce: Employee? Job? Or Both?

From: https://www.odtug.com/p/ca/vi/sid=703

An out-of-the-box Workforce module allows companies to plan for labor related expenses and integrate with other modules such as financials. Workforce provides options to enable expense planning, headcount planning, and workforce management. But first you need to determine the granularity at which to plan your Workforce: Employee only, job only, or employee and job?

In this webinar, we will take a deeper dive into those three levels of granularity and what the implications are for each. We will also review the most important enablement and configuration processes for the Workforce module.