Utah Oracle Users Group
 

Events

 

Upcoming events

    • 30 Aug 2017
    • 8:00 AM - 12:00 PM
    • Intermountain Medical Center - Doty Education Center, 5131 Cottonwood Street, Murray, Utah
    • 9

    Reminder: You must sign up for each Deep Dives session that you want to attend separately. See the utoug.org/Deep-Dives for a link to each session registration.


    Session Title: Tuning Oracle Using Advanced Active Session History (ASH) Strategies

    Presenter: Craig Shallahamer

    Organization: OraPub

    Session Date: August 30th

    Session Time: 8am - 12pm - Lunch will be served at noon


    Session Abstract:

    There is a better way to solve your most difficult Oracle performance problems. Some performance issues are literally impossible to solve using an AWR Report or Oracle's time model. ASH comes to the rescue!

    Even DBAs who are familiar with ASH have a difficult time using ASH to directly answer key management issues surrounding a performance incident. Craig will teach you how to weave your ASH analysis into a compelling "who done it" mystery complete with good guys, bad guys, motive and even the weapon!


    You will be able to:

    - Understand the benefits of both time-based analysis and an ASH sample-based analysis

    - Pinpoint when an incident began, when it ended, who was involved and what they were doing

    - Jumpstart your analysis using OraPub's free BloodHound and Scratchpad ASH tool kits

    - Create a chart to visualize an incident at a point-in-time

    - Develop an incident time-line to explain the mystery

    - Watch and listen to Craig as he demonstrates the analysis process multiple times


    Class Outline

    Session 1. When to use and how to use ASH

    Session 2. Incident analysis mastery

    Session 3. Visualizing an incident with ASH and R


    Student Requirements

    As this is a hands-on seminar, the best case is students can connect to one of their very active Oracle systems. If a remote system is not available, a local database must be available on the students laptop. Craig will provide scripts to create "interesting" loads so the ASH analysis can occur. Also, to download, install and use R an internet connection is required.


    The analysis scripts will not impact a production system in any way; no DDL, no DML or heavy SELECTS.


    Speaker Bio:

    Craig is a long time Oracle DBA who specializes in Oracle tuning and started the OraPub website in 1995. Craig is a performance researcher and blogger, consultant, author of two books, an enthusiastic conference speaker and a passionate teacher to thousands of Oracle professionals. He clearly pushes the teaching envelope with his video seminars and webinars! Craig has received a number of technical, effectiveness and community involvement awards. Craig is also an Oracle ACE Director.


    • 30 Aug 2017
    • 12:45 PM - 2:45 PM
    • Intermountain Medical Center - Doty Education Center, 5131 Cottonwood Street, Murray, Utah
    • 25

    Reminder: You must sign up for each Deep Dives session that you want to attend separately. See the utoug.org/Deep-Dives for a link to each session registration.


    Session Title: Trace File Analyzer (TFA) Suite Deep Dive and New Features

    Presenter: Sean Scott

    Organization: Vitalize

    Session Date: August 30th

    Session Time: 12:45pm - 2:45pm - Lunch will be served at noon


    Session Abstract:

    Oracle's Trace File Analyzer is a robust suite of tools capable of capturing incident diagnostics and database and operating system metrics, identifying system changes and providing analysis of logs to improve troubleshooting and event resolution. It's lightweight, cluster aware and suitable for standalone and RAC databases and engineered systems. Originally designed to supplement log and data collection when creating service requests, TFA has become the preferred tool for collecting files and diagnostics for troubleshooting issues with Oracle Support on Unix and Linux platforms and in mid-2017 added support for Windows systems. The latest version, 12.2.1.1.1, is a milestone release that includes new data collection options, notifications, new cluster and log management features and a new menu-driven interface.


    Service requests created via TFA are resolved more quickly and now database administrators working on all major platforms can take advantage of TFA's Service Request Diagnostic Collection (SRDC) to automate and expedite the SR process with Oracle Support Services.


    Following a brief introduction to TFA and its use cases this session will discuss installation, upgrade, configuration and customization of TFA, an overview of the command set and new menu options, then dive into demonstrations of:

    * The core diagnostic collection (SRDC) features of TFA, from basic to advanced.

    * TFA 12.2.1.1.1 new features including the SUMMARY command, log management, incident reporting and the new SRDC options for collecting diagnostics for upgrades and patching.

    * Managing the TFA repository.

    * Performing full lifecycle health checks within TFA.

    * Configuring and using Remote Diagnostic Agent (RDA) integrations within TFA.

    * Supplemental tools for analysis, discovery and troubleshooting databases, clusters and environments—ORATOP, OSWATCHER and PROCWATCHER.

    * Redacting sensitive data within TFA.

    * Using the SQL Test Case Builder to aid Oracle Support during investigation of database and performance issues.


    Speaker Bio:

    Sean has been working with Oracle technologies for over 25 years, spending the last 22 as a database administrator and engineer specializing in database design, performance optimization, disaster recovery, high availability and development. He's an active contributor in the Oracle community, holding leadership roles at the user group level, participating in SIGs and as an author and presenter for regional user groups, IOUG/Collaborate, Oracle Open World and OAUG. His interests include developing tools, integrations and automation to improve and streamline database administration workflow.


    Note: 

    After this beginning session, there will be an advanced session. If you already have experience with TFA, we encourage you to come for the second half starting at 3 pm (separate registration).

    • 30 Aug 2017
    • 3:00 PM - 5:00 PM
    • Intermountain Medical Center - Doty Education Center, 5131 Cottonwood Street, Murray, Utah
    • 36

    Reminder: You must sign up for each Deep Dives session that you want to attend separately. See the utoug.org/Deep-Dives for a link to each session registration.


    Session Title: Trace File Analyzer (TFA) Suite Deep Dive and New Features

    Presenter: Sean Scott

    Organization: Vitalize

    Session Date: August 30th

    Session Time: 3:00pm - 5:00pm 


    Session Abstract:

    Oracle's Trace File Analyzer is a robust suite of tools capable of capturing incident diagnostics and database and operating system metrics, identifying system changes and providing analysis of logs to improve troubleshooting and event resolution. It's lightweight, cluster aware and suitable for standalone and RAC databases and engineered systems. Originally designed to supplement log and data collection when creating service requests, TFA has become the preferred tool for collecting files and diagnostics for troubleshooting issues with Oracle Support on Unix and Linux platforms and in mid-2017 added support for Windows systems. The latest version, 12.2.1.1.1, is a milestone release that includes new data collection options, notifications, new cluster and log management features and a new menu-driven interface.


    Service requests created via TFA are resolved more quickly and now database administrators working on all major platforms can take advantage of TFA's Service Request Diagnostic Collection (SRDC) to automate and expedite the SR process with Oracle Support Services.


    Following a brief introduction to TFA and its use cases this session will discuss installation, upgrade, configuration and customization of TFA, an overview of the command set and new menu options, then dive into demonstrations of:

    * The core diagnostic collection (SRDC) features of TFA, from basic to advanced.

    * TFA 12.2.1.1.1 new features including the SUMMARY command, log management, incident reporting and the new SRDC options for collecting diagnostics for upgrades and patching.

    * Managing the TFA repository.

    * Performing full lifecycle health checks within TFA.

    * Configuring and using Remote Diagnostic Agent (RDA) integrations within TFA.

    * Supplemental tools for analysis, discovery and troubleshooting databases, clusters and environments—ORATOP, OSWATCHER and PROCWATCHER.

    * Redacting sensitive data within TFA.

    * Using the SQL Test Case Builder to aid Oracle Support during investigation of database and performance issues.


    Speaker Bio:

    Sean has been working with Oracle technologies for over 25 years, spending the last 22 as a database administrator and engineer specializing in database design, performance optimization, disaster recovery, high availability and development. He's an active contributor in the Oracle community, holding leadership roles at the user group level, participating in SIGs and as an author and presenter for regional user groups, IOUG/Collaborate, Oracle Open World and OAUG. His interests include developing tools, integrations and automation to improve and streamline database administration workflow.


    Note: 

    This registration is for the Advanced session. If you are not familiar with TFA yet, we encourage you to also register for the first TFA session at 12:45 pm.

    • 31 Aug 2017
    • 8:00 AM - 12:00 PM
    • Intermountain Medical Center - Doty Education Center, 5131 Cottonwood Street, Murray, Utah
    • 38

    Reminder: You must sign up for each Deep Dives session that you want to attend separately. See the utoug.org/Deep-Dives for a link to each session registration.


    Session Title: APEX Security Deep Dive

    Presenter: Scott Spendolini

    Organization: Sumner Technologies, LLC

    Session Date: August 31st

    Session Time: 8am - 12pm - Lunch will be served at noon


    Session Abstract:

    This session will cover all facets of APEX security - instance & application settings, data access and tamper proofing. It will highlight some best practices to use for developing a secure APEX applications. It also incorporates the open source tool, APEX-SERT and illustrates how it can be used to automatically evaluate your APEX applications for potential security vulnerabilities.


    Speaker Bio:

    Scott Spendolini is president & founder at Sumner Technologies, a world-class Oracle® services, education & solutions firm. Throughout his professional career, he has assisted various clients with their Oracle APEX development and training needs. Spendolini is a long-time and regular presenter at many Oracle-related conferences, including Oracle OpenWorld, KScope, and RMOUG. His presentation at KScope 2014 - APEX Security Primer - was selected as one of the top presentations at the conference. He is a recipient of the Oracle Ace Director designation, author of Expert Oracle Application Express Security and co-author of Pro Oracle Application Express. Spendolini is also an Oracle Certified Oracle Application Express developer.

    Prior to reigniting Sumner Technologies in 2015, Spendolini was an APEX Practice director at Accenture and Enkitec from June 2012 through April 2015. Before joining Enkitec as part of an acquisition, he co-founded and ran Sumneva and Sumner Technologies from 2005 through 2012, which focused on Oracle APEX services, education & solutions. Spendolini started his professional career at Oracle Corporation, where he worked with Oracle eBusiness Suite for almost seven years and was a Senior Product Manager for Oracle APEX for just over three years. He holds a dual bachelors degree from Syracuse University in Management Information Systems and Telecommunications Management and currently resides in Ashburn, Virginia with his wife and two children.




    • 31 Aug 2017
    • 12:45 PM - 5:00 PM
    • Intermountain Medical Center - Doty Education Center, 5131 Cottonwood Street, Murray, Utah
    • 13

    Reminder: You must sign up for each Deep Dives session that you want to attend separately. See the utoug.org/Deep-Dives for a link to each session registration.


    Session Title: 12c New Features for Developers

    Presenter: John King

    Organization: King Training Resources

    Session Date: August 31st

    Session Time: 12:45pm - 5pm - Lunch will be served at noon


    Session Abstract: 

    Attendees are introduced to new and improved features of Oracle 12c directly impacting application development. Special emphasis is given to features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: IDENTITY columns, improved SEQUENCEs, INVISIBLE columns, improved defaults, JSON enablement, APPROX_COUNT_DISTINCT function, security enhancements, PL/SQL interoperability improvements, outer-join improvements, other SQL improvements, and Edition Based Redefinition (EBR) improvements. An overview of Oracle 12c Multitenant Features (“Pluggable” databases; CDB &PDB) and In-memory Database are included. Several exciting new 12.2 features will be demonstrated too. Attendees who bring internet-connected laptops may choose to participate in several hand-on labs during the session.



    Speaker Bio:

    John Jay King is partner in King Training Resources tailoring and conducting training to developers in many industries (www.kingtraining.com). John customizes and presents courses in various topics including Oracle, Java, JavaScript, IoT, Web Services, User Experience (UX), SQL, PL/SQL, APEX, MAF, and ADF. John is an Oracle ACE Director and a member of the Oak Table Network who presents frequently at conferences worldwide including Oracle Open World, and Rocky Mountain Oracle Users Group.



