ODTUG Webinars | Online Oracle Developer Education


Is there a topic you would like covered but do not see here? We are happy to take webinar suggestions. Email us at veronica@odtug.com.

Did you miss a webinar? As a full ODTUG member, you can view all of our past webinars at any time. Just log in and you will see the link for the recorded list under the Resources tab. Not a member? Join now for $99!

NASBA_CPERegistry_logo_color_transparent.pngODTUG is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry  of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.NASBARegistry.org.


How to qualify for CPE Credits:

  • Register for the webinar, indicate that you are a Full (paid) ODTUG member, and check the box on your registration form to indicate you'll be earning credits.
  • Attend the session and fill out an evaluation form; make sure to include your name. The evaluation form will pop up on your screen once the webinar is completed.
  • You must respond to all poll questions that will show up on the screen at random during the presentation.
  • After the webinar, you will receive a certificate via email for the session you attended.
  • Submit the certificate to your State Board of Accountancy.

Webinars are free to all. No cancellation is required. If you do not attend, your registration will automatically be cancelled.

Webinars that are eligible for CPE credit will be noted as such in their description.


Our webinar calendar is constantly evolving! Check back frequently, as more webinars will be added to the schedule.

Suggest a Topic   Past ODTUG Webinar


 

Logo3-300dpi.jpgcommunities_0006_Layer-6.pngThursday, March 11, 2021 12:00 PM - 2:30 PM EST
PART
 3
: ORACLE DATABASE PERFORMANCE TUNING
Presented by ACEAss-01.png Gary Gordhamer and Ron Mehrer, Viscosity North America


Registration is limited to 30 hands-on lab students, but unlimited to those interested in viewing the presentation only.  The first 30 to register for the hands-on lab will receive lab credentials the day before the session via email.

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 issues. 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 – Be Prepared
    1. MOS Reading
    2. Profiles vs Baselines
  2. SQL Explain Plan
    1. Normal
    2. Plan statics
    3. Monitor
    4. Finding you statements
  3. Object Statistics
    1. Automated jobs
    2. Checking object staleness
  4. SQL Plan Management (SPM)
    1. SPM finding performance regression
  5. SQL Plan Baseline
    1. Create a baseline
    2. Finding invalid baseline
    3. Changing baseline
  6. SQL Patch
    1. Grabbing a SQL profile
    2. Adding a patch (hint)
  7. SQL Profile
    1. Generated by SQL tuning advisor
    2. Transport to another DB

Register Here




Friday, March 19, 2021 12:00 PM - 1:00 PM EST CPE Web Icon.png communities_0003_Layer-3.png
Labor Cost Distribution in Higher Education
Presented by ACE.pngVatsal Gaonkar, Alithya



*This webinar is eligible for one (1) CPE credit for Computer Software & Apps. To receive the credit attendees must be a Full (paid) ODTUG member, attend the entire webinar and answer all poll questions that will pop up on-screen during the webinar, and fill out the evaluation form (with your name) that will pop up on your screen immediately after the webinar.

Prerequisites: None
Program Level: Beginner to Intermediate
Instructional Delivery Method: Group Internet Based
Price & cancellation policy: Free. No need to cancel - if you do not attend you will be automatically cancelled.

In Higher Education, grants and endowments sponsor the labor cost and utilization. It is commonplace to have employees reside in a domicile cost center and get utilized fully or partially across other cost centers. The case study will showcase how an academic pillar of a health care business uses the concept of employee distributions in its labor cost modeling to employees from home or domicile cost center to cost centers where they are utilized or where the labor cost expenses are accrued.

In a live demo, the presenter with show how a domicile employee is distributed across many cost centers. The expenses for the employee are only accrued if the employee is distributed out. Open hires or open positions management with distribution will be another feature that will be demonstrated. The open hires will follow the same methodology of the position being in the domicile department and then undergoing distributions. Such labor cost modeling needs are also seen in public sector planning which should pique interest of public sector planning audience. Another takeaway from the session will be understandings and insights into how Groovy business rules can work with smart lists and data maps for incremental clears and pushes in an EPM Cloud planning application.

Register Here


Logo3-300dpi.jpgcommunities_0006_Layer-6.pngThursday, March 25, 2021 12:00 PM - 2:00 PM EST 
PART
 2 (RESCHEDULED)
: UPGRADING TO ORACLE DATABASE 19C 
Presented by ACE Director.jpgCharles Kim and ACE.pngSean Scott, Viscosity North America


Registration is limited to 30 hands-on lab students, but unlimited to those interested in viewing the presentation only.  The first 30 to register for the hands-on lab will receive lab credentials the day before the session via email.

Overview

In this two-hour class, students will get hands-on experience with how to upgrade databases to Oracle Database 19c. A virtual presentation will be followed by the hands-on practicum which will focus 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).

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. Performing AutoUpgrades to Oracle Database 19c 

Register Here


CPE Web Icon.png

Analytics square with padding-01.pngWednesday, April 7, 2021 12:00 PM - 1:00 PM EST  communities_0003_Layer-3.png
Fulfill the True Potential of Essbase with Hybrid Mode and Cube Designer  
Presented by ACE Director.jpgTim German, Qubix, Sponsored by Applied OLAP


Applied OLAP.png


*This webinar is eligible for one (1) CPE credit for Computer Software & Apps. To receive the credit attendees must be a Full (paid) ODTUG member, attend the entire webinar and answer all poll questions that will pop up on-screen during the webinar, and fill out the evaluation form (with your name) that will pop up on your screen immediately after the webinar.

Prerequisites: None
Program Level: Beginner to Intermediate
Instructional Delivery Method: Group Internet Based
Price & cancellation policy: Free. No need to cancel - if you do not attend you will be automatically cancelled.


Believe it or not, Hybrid Mode in Essbase—which brings together the rich, intuitive calculation capability of Block Storage and the dynamic aggregation capability of Aggregate Storage—is almost seven years old! But in earlier on-premises versions, Hybrid limitations such as unsupported calculation functions sometimes made it difficult for practitioners to take full advantage. In Essbase 21c, we have "full coverage" Hybrid Mode. We also have brand new Cube Designer tools (the Baseline and Solve Order utilities) that help to document performance parameters, find the optimal balance between calculation and query speed, and catch potential performance problems. In this session, we'll review the principles of Hybrid Mode and learn how Cube Designer can help with Hybrid optimization.

Register Here