The First Oracle Engineered System SIG Meeting

September 19, 2015 by · Comments Off on The First Oracle Engineered System SIG Meeting
Filed under: Uncategorized 

First Meeting of the Oracle Engineered System SIG
Regis University Denver Tech Center Campus
6380 S Fiddlers Green Cir
Room #290
Greenwood Village, CO 80111
October 8, 2015


16:00 – 16:30 – Socializing
16:30 – 17:30 – Presentation on Oracle Exadata Technical Deep Dive: Architecture and Internals by Tina Rose , Oracle Corporation .
17:30 – 18:00 – Open discussion / Socializing


About The Speaker
Tina Rose has been with Oracle for five years.  She was a founding member of the Exadata Support Team and assisted customers with a wide variety of technical issues.  In 2014, she transitioned to the development team: Platform Integration Maximum Availability and Architecture.  This team works on projects and issues related to Exadata and Exalogic hardware, operating system, security, and networking.  Tina’s focus is in storage/database patching, database clone patching and Oracle Database File System (DBFS).


Parking after 4 PM is free in the garage on the left side of the Regis University , DTC building.

Come Learn and Play QEW – August 7th at Elitch Gardens

June 23, 2015 by · Comments Off on Come Learn and Play QEW – August 7th at Elitch Gardens
Filed under: Uncategorized 

Rocky Mountain Oracle Users Group
Elitch Gardens Theme and Water Park

Quarterly Educational Workshop
Summer Edition

Elitch Gardens Theme and Water Park
2000 Elitch Circle Denver, CO 80204
August 7th, 2015
Lunch Served After the Event!

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


Come join us at Elitch Gardens on Friday, August 07, 2015, for a morning of technical seminars, and an afternoon of fun, courtesy of RMOUG and additional sponsors. Bring your colleagues, bring your family, bring your desire to learn, and reboot.

8:30 am – 10:00 Family Coding-  Fun with Raspberry Pi!

Have the family join you and learn why technology is so cool! Bring a Raspberry pi to Elitches on Aug. 7th for great family coding event. Children 6-14, along with parents can enjoy learning how to build an FM radio station and other fun projects. A list of supplies and project catalog, along with times and details will be posted to RMOUG’s website a month before the summer Quarterly education workshop.
Tentative schedule will include demonstrations from Devoxx4kids, Lady Coders and Kids DevelopIt, too!

Here is the list of the items needed for the Raspberry Pi session:

Shopping list for the Raspberry Pi Coding Day:

  1. Raspberry Pi, Any Model:
  2. And a Pibrella Board, $20
  3. Standard accessories:
    • Mouse
    • keyboard
    • HDMI monitor

Provided at the Coding camp:  wires, motors, connectors and “accessories” to create our moving art display!


After the park opens, RMOUG’s QEW Oracle track will offer the following Enterprise Manager sessions from Kellyn Pot’Vin-Gorman, the Conusulting Member of the Technical Staff, SCP Team:

Presenter: Kellyn Pot’Vin-Gorman

Kellyn Pot’Vin-Gorman is a member of the Oak Table Network and was an Oracle ACE Director until joining Oracle as the Consulting Member for the Strategic Customer Program, a specialized group of Enterprise Manager Specialists. Kellyn is known for her extensive work with Enterprise Manager 12c, its command line interface, environment optimization tuning, automation and architecture design. Her blog, and social media activity under her handle, DBAKevlar is well respected for her insight and content. She is the lead author on a number of technical books, hosts webinars for numerous technical groups, including All Things Oracle and has presented at Oracle Open World, HotSos, Collaborate, KSCOPE, along with other US and European conferences. Kellyn is a strong advocate for Women in Technology, (WIT) citing education on topics regarding stereotypes and presenting opportunities early as the path to overcoming challenges.

Hybrid Cloning- The Journey to the Cloud and Back

Going to the cloud can be a scary journey for any DBA, but find out how to do it securely, safely and simply with Enterprise Manager 12c, release 5, ( Kellyn Pot’Vin-Gorman will take you through the newest and coolest feature in EM12c that enables a single pane of glass connection between your company’s choice in cloud provider and on-premise environments, allowing for a secure ability to clone to and from the clone. Learn how to secure sensitive data from prying eyes and how to architect a private and public cloud that meets your company’s requirements.

10:45-12:00 AWR Warehouse Mining Hands on Lab
This session is a hands on session for those that would like to learn more about AWR Warehouse mining!  Learn how to answer those all important business questions for the business without having to guess or assume.  Learn the value of having historical Automatic Workload History in a single repository.  Kellyn Pot’Vin-Gorman will guide the attendee through each step of the process of learning how to build our consolidation roadmaps, look at host level resource usage and other uses. The attendee must provide their own laptop that meets the following requirements:

8Gb of memory
Oracle Virtualbox installed
50Gb of space to house the stand alone image
Fully charged battery

The attendee will learn about the following in this session:

The AWR Warehouse schema.
Necessary joins and how to properly query AWR data.
Base queries to begin investigation
User stories to build queries that the attendee will need to answer.

Join us at Elitches-  learn about database technology, family coding technology and then hit the rides and enjoy the day with your family and RMOUG!

12:00 Lunch

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

Next Page »