May 2015 Quarterly Educational Workshop

April 25, 2015 by · Comments Off on May 2015 Quarterly Educational Workshop
Filed under: Uncategorized 

Rocky Mountain Oracle Users Group

ID Required May 15th, 2015
Quarterly Educational Workshop
And Annual Membership Meeting

Oracle Broomfield Campus
500 Eldorado Blvd
Building 1
Broomfield, CO 80021

Registration Required!
Please go HERE to register.
Question please e-mail Peggy at
Or call 303.929.6266

Sponsors: Dell Software, Solarwinds, Delphix
$15 visitor fee
For non members

8:00 am – 8:30 am Continental Breakfast
8:30 am 9:00 am Annual Membership Meeting and Board Elections
9:00 am – 10:00 am Relaxed Reporting – Tips & Tricks on Building Dynamic Financial Reports
, Joe Monteith
9:00 am – 10:00 am Introduction to Wait Types and Response Time Analysis, Rob Mandeville
10:00 am – 11:00 pm TOAD Tricks and Tips, Brad Wulf
10:00 am – 11:00 am SQL Developer Tips and Tricks, Jeff Smith
11:00 am – 12:00 pm Implementing Data as a Service with Virtual Data, Derek Zunker
11:00 pm – 12:00 pm
Oracle12 New Features with Release 2 Updates, Dan Hotka
12:00pm – 12: 30 pm Lunch

Annual Membership Meeting and Board Elections

8:30 am – 9:00

Notice of our Annual Membership Meeting with 2015-2016 Board of Directors election proxies have been mailed to all current members. If you are unable to attend the Annual Membership Meeting to cast your vote in person, please complete the mailed ballot and proxy. Proxies must be received by 5/13/2015 to be included in 2015 Board of Directors election results. Please return your completed proxy by fax to 480-718-7557 or use the return envelope is provided.


9:00 am – 10:00 am
Relaxed Reporting – Tips & Tricks on Building Dynamic Financial Reports

This session contains tips & tricks on building financial reports that use best practices to reduce closing cycles, improve transparency, expedite reporting, streamline compliance, and increase efficiency using Hyperion Financial Reporting (HFR). The session is designed around individuals who support the reporting and financial close process including CFOs, controllers, senior managers, financial analysts and systems administrators.

9:00 am – 10:00 am
Introduction to Wait Types and Response Time Analysis

Using Response Time Analysis and Wait Types is a newer method for tuning Oracle instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using Oracle Wait Type data coupled with Response time performance analysis to solve the most difficult performance related issues.

Rob Mandeville – Solarwinds

10:00 am – 11:00 am
TOAD Tricks and Tips

Abstract: Whether you’re new to Toad or a veteran user, Brad will show you tricks and tips to get even more from Toad’s time-saving functionality. You’ll also see firsthand how Toad 12.6 will make your job easier than ever.  In this session

  • Access the collective knowledge of the Toad community without leaving your work.
  • Get the most from Toad 12.6, no matter which platform you use.
  • Simplify business intelligence with Toad Data Point.
  • And much more.

Brad Wulf has held in numerous roles over the past 15 years within the Database world including Technical Support, Build Management, Development and Presales.  He is presently the Product Manager for Toad Extension for Eclipse, Toad for Mac, Toad for Hadoop, Toad for MySQL and SQL Navigator.

10:00 am – 11:00 am
SQL Developer Tips and Tricks

This session aims to arm every attendee with one or two new “tricks” that will dramatically save the amount of time it takes to accomplish daily tasks while working in Oracle Database with Oracle SQL Developer. Not only that, but they might learn how to have fun while doing it.

Whether you’re new to Oracle, new to the tool, or a veteran of both, the session can go as shallow or deep as the audience requires. Content includes topics that appeal to the technical analyst, business user, database administrator, and application architect/data modeler.

Jeff Smith is a senior principal product manager for Oracle, working on the SQL Developer team. His true passion lies in helping people maximize their productivity and retain sanity while working with database development and administration tools. You can get a pretty good idea of Jeff’s take on the current state of affairs in the world of Oracle and SQL Developer by reading his blog over at

11:00 am – 12:00 pm
Implementing Data as a Service with Virtual Data. How can Virtual Data help your organization respond more quickly to business demands?, Derek Zunker

The agenda will cover Delphix data virtualization solutions to deliver DBaaS and entire environments more quickly and securely then making copies or clones. We will present how the data virtualization engine works as well as how customers have applied it for a number of different use cases. If time permits Derek will also demo Delphix tool.