Past events

02 Aug 2017 UTOUG SIG Chair Training
26 Apr 2017 APEX SIG - Show, Tell and Ask
05 Apr 2017 Oracle DBA SIG - Collaborate
17 Mar 2017 PeopleSoft SIG: FLUID
13 Mar 2017 Training Days 2017
13 Mar 2017 Training Days Sponsorship
12 Mar 2017 Ski Day 2017
23 Feb 2017 Dev SIG - Regular Expressions in Oracle
08 Dec 2016 MySQL Workshop - Hosted by Oracle
29 Oct 2016 U Let Girls Code
26 Oct 2016 Fall Symposium 2016
30 Sep 2016 PeopleSoft SIG: Oracle OpenWorld 2016
27 Sep 2016 BI SIG Data Visualization Cook-off
24 Aug 2016 APEX SIG: Implementing Drag & Drop in your APEX applications
17 Aug 2016 Oracle DBA SIG Lunch & Learn - Oracle 12cR2
04 Aug 2016 Oracle Dev SIG Lunch & Learn
29 Jun 2016 UTOUG SIG Chair Training
22 Jun 2016 APEX SIG: That's not an APEX report!
28 Apr 2016 Mission Possible: ZeroIMPACT Oracle Migrations
31 Mar 2016 Ski Day 2016 - Snowbird
29 Mar 2016 Training Days 2016
28 Mar 2016 Training Days Pre-Conference Day - Practical SQL Tuning
11 Mar 2016 For High Schoolers: SheTech Explorer Day
24 Feb 2016 APEX SIG - Lunch and Learn
26 Jan 2016 BIWA Summit
14 Jan 2016 Go Faster: Make Oracle Work For You
13 Jan 2016 Oracle DBA SIG Lunch & Learn
03 Dec 2015 Oracle Dev SIG Lunch & Learn
11 Nov 2015 APEX SIG: Tips and Tricks!
14 Oct 2015 MySQL Security, High Availability, and Scalability
23 Sep 2015 Fall Symposium 2015
28 Aug 2015 PeopleSoft SIG: Upgrades
27 Aug 2015 APEX SIG: Dynamic (Dynamite) Applications!
22 Jun 2015 Oracle Development SIG Lunch & Learn
18 Jun 2015 BI SIG Lunch and Learn
24 Apr 2015 BI SIG Lunch and Learn
13 Mar 2015 UTOUG Ski Day 2015 sponsored by Pythian
11 Mar 2015 Training Days 2015
04 Feb 2015 BI SIG: Oracle BI Strategy
03 Feb 2015 Peoplesoft SIG
20 Nov 2014 MySQL Performance, Scalability and High-Availability
04 Nov 2014 Fall Symposium 2014
04 Nov 2014 New Member Orientation
03 Nov 2014 Fall Symposium Pre-Conference Hands-On Workshop - From Relational to Hadoop
23 Oct 2014 Oracle Hands-On BI Workshop
07 Oct 2014 BI SIG October Meeting
06 Oct 2014 Utah Tech Week
27 Aug 2014 Developer SIG: Understanding Your Processes Through Operation Intelligence
13 Aug 2014 ADF Mobile Development Best Practices (Case Study)
12 Aug 2014 Oracle Database 12c Security Workshop
22 Jul 2014 Oracle Big Data Workshop
10 Jun 2014 Oracle Webcast: Oracle Database In-Memory
08 May 2014 Developer SIG: Mastering PL/SQL Programming: Standards, Exceptions, Logging and Debugging
29 Apr 2014 BI SIG: Visualization
22 Apr 2014 Oracle Data Management Summit
14 Mar 2014 UTOUG Ski Day 2014
12 Mar 2014 Training Days 2014
26 Feb 2014 Women in Tech Initiative Kickoff
29 Jan 2014 DBA SIG: When a database grows too big to be backed up the old way - 1/29/14
29 Jan 2014 APEX SIG: Custom Theming APEX Applications - 1/29/14
20 Jan 2014 BI SIG Oracle SQL Developer Data Modeler
12 Dec 2013 Webinar: Effectively Managing Your Career In The Current Job Market
10 Dec 2013 Hour of Code for K-12 students
10 Dec 2013 Developer & BI SIG: Data Compression in a Data Warehouse Environment
10 Dec 2013 Oracle Innovation Forum Denver
29 Oct 2013 Fall Symposium
17 Oct 2013 Training Days 2014: Call for Papers Now Open
21 May 2013 DBA SIG: Indexing Strategies - 5/21/13
15 Apr 2013 Developer SIG: Accessing Web Services From Oracle
24 Mar 2013 Oracle Apps SIG - Webinar
15 Mar 2013 UTOUG Ski Day 2013
13 Mar 2013 Training Days 2013
15 Jan 2013 Virtual Sysadmin Day: Oracle Solaris, Oracle Linux, and Oracle VM
09 Jan 2013 BIWA Summit
12 Dec 2012 Your Vision, Engineered Oracle Day
08 Nov 2012 Developer SIG - Oracle SQL Data Modeler - 11/08/12
30 Oct 2012 DBA SIG: OpenWorld 2012 Report and Database 12c Features for DBAs - 10/30/12
17 Oct 2012 Business Intelligence SIG - Dimensional Modeling
06 Sep 2012 Fall Symposium 2012
06 Sep 2012 Sponsorship Opportunities for UTOUG's Fall Symposium
29 Aug 2012 DBA SIG: Advanced Recovery - 8/29/12
22 Aug 2012 Oracle Big Data Analytics Summit
07 Aug 2012 Business Intelligence SIG & OBIEE Breakout Session
20 Jun 2012 Call for Presentations for Fall Symposium Extended through Friday, June 22, 2012
13 Jun 2012 Developer SIG: JDeveloper Introduction, Tips and Best Practices 6/13/12
10 May 2012 Oracle Enterprise Data at Risk Seminar
02 May 2012 DBA SIG: Optimizing, Tuning and Troubleshooting SQL 5/2/12
22 Apr 2012 COLLABORATE 12- IOUG Forum / IOUG Virtual Conference
12 Apr 2012 APEX SIG: “Little Known Gems of Apex” April 2012
08 Mar 2012 Ski Day 2012
06 Mar 2012 Training Days 2012
06 Mar 2012 Training Days 2012 for Students
14 Feb 2012 DBA SIG: Using Oracle Internet Directory with LDAP - 02/14/12
13 Feb 2012 Road to Fusion - UT OAUG 2012 "Lunch and Learn" Apps SIG
18 Jan 2012 OTN Sys Admin Day – Oracle Solaris and Oracle Linux
30 Nov 2011 Apex SIG: Cool Apex apps
22 Nov 2011 DBA SIG: Oracle Enterprise Manager 11/22/11
18 Oct 2011 Oracle Business Analytics Summit
12 Oct 2011 Oracle Data Integration Breakfast Briefing
14 Sep 2011 Fall Symposium 2011
09 Aug 2011 Oracle Database 11g Upgrade Seminar
13 Jul 2011 Business Intelligence SIG
17 Jun 2011 DBA SIG: Troubleshooting Techniques
06 May 2011 Apex SIG - webinar only - Apex 4 new features
06 May 2011 Apex SIG - Apex 4 new features
03 May 2011 Virtual Developer Day: Rich Enterprise Applications
05 Apr 2011 OBIEE 11g & Business Intelligence Applications
30 Mar 2011 Training Days 2011
02 Mar 2011 Developer SIG: Oracle SOA
24 Feb 2011 BI SIG - Requirements Gathering
23 Feb 2011 DBA SIG: Performance Tuning
03 Feb 2011 Oracle Applications Customer Value Summit: Spotlight on Real World Customer Success
19 Nov 2010 DBA SIG - RAC
16 Nov 2010 BI SIG & BI Showcase
11 Nov 2010 APEX SIG: Reporting with BI Publisher and Open Source Platforms
01 Nov 2010 Developer SIG: Things Your Oracle DBA Should Have Told You
01 Nov 2010 Developer SIG - WEBINAR
13 Oct 2010 2010 Utah Oracle Users Group SIG Fest
09 Sep 2010 SQL Techniques by Tom Kyte
09 Sep 2010 Oracle 11g R2 Upgrade Forum
14 Jul 2010 DBA SIG: ASM
10 Jun 2010 BI SIG: Data Visualization - WEBINAR
10 Jun 2010 BI SIG: Data Visualization Presentation
05 May 2010 Training Days 2010
28 Apr 2010 Data Modeling SIG: The Data Modeling Scorecard
22 Apr 2010 APEX SIG (Webinar): Spreadsheet to Hierarchical Database
08 Apr 2010 Monthly Planning Meeting
01 Apr 2010 DBA SIG: The Database Replay Tool
25 Mar 2010 Developer SIG - Webinar
25 Mar 2010 Developer SIG - Webinar of Dynamic Debugging & PL/SQL Arrays
22 Feb 2010 Utah Regional BI User Group Meeting
22 Feb 2010 Utah Regional BI User Group Meeting *Webinar*
09 Feb 2010 Oracle Technology Network Developer Day
26 Jan 2010 Apex SIG Webinar - Template customization</b>
12 Jan 2010 Oracle Business Intelligence Symposium
07 Jan 2010 UTOUG Planning Meeting
10 Dec 2009 Oracle Apps SIG - Webinar @ TruTek w/Lunch
10 Nov 2009 Regional BI User Group Meeting
05 Nov 2009 UTOUG Monthly Meeting
29 Oct 2009 Oracle Fusion Middleware 11g Forum
21 Oct 2009 Apex SIG Meeting
20 Oct 2009 Oracle BI Training
02 Sep 2009 2009 UTOUG SIG Fest
16 Jul 2009 BI & Data Warehousing SIG
15 Jul 2009 APEX SIG Network & learn about Oracle's web development tool called Application Express (a.k.a. Apex)
02 Jul 2009 UTOUG Planning Meeting
11 Jun 2009 Oracle Grid Technology Day
08 May 2009 HR / Compensation Workbench
30 Apr 2009 Oracle ERP Release 12 Overview
30 Apr 2009 OBIEE Answers
23 Apr 2009 Oracle Business Intelligence: Lunch & Learn
22 Apr 2009 IT Summit Salt Lake City, UT 2009
16 Apr 2009 Business Intelligence SIG
12 Mar 2009 Training Days 2009
23 Feb 2009 General SIG
11 Dec 2008 Oracle Fusion Middleware Forum
28 Oct 2008 Fall Conference 2008
27 Oct 2008 IOUG University Seminar 2008
13 Mar 2008 Training Days 2008
19 Nov 2007 DBA Sig - Oracle Database 11g New Features
16 Oct 2007 Fall Conference 2007
15 Oct 2007 IOUG University Seminar
16 Aug 2007 Oracle Technology Day
28 Nov 2006 DBA SIG - 11/28/2006 Oracle 10g New Features
19 Sep 2006 Fall Conference 2006
21 Jun 2006 Oracle Application Express (HTMLDB)
02 May 2006 Oracle Developer Day
22 Mar 2006 Training Days 2006
08 Feb 2006 DBA SIG Luncheon with Tim Gorman
08 Feb 2006 Oracle Technology Day - Salt Lake City, UT
11 Oct 2005 Vendor Show and User Conference 2005
16 Mar 2005 Training Days 2005
16 Feb 2005 DBA Sig - February 16, 2005
26 Oct 2004 Vendor Show 2004
20 May 2004 Tools SIG 10G Application Server Extravaganza
16 Mar 2004 Training Days 2004
14 Oct 2003 Vendor Show and User Conference
17 Jul 2003 Application's SIG Luncheon
18 Mar 2003 Training Days 2003
© Utah Oracle Users Group (UTOUG)
Powered by Wild Apricot Membership Software