+1 401 783 6172 (International callers)
gary@skillbuilders.com
Request Info
Register Login

Login/Register to Access all of Skillbuilders' Content

Connect with:

Login with Facebook Login with Google Login with LinkedIn

Login with your site account

Connect with:

Login with Facebook Login with Google Login with LinkedIn


Lost your password?

Not a member yet? Register now

SkillBuildersSkillBuilders
  • Services
    • Oracle APEX Hosting on AWS
    • Oracle Database Admin/Remote DBA
    • Oracle APEX App Development
    • APEX Administration
  • Products
    • Oracle Database Manager (free)
    • Deprecated APEX Plugins
  • Training
    • Course Calendar
    • Oracle DBA
    • Oracle Developer
    • Oracle APEX
    • Web Development
    • Free Webinars
    • Mentoring
    • Free Oracle Database Tutorials
      • Free Oracle Database Administration Tutorials
      • Free Oracle Developer Tutorials
      • Free Oracle APEX Tutorials
      • Free Solaris 11, Oracle VM and ZFS Tutorials
      • Free Oracle Database Retired Tutorials
      • Free Groovy and Grails Tutorials
  • Blog
  • About
    • About Us
    • Our Team
    • Events
    • Case Studies
      • Oracle Database Administration
      • Oracle APEX Development
      • Oracle APEX Administration
      • Oracle and AWS Cloud
    • Client Testimonials
    • Contact
    • Services
      • Oracle APEX Hosting on AWS
      • Oracle Database Admin/Remote DBA
      • Oracle APEX App Development
      • APEX Administration
    • Products
      • Oracle Database Manager (free)
      • Deprecated APEX Plugins
    • Training
      • Course Calendar
      • Oracle DBA
      • Oracle Developer
      • Oracle APEX
      • Web Development
      • Free Webinars
      • Mentoring
      • Free Oracle Database Tutorials
        • Free Oracle Database Administration Tutorials
        • Free Oracle Developer Tutorials
        • Free Oracle APEX Tutorials
        • Free Solaris 11, Oracle VM and ZFS Tutorials
        • Free Oracle Database Retired Tutorials
        • Free Groovy and Grails Tutorials
    • Blog
    • About
      • About Us
      • Our Team
      • Events
      • Case Studies
        • Oracle Database Administration
        • Oracle APEX Development
        • Oracle APEX Administration
        • Oracle and AWS Cloud
      • Client Testimonials
      • Contact
    • Home
    Loading Events

    « All Events

    • This event has passed.

    Tuning Oracle for DW and OLTP with Real-Time Materialized Views – A Free Webinar

    January 19 @ 1:00 pm - 2:00 pm UTC

    • « Oracle Database Logon: Let’s Count (and Learn) The Ways – A Free Webinar
    • Oracle APEX 20.2 New Feature & Practical Applications – A Free Webinar »

    REGISTER FOR THIS WEBINAR

    How to Support Data Warehouse and OLTP Use in a Single Oracle Database

    A free webinar

    Description

    Learn how to implement Oracle Real-Time Materialized Views to tune a single Oracle Database for both Data Warehouse and OLTP use. Configuration is not necessarily straight forward. We’ll demonstrate the problems, and how to fix them.

    Background

    How can you tune an Oracle database for both OLTP and Data Warehouse use at the same time? A common solution is to use materialized views: the small transactions address the tables, the big queries hit the views. However, if the queries need to return real-time information, you will likely end up with either fast transactions and slow queries, or slow transactions and fast queries. Or perhaps everything will be slow.

    In this webinar John will demonstrate how to use Oracle materialized views to optimize queries without impacting on transaction processing by implementing the recently added feature of Real-Time Materialized Views. 

    From Oracle Database release 12.2 and up, not only can queries be transparently re-written to address the views (that isn’t new at all) but if the view is stale changes in the materialized view logs can be transparently merged into the result set, thus giving real-time results without the overheads of FAST (or even ON COMMIT) refresh. However, configuring this is not necessarily straight forward. We’ll demonstrate the problems, and how to fix them.

     

    Prerequisite Knowledge

    Oracle Database Administrators or anyone with:

    • A solid understanding of Data Warehouse and Online Transaction Processing (OLTP) concepts
    • Some experience with Materialized Views
    • Some Oracle tuning experience such as interpreting Execution Plans. A free tutorial on Reading Oracle Execution Plans, great as an introduction OR a refresher, can be found here.

    Presenters 

    John Watson, Oracle Certified Master DBA, SkillBuilders Director of All Things Oracle Database

    Dave Anderson, SkillBuilders’ Founder, Oracle DBA

    Recording

    Barring any technical glitches, all webinars are recorded and posted as tutorials. See all tutorials HERE

    Registration 

    By registering for the webinar, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time. An extra-special event!

     

    + Google Calendar+ iCal Export

    Details

    Date:
    January 19
    Time:
    1:00 pm - 2:00 pm UTC
    Website:
    https://register.gotowebinar.com/register/2273279185130632972
    • « Oracle Database Logon: Let’s Count (and Learn) The Ways – A Free Webinar
    • Oracle APEX 20.2 New Feature & Practical Applications – A Free Webinar »

    All dates are in Eastern Time (ET).

    Upcoming Training

    Backup and Recovery with Oracle RMAN

    January 25, 2021
    $2,700.00

    Oracle PL/SQL Programming Workshop

    January 25, 2021
    $2,700.00

    Intermediate Oracle Application Express (APEX) Training

    January 25, 2021
    $2,700.00

    Oracle Database: Managing Multitenant Architecture

    February 1, 2021
    $2,100.00

    Upcoming Webinars

    There are no upcoming events at this time.

    Copyright © Skillbuilders.com

    Interested in joining our team?

    View details
    Managed APEX Hosting on AWS

    Sorry. This form is no longer accepting new submissions.