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.

DBLabs meetup, Sat 09-July: APEX hands-on labs

June 12, 2016 by · Comments Off on DBLabs meetup, Sat 09-July: APEX hands-on labs
Filed under: Educational Seminar, RMOUG & Regis University Labs MeetUp, Special Interest Groups 

What:    APEX Hands-on Labs

WhereRegis University, Northwest Denver campus

When:   Saturday, 09-July from 10:00am – 2:00pm MDT

How:     Register at http://www.meetup.com/RMOUGLabs/

Hands-on exercises using the APEX labs provided by Oracle.  This is the best way to learn Oracle Application Express (APEX) and add an eye-catching and useful new skill to your CV/resume.

Presented by Regis faculty and RMOUG board member Dr. Bob Mason, we will be using desktops within one of the Regis facilities, so either bring your laptop or use one of the desktops.  Bob will guide you through the exercises to help you become proficient in APEX.

Please register online HERE.

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.

Next Page »