ODTUG Webinars

    Is there a topic you would like covered but do not see here? We are happy to take Webinar suggestions. E-mail us at

    Did you miss a Webinar? As an ODTUG Member you can hear all of our past Webinars at any time. Just log in and you will see the link for the recorded list. Not a Member? Join now for $99!

    Our Webinar Calendar is constantly evolving! Check back frequently as more Webinars will be added to the schedule.

    Suggest a Topic Archived Webinars

    Tuesday, July 29, 2014 12:00 PM - 1:00 PM EDT

    Outsourcing Hyperion Mission Critical Services: How it Works for CCC Information Services

    Doug McMahon, Key Performance Ideas

    Is outsourcing mission critical services a viable option? If you missed the session Outsourcing Hyperion Mission Critical Services: How it Works for CCC Information Services at Kscope14, register today and learn how CCC measured the costs and benefits of outsourcing its Oracle Hyperion Products v11.1.2. 

    Hear how the company is benefiting from reduced staffing exposure from PTO or turnover, and ensuring high availability of its applications while eliminating 'single point of failure' concerns with redundant account administrators.

    Register Here

    Thursday, August 7, 2014 12:00 PM - 1:00 PM EDT 

    Building Custom PDF Reports with Oracle Application Express
    Chaitanya Koratamaddi, Oracle Corporation 

    Oracle Application Express (APEX) provides several reporting options, allowing developers and users to quickly generate and view reports on data stored in the Oracle database. Users export their report data in PDF format, provided they have an external print-rendering engine configured with their APEX instance. With Oracle Application Express 4.2.2, the configuration has been simplified by building the PDF rendering functionality right into the APEX Listener. This session provides an overview of different printing options available in APEX and includes steps to configure APEX Listener as a print server. This session also includes how to create custom report layouts using third-party tools and then how to use these custom report layouts for PDF printing.

    Register Here

    Wednesday, August 13, 2014 11:00 AM - 12:00 PM EDT 

    How to Write PL/SQL Code You Can Actually Read
    Steven Feuerstein, Oracle Corporation
    *hosted by Oracle Corporation

    Software managers are very good at putting pressure on developers to "get the job done" as quickly as possible, so as to meet usually unrealistic deadlines. The end result? Software with way too many bugs in it and applications that require lots of resources simply to fix those bugs and maintain the code. If we are going to build and deploy successful applications, we have to think not only about getting that application in production today but also the cost of keeping it in production (and meeting user needs) for years to come. This session offers a range of tips and techniques to improve the readability of your code and make it easier to maintain/evolve that code over time. This webinar offers a wide-ranging set of techniques to make your code easy to understand and maintain over time. These techniques include: the use of subtypes and local modules; how to activate and check compliance with standards; and encapsulation (information hiding). After attending this webinar, you will be able to write code that minimizes the amount of development resources needed to maintain that code

    Register Here

    Tuesday, August 19, 2014 12:00 PM - 1:00 PM EDT

    Driver-Based Planning: When More Isn’t Better
    Paul Hoch, TopDown Consulting 

    When it comes to EPM planning, companies have traditionally taken a "more is better" approach regarding the level of detail included. Operating under the guiding principle that you can't manage what you can't measure has caused departments to get too mired in the details, leading to time-consuming planning cycles and a history of overspending. Tighter budgets and competition between departments for budget allocation have only exacerbated the inclusion of every possible line item in planning. Driver-based planning is a new approach to EPM planning and focuses only on the actionable drivers of the business, allowing the rest to "just happen." This allows employees to be more nimble, react to market conditions more quickly, and make decisions about factors that are truly under their control. In this session, attendees will learn how to implement a driver-based planning solution and gain executive support for this new way of planning. 

    Register Here

    Wednesday, September 17 2014 11:00 AM - 12:00 PM EDT

    Bulletproof Your PL/SQL Program Units
    Steven Feuerstein, Oracle Corporation
    *hosted by Oracle Corporation

    Consistent, robust error management is a critical feature of any successful application. Developers need to know all that is possible in PL/SQL regarding the raising, handling, and logging of errors, and that standardize the way in which those tasks are performed. This webinar goes beyond the basics of exception handling in PL/SQL to explore the wide range of specialized error management features in Oracle. We will cover FORALL's SAVE EXCEPTIONS, DML error logging with the DBMS_ERRLOG package, the AFTERSERVERERROR trigger, the DBMS_UTILITY.FORMAT_ERROR_BACKTRACE function, and more. In addition to covering error-related functionality, we'll also take a look at using assertion procedures to validate assumptions and execution tracing to better understand what is happening in your code. After attending this webinar, you will be able to take advantage of PL/SQL error management features, making it easier to identify the sources of problems and fix them more rapidly.

    Register Here

    Tuesday, October 7, 2014 12:00 PM - 1:00 PM EDT

    Calc Manager Rules with an ASO Cube: Yes, It Works!
    Ludovic De Paz and Paul Hoch, TopDown Consulting   

    You might have noticed that ASO applications are listed in Calc Manager, and this begs a number of questions:

    1. What can Calc Manager do for your ASO application?
    2. What can't Calc Manager do for your ASO application?
    3. What are the benefits of Calc Manager for an ASO database?
    4. What are the best practices for using Calc Manager with an Essbase cube?

    In this webinar, Paul Hoch, principal architect for TopDown Consulting, and Ludovic De Paz, senior consultant for TopDown Consulting, will answer these questions and more. The session will include real-life examples and case studies of successful implementations, as well as limits, gotchas, and workarounds.

    Register Here

    Thursday, October 16, 2014 11:00 AM - 12:00 PM EDT

    All About the Function Result Cache
    Steven Feuerstein, Oracle Corporation 

    The function result cache, added in Oracle Database 11g, offers developers a way to dramatically reduce the amount of time it takes to retrieve data requested repeatedly by database sessions (specifically, when the same rows of a table are fetched much more frequently than they are changed). This cache is stored in the SGA, shared across all sessions in the instance, and automatically purged of "dirty data" by the Oracle Database. Every application running on 11.1 or higher should be taking advantage of this feature. Best of all, there is minimal impact on your code to start using this feature.


    • When to use the result cache
    • RESULT_CACHE clause in function header
    • Result cache dependencies and granularity  

    Register Here

    Thursday, November 13, 2014 11:00 AM - 12:00 PM EST

    Turbocharge Your PL/SQL Code with Bulk Processing
    Steven Feuerstein, Oracle Corporation

    This session focuses on how to turbocharge the performance of multi-row SQL statements executed from within a PL/SQL using FORALL and BULK COLLECT. These features have been around since Oracle 8i, but many developers still don't use them or only scratch the surface of what is possible.
    The bulk processing webinar will focus on why these features were needed and how they work. Steven will start with simple examples and syntax and drill down into all nuances, including the LIMIT clause for BULK COLLECT and the SAVE EXCEPTIONS, INDICES OF, and VALUES OF clauses for FORALL.
    After attending this webinar, you will be able to both create new programs built around these features and also redesign existing programs safely to improve performance.


    • FORALL

    Register Here

    Thursday, December 11, 2014 11:00 AM - 12:00 PM EST

    Ten (Other) Top Tips for Improving PL/SQL Performance
    Steven Feuerstein, Oracle Corporation

    Bulk processing (FORALL and BULK COLLECT), along with the function result cache, are the "big ticket" items when it comes to performance optimization with PL/SQL. But there's still more we can do to tweak our code for even better response times for our users. This third webast in the series starts with the automatic compiler optimization, showcases the extraordinary speediness of PGA data manipulation (a.k.a., package variables), and demonstrates the effect of the simple NOCOPY hint. We finish up with an introduction to pipelined table functions and some thoughts on optimizing your algorithms.


    • PL/SQL optimizer
    • Package caching
    • NOCOPY hint
    • Pipelined table functions

    Register Here



    2520 Independence Blvd., Suite 201 | Wilmington, NC 28412 | Phone (855) 853-0491 | | Copyright © 2014