Meetup with Monty Widenius (MySQL/MariaDB founder)

November 7, 2016 by · Comments Off on Meetup with Monty Widenius (MySQL/MariaDB founder)
Filed under: Uncategorized 

Join us for a Fireside Chat with Monty Widenius, MySQL and MariaDB founder

One of the most important developers in Open Source will be in Colorado this month and is joining us for an evening to discuss the latest trends in databases and open source development.

Please join us for an in-depth conversation with Monty Widenius, a leader in open source development for more than 20 years, and a founder of open source projects MySQL and MariaDB.  This is an exciting chance to engage with a living legend in software development. Don’t miss this opportunity!

Monday, November 14

Innovation Lounge, Commons on Champa, 1245 Champa St, Denver CO (map)

  • 6:30 p.m. – Networking, snacks, drinks
  • 7:00 p.m. – Fireside chat with Monty

More details and RSVP at the Colorado MySQL Meetup event page.

BYOC – Bring Your Oracle Challenge

October 22, 2016 by · Comments Off on BYOC – Bring Your Oracle Challenge
Filed under: Educational meetup 

 

RSVP now at the RMOUG Meetup!

Bruz Beers

At Bruz Beers, 1675 W 67th Ave, Denver, CO (map)

Thursday, November 3, 2016, 5:30pm – 8:30pm MDT

Come share a beer and appetizers with the rest of your Oracle community, contribute and learn!

We’re doing this as a series of lightning talks — 10 mins to discuss whatever you thought was cool, and that you’d like to share!

In between each lightning talk, we’ll Q&A and share similar experiences.

First round of beer and appetizers is on RMOUG!

 

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 peggy.king@rmoug.org 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

Agenda

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 peggy.king@rmoug.org

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 databasejournal.com and ioug.org. Jim’s blog, Generally … It Depends (http://jimczuprynski.wordpress.com), 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.

Next Page »