Derek Zunker is the Delphix territory manager for the Rocky Mountain Region. Delphix helps industry leaders like Walmart, Wells Fargo, Cisco, Facebook, and Pfizer deliver higher quality application projects in half the time. Our solutions virtualize, govern, and deliver data on demand. Delphix transforms the process and economics of application projects to drive innovation.

11:00 am – 12:00 pm
Oracle12 New Features with Release 2 Updates

This presentation is a must-see for anyone supporting applications! The presentation will be broken into 4 parts:

  • Pluggable Database
    • How it works
    • Support
    • Problems
  • New SQL Syntax
    • New Analytical SQL Features
    • New SQL Features
    • New Options for Sequences
    • Enhanced Join Syntax
    • Increased column size limits
  • New PL/SQL Syntax
    • PL/SQL and SQL
    • Enhanced DBMS_UTILITY
    • Enhanced DBMS_SQL
    • Enhanced Native SQL

Summary: Dan will cover quite a number of new features of the Oracle12 database that should be of value to developers and DBA’s

Dan Hotka is a Training Specialist and an Oracle ACE Director who has over 36 years in the computer industry, over 30 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and well over 200 published articles. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world.

Click here to access and download the presentation.

500 Eldorado Blvd
Show on Google Maps

Call for Nominations for the RMOUG Board Of Directors 2015-2016

April 10, 2015 by · Comments Off on Call for Nominations for the RMOUG Board Of Directors 2015-2016
Filed under: Uncategorized 

Call for Nominations for the RMOUG Board Of Directors 2015-2016


The Rocky Mountain Oracle Users Group continues to be the leading locally organized user group in the country. The success of RMOUG can be attributed to its members, the volunteers who support the activities of the users group, and the Board of Directors who provides direction for the users group.

The RMOUG bylaws require the regular election of the Board of Directors.

These bylaws (available online here) outline the makeup and duties of the Board of Directors:

  • The range of the number of the Directors shall be an odd number between five and fifteen
  • The management, control, and government of the Corporation (RMOUG) shall be vested in the Board of Directors
  • The Board of Directors shall preserve, protect, and promote the interests of the Corporation and will be responsible for formulating the general policy of the Corporation in accordance with the expressions of the members

Note: current general policies for the users group can be found online here.

We are calling for campaign statements for candidates for the fiscal year starting 01-June 2015 and running through 31-May 2016.

To run for the Board of Directors, you must:

  • Be able to participate in scheduled Board meetings (approximately 1 per month)
  • Be a member of RMOUG in good standing
  • Be willing and able to uphold the bylaws and policies of the organization

If you are interested in running for the Board of Directors, please prepare and submit a short campaign statement and biographical sketch. If you need some advice or help in this, please feel free to contact either Heidi Kuhn (executive director of RMOUG) or John Peterson (president of RMOUG). You should outline your reasons for running for the Board of Directors and your qualifications. If you are not a current member of the Board of Directors, you must list the event(s) or committee(s) on which you have participated and the name of a current Board member as a reference. Please limit your statement to approximately one page.

Campaign statements must be submitted no later than close of business on Thursday, April 30, 2015 by email to the current RMOUG President at If you have any questions about the process or would like to see a sample statement, please email

We look forward to working with you!

RMOUG Big Data Special Interest Group Meetup

March 31, 2015 by · Comments Off on RMOUG Big Data Special Interest Group Meetup
Filed under: Uncategorized 

First meeting of the Special Interest Group
Thursday, April 9, 2015
Regis University Denver Tech Center Campus
6380 S Fiddlers Green Cir
Room #274
Greenwood Village, CO 80111

Please RSVP here.

6:00 – 6:30 – Food / Socializing
6:30 – 6:45 – Announcements, Upcoming Events
6:45 – 7:30 – Presentation: An Overview of the Apache Hadoop Ecosystem
7:30 – 8:00 – Open discussion / Socializing


6:45 – 7:30
An Overview of the Apache Hadoop Ecosystem
Sean Mackrory, Software Engineer at Cloudera, and Apache Bigtop committer/PMC member

The era of Big Data has been enabled by a vibrant ecosystem of active open source communities. As great as this ecosystem is, it can be daunting for a newcomer to understand where each piece of the puzzle fits and understand the hype behind new projects. In this tour of the ecosystem, you’ll learn the basic concepts behind all the major pieces of the Hadoop ecosystem and see how they fit together to form an advanced data platform.

After 5 PM, there is free parking in the parking garage next to the building.  The garage is located on the left side of the DTC building. 

« Previous PageNext Page »