Click Here for Additional Information Time: 12:00 pm – 5:00 pm Note: You are not required to stay for every session Register: E-mail registration@neooug.org 11:30 am -12:20 pm - Lunch and Registration 12:20 pm -12:30 pm - Introductions 12:30 pm -1:30 pm - SQL Analytics and Modeling Fundamentals A Visual Demo Speaker : Gerhardt Martin, Snap-On Business Solutions If you are programming in SQL and you are not considering using Oracle analytic functions then you may be coding with one arm tied behind your back. Analytic functions, a feature introduced in the Oracle 8i database, provide the SQL programmer with a powerful set of tools to manipulate data. With this great power, though, comes some rather confusing syntax and semantics. In this presentation the fundamentals of Oracle analytic functions will be explained and the concepts will be illustrated in a manner that will help attendees visualize the semantics, gain a strong foundation of fundamental knowledge and develop the confidence to add Oracle analytical functions to their SQL arsenal. Gary Martin is a Kent State University graduate with a Bachelor of Science Degree in computer science. He is currently a Software Solutions Architect with Snap-on Business Solutions and past president of the Northeast Ohio Oracle Users Group. He has over 15 years of development experience with the Oracle Database and various other Oracle products. 1:40 pm -2:40 pm - To ANSI or Not To ANSI: a primer on ANSI SQL Joins Speaker : Rumpi Gravenstein, Snap-On Business Solutions Back in 2002 with the release of 9i, Oracle introduced support for ANSI SQL join syntax. Many Oracle professionals didn't see much need for this new feature and thought of it just as an attempt to stay compliant with RDBMS database standards. Further confounding the issue, the new syntax doesn't add critical new features. That type of thinking misses the point entirely. Oracle professionals take note: Writing ANSI compliant SQL improves code clarity thereby reducing errors. This presentation first reviews ANSI join syntax with detailed examples comparing and contrasting ANSI and “legacy” joins. It includes real-world examples of joins that should never have been written and discusses how best to use and not use the ANSI syntax. Finally, it will discuss why the additional clarity inherent in the ANSI syntax should make it a key element in your efforts to develop maintainable, error-free SQL statements. Rumpi Gravenstein is an Oracle ACE Associate who has been working with Oracle continuously since 1987, focusing on providing consulting services in the Oracle technologies. He has given numerous technical presentations at Oracle conferences covering topics such as security, application design, PL/SQL development, ANSI SQL, and data loading. Rumpi is currently working for Snap-on Business Solutions as a publishing architect. 2:50 pm -3:50 pm - Executing Explain Plans and Explaining Execution Plans Speaker : Craig Martin, Nationwide Financial This presentation provides an overview of DBMS_XPLAN.DISPLAY_CURSOR and a detailed walk-through of the output it produces. It will focus mainly on the execution plan section of the output and reveal how to properly make sense of it, a topic that even the Oracle documentation doesn't always get right. Craig Martin manages a team of Application DBAs which supports ~1500 databases at Nationwide in Columbus, OH. He has been working with Oracle since 2002, specializing in SQL and PL/SQL with a focus on performance improvement. Craig is a frequent presenter at Oracle user groups and conferences, including his favorite Oracle conferences, Great Lakes Oracle Conference and Hotsos Symposium. 4:00 pm - 5:00 pm - Optimizing RMAN Recovery Speaker : Pete Dinin, Sherwin-Williams The majority of RMAN performance discussions focuses on optimizing backup time, rather than restore and/or recover time. When using RMAN backups to restore service to your database, you want the RMAN restore/recovery to be as fast as possible (especially with a half dozen managers and directors anxiously waiting for the system to be available). This Optimization cannot be done during a crisis, but needs to be planned. This presentation reviews potential changes to RMAN backups that may reduce restore/recovery time and includes sample scripts so that the impact of these changes can be evaluated in your own environment. Pete Dinin is a Lead Database Administrator / Architect at Sherwin-Williams. He has been an Oracle DBA for 16 years (going back to Oracle 7) with experience in Oracle RAC/Grid Infrastructure, Oracle eBusiness Suite and Oracle Fusion Middleware technologies, as well as Exadata and Exalogic hardware. Pete is an officer for the Northeast Ohio Oracle Users Group (NEOOUG) and has presented at NEOOUG quarterly meetings and annual conferences, as well as Oracle OpenWorld.