Summer 2016 Quarterly Educational Workshop

July 8, 2016 by · Comments Off on Summer 2016 Quarterly Educational Workshop
Filed under: Uncategorized 

Summer Quarterly

Educational Workshop

Friday, July 29th, 2016


Join us Friday morning as Janis Griffin from SolarWinds and Jim Czuprynski from OnX Enterprise Solutions guide us through the performance realm of Oracle. After morning sessions enjoy a lunch in the picnic area before exploring the many worlds that live “Under the Sea” at the Downtown Aquarium Underwater Adventure.

Registration is required – Meeting/lunch fee is waived for RMOUG members. For non-members, family and guests the meeting/lunch fee is $20.00 adult / $10.00 child. Contact Peggy at with questions.

After lunch if you would like to visit the Aquarium we have Discounted Group tickets available for purchase at the box office. Prices are Adults $13.95, Children (3–11) $9.95, Children 2 and under are free. When buying tickets please let the agent know you are with the RMOUG Group to get the discount.

700 Water Street, Denver, CO 80211
Aquarium Hours: 10:00am – 9:30pm
Summer 2016 QEW Meeting Sponsors


8:00am – 8:30am – Registration Check-in
8:00am– 8:30am – Continental Breakfast – Sponsor OnX Enterprise Solutions
8:30am – 8:40am – Meeting Kickoff
8:45am – 9:45am“Analyze This! Practical Examples of Oracle Analytical Functions” – Jim Czuprynski, Onx Enterprise Solutions
9:50am – 10:50am“Migrating and Upgrading to Oracle Database 12c Quickly With Near-Zero Downtime”– Jim Czuprynski, OnX Enterprise Solutions
10:55am – 11:55am “Is Oracle 12c Making You Wait? Discover How to Identify, Prioritize and Solve the Most Important Wait Events” – Janis Griffin, SolarWinds
12:00am – 1:00pmOracle’s Adaptive Optimizer, Finally Learning from Its Mistakes!” – Janis Griffin, SolarWinds
1:00pm – 2:30pm – Picnic Lunch –  Sponsor SolarWinds


Questions — contact Peggy King by email at

Summer 2016 QEW Presentations:

8:45am – 9:45am “Analyze This! Practical Examples of Oracle Analytical Functions”

– Jim Czuprynski, Onx Enterprise Solutions

Session Abstract: If you’ve ever struggled with a particularly complex reporting request from an applications developer – for instance, returning just a specific set of rows from a subset of rows already extracted, or creating the equivalent of a Microsoft Excel pivot table, or producing a report with subtotals and subsections just like a spreadsheet – then this session is just right for you. We’ll demonstrate the basics of how to produce these complex output matrices with just a few calls to Oracle 12cR1 analytic functions and discuss how you applications developers (as well as Oracle DBAs) can leverage them for deeper insights into your database, and the performance of its application workloads. The presentation will offer real-world examples of how best to deploy these features, including detailed sample code that you can put to immediate use.

Objective #1: The attendee will understand how to leverage 12c Database’s analytic functions to create complex reports with less tortuous SQL, thereby potentially improving statement performance.

Objective #2: The attendee will discover how to apply analytic functions to obtain new viewpoints from the data hidden within the data, using everything from Big Data to database performance metrics as a target.

Click here to access the presentation.


9:50am – 10:50am“Migrating and Upgrading to Oracle Database 12c Quickly With Near-Zero Downtime”

– Jim Czuprynski, Onx Enterprise Solutions

Session Abstract: While many IT organizations appear to still be waiting for Oracle Database 12c Release 2 (12cR2) to migrate their pre-12c databases to the next version, it’s never too early to begin planning the best way to make that transition a reality. This session will therefore demonstrate real-world examples of how to use the latest database migration and upgrade techniques to quickly and safely move your pre-12c Oracle databases to Oracle 12cR1 … with some hints on even easier methods that are likely to be available in Oracle 12cR2.

Objective #1: The attendee will understand how to plan for an effective migration for pre-12c databases to a 12c database environment with minimum appropriate application down time – the “window of inopportunity” -while guaranteeing against the loss of any data during the migration process.

Objective #2: The attendee will be able to choose which migration mechanism – RMAN+TTS, XTTS, or CPT – is the best choice for migration her pre-12c database to Oracle Database 12c, and how to leverage each migration technique for an effective, safe migration regardless of differences between source and destination platform, database version, or OS.

Click here to access the presentation.


Jim Czuprynski – Strategic Solutions Architect, OnX Enterprise Solutions

Jim Czuprynski
Jim Czuprynski has over 30 years of professional experience in his career in information technology, serving diverse roles at several Fortune 1000 companies in those three before becoming an Oracle DBA in 2001. He was awarded the status of Oracle ACE Director in March 2014 and is a sought-after public speaker on Oracle Database technology features, presenting topics at Oracle OpenWorld, IOUG’s COLLABORATE, Hotsos Symposium, Oracle Technology Network ACE Tours, and Oracle User Group conferences around the world. As of August 2015 Jim has joined OnX Enterprise Solutions as their Strategic Solutions Architect focusing on Oracle Database technology, especially Oracle Database 12c as well as Oracle’s Enterprise Systems, especially Exadata, SPARC Supercluster, and Oracle Database Appliance, and ZS3/4. Jim has authored over 100 articles focused on facets of Oracle Database administration to his credit since 2003 at and Jim’s blog, Generally … It Depends (, contains his regular observations on all things Oracle. His first book, Oracle Database Upgrade, Migration and Transformation Tips & Techniques, was published in June 2015 through Oracle Press.


10:55am – 11:55am “Is Oracle 12c Making You Wait? Discover How to Identify, Prioritize and Solve the Most Important Wait Events– Janis Griffin, SolarWinds

Session Abstract: There are over 1200 wait events in Oracle 12c, but there are only 10 (in my experience) that are seen often. If you can learn these 10 wait events, what causes them and their solutions, you will be ahead of the performance analysis game. The list of 10 wait events to be discussed came from over 100 consulting engagements with customers, so come find out what they are and improve your performance troubleshooting skills.

Objective 1: Learn the top 10 wait events
Objective 2: What are the causes of these events
Objective 3: How do you fix these waits

Click here to access the presentation.

12:00am – 1:00pm – “Oracle’s Adaptive Optimizer, Finally Learning from Its Mistakes!”

– Janis Griffin, SolarWinds


Session Abstract: With each new release of Oracle, the optimizer undergoes changes usually for the better, but sometimes there are unexpected side effects as well. This presentation will explore all of the new optimizer features, adaptive plans/statistics, and the changes to SQL plan management. Several case studies will show how it works, so you can quickly take advantage of the changes while making sure you remain stable in the transition.

Does your performance tuning need a 12-step program?

Performance tuning can be complex. It’s often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, database performance evangelist, SolarWinds, will detail 12 steps to quickly identify performance issues and resolve them. Attendees at this session will learn how to:

  • Quickly fine tune a SQL statement
  • Identify performance inhibitors to help avoid future performance issues
  • Recognize and understand how new Oracle features can change and/or support different execution plans

Click here to access the presentation.

Janis Griffin – Database Performance Evangelist / Sr. DBA, SolarWinds

Janis GriffinJanis Griffin has over 25 years of Oracle DBA experience including design, development and implementation of many critical database applications. Before coming to SolarWinds, Janis held DBA positions primarily in the Telecom / Network Industries, working with both real-time network routing databases and OLTP business to business applications. As an Oracle ACE, Janis has mentored other DBAs on best practices in database performance tuning. As a highly successful liaison between management and technical staff, Janis has proven to be an effective collaborator implementing cutting-edge Oracle solutions.

Watch for Email from SurveyMonkey Containing Your Online Ballot to Vote for the 2016-2017 Board of Directors!

May 4, 2016 by · Comments Off on Watch for Email from SurveyMonkey Containing Your Online Ballot to Vote for the 2016-2017 Board of Directors!
Filed under: Uncategorized 

If you haven’t received the email already, then please check your “junk” folder, otherwise contact us ASAP?  Deadline for voting is Friday 06-May 2016 at 08:30am MDT.

Spring Quarterly Educational Workshop 2016

April 6, 2016 by · Comments Off on Spring Quarterly Educational Workshop 2016
Filed under: Uncategorized 

Spring Quarterly Educational Workshop
 Annual Membership Meeting
May 6, 2016

ID REQUIRED                                                                             $15 VISITOR FEE   FOR NON MEMBERS
Oracle Broomfield Campus
500 Eldorado Blvd
Building 1
Broomfield, CO 80021

Registration Required!
Register Now Button
Questions please e-mail Peggy at

Meeting Sponsored by Oracle Technology Network (OTN)

8:00 am – 8:30 am            Continental Breakfast

8:30 am – 9:00 am            Annual Membership Meeting 

9:00 am – 9:15 am             Oracle Technology Network (OTN)
9:15 am -12:00 pm            Oracle Application Express Tutorial
12:00 pm – 1:00 pm          Lunch – (Room A & Room B)


9:00 am – 9:15 am           
Introduction to Oracle Technology Network (OTN)
Laura Ramsey – Oracle OTN

9:15 am – 12:00 pm          
“Building a Demo Project Application’ Hands-On Lab Workshop”
David Peake – Oracle Application Express (APEX) Product Manager

This tutorial for Oracle® Application Express release 5.0 (Application Express) demonstrates how to build a working application for managing projects and tasks using some of the latest features of Application Express 5.0. This exercise assumes no prior knowledge of Application Express.

This lab can also be utilized for migrating your application development from one environment to another, such as from on-premise to the cloud.

Your team tracks projects you are currently working on. Rather than using a spreadsheet or some commercial project tracking tool you have been tasked with building a Web application so that the team has a custom application that meets everyone’s requirements. The DBA has created a script which creates various tables and populates them with the current data.

In this first workshop you quickly build a simple application that allows everyone to maintian the data. There is also a second “advanced” workshop where you greatly improve the application and utilize a number of advanced techniques to make a very polished application.

1. Please sign-up for a work space on prior to the session.
2. Download the lab zip file: (File available from


David PeakePresenter: David Peake, after 13 years within Oracle Consulting in Australia, New Zealand, and the United States, he joined the Product Development team as the Oracle Application Express (APEX) Product Manager.

Within consulting his primary focus was on large Custom Development projects. Four years ago he started working on a very large project, using APEX (or Project Marvel as it was called then). Before that he primarily developed applications using Oracle Forms and Designer.






Next Page »