Past Meeting Archives

Oregon and Southern Washington Oracle Users Group


Presentations and Hands-on Labs: Tuesday, November 12,  2019

Application Express APEX

Oracle Enterprise Low Code Application Platform *

November 12 and February 11 events will cover APEX**

* Gartner research reports:

    By 2024, low-code application development will be responsible for more than 65% of application development activity.

    By 2024, three-quarters of large enterprises will be using at least four low-code development tools for both IT application development and citizen development initiatives.


**    Here are some facts/benefits about APEX:

APEX has been in existence since 2004 and a is a leader in Low Code Development Platform

APEX Is a no cost feature of the Oracle database (both on-prem and Autonomous). This means that if you have an Oracle database, you already have APEX. NO additional licenses are required and no additional hardware/software is required other than a web browser.

APEX is enterprise ready and secure on day 1, and with Autonomous, APEX is easily scalable using ML and Oracle manages the DB for you with automatic patching.

APEX is easy to learn—individuals without any IT experience can build an app in minutes. You don’t need specialized skills to build apps. If you do happen to know some SQL and simple HTML, you can perform many customizations on APEX, but this is NOT required.

APEX comes with prepackaged productivity apps in the App Gallery, such as calendars, ticketing, and polling apps, which are ready to go in a few minutes.

Organizations use APEX to extend out commercial software to fill gaps, such as with EBS applications and HCM applications used by millions of users and page views.

Very large, well-recognized customers are using APEX within in their organization.

Bo English-Wiczling

Director (Product and Program Management), Oracle APEX

Bo English-Wiczling will provide detailed insights into the strategies and making of APEX applications.

APEX is designed for all levels of Technical experience including none at all.  She will follow an hour presentation with two hands-on labs.  One of the labs will cover data integrations around the corporate enterprise.  Her presentation and labs are designed to provide many good reasons to use APEX in any Oracle environment. 

In February, To advance our skills with APEX, OSWOUG and Oracle will again offer HOLs and lectures from other experts with more time and focus on solutions.  The presenter will be Marc Sewtz, also a globe traveling expert from Oracle.  Join both of these experts from Oracle with career changing, savoir-faire knowledge of APEX.

Meeting and Presentations: Thursday, September 12,  2019


Topics of Interest to Decision Makers, Architects, Developers and DBAs.

3 Experienced Approaches to

Designing and Developing Enterprise Data Solutions


                                                                        Dale MacDonald

Data Solutions Architect with 10 years of design, tuning and esoterica experience in Healthcare, Construction, Apparel.  I currently work for, the second largest renter on Amazon.


                                                                        Andy Weiss

Andy Weiss is the Oracle DBA for the PageWide Web Press Big Data team within HP Inc. (and a rising star at HP In

Fahd Saeed

Fahd Saeed is a data architect working on the Data Lake Initiative at Mentor, a Siemens company

Data Integration For Your Lake / Warehouse       by Fahd Saeed

    Tried and tested strategies for integrating data into your data lake / data warehouse. Learn about staging tables, incremental loads, and modified dates. Source side filtering can save you time and unnecessary computation. Real world examples of sourcing data from Oracle systems to cloud CRM systems using any modern ETL framework.

Using Hadoop to Supercharge Your Oracle Database   by Andy Weiss

    Using the right technology for the job at hand is critical to success in the ever evolving world of data. But these technologies do not exist in a vacuum. Just as critical is the ability to integrate different systems in a way that allows us to take advantage of their individual strengths. This talk will introduce you to Hadoop from the perspective of an Oracle DBA. We will take a look at how the two technologies naturally complement one another and how they can be combined to take your database to the next level.

Putting Your Data in the Right Bucket    by Dale MacDonald

    Transactional databases are the most commonly leveraged data storage systems in the modern development environment due in large part to their versatility.  However, there are an increasing number of data access patterns which strain individual capabilities of these systems and the application of transactional systems in these cases often leads to unnecessary spending and system instability.

    In this talk we will be examining the assumptions that are made by transactional databases as well as the use cases that those assumptions are intended to address in order to loosely define non-transactional data access patterns using several non-transactional use cases derived from case studies of production databases gathered in my time as a consulting

data engineer and architect with a special focus on simultaneously supporting standard business use cases alongside the needs of data scientists.  In addition we will be touching on how certain classes of cloud-based data systems can be used to manage the conflicting needs of these distinct user groups.

Meeting:  Tuesday,  May 14, 2019

Tammy Bednar

Oracle Senior Director

Cloud Products Program Manager

(See Penny Avril’s group for more info.)

The Modern Database Platform

Oracle Database 19c - A Deeper Look at How the Oracle Database Supports All of Your Workloads

Gurmeet Goindi

Gurmeet is currently The Product Manager for the Exadata

Database Machine, including all hardware and software. 

A Master Product Manager at Oracle Database’s Systems Technology org

Your Journey to Autonomous Database with Exadata and Oracle Database 19c

Oracle Exadata: Architecture and Internals Technical Deep Dive

Subquery Factoring by Jared Still

Presentation Details

The Modern Database Platform

Gartner says that “Information has replaced technology as the central and most critical asset to be managed by organizations. We now buy technology as a service in order to leverage data as that is where the value is.”   What does that mean to you today?  How can we work together to manage your most valuable assets - data and people - and become innovative and profitable? Please join me to discuss the modern database platform.

Your Journey to Autonomous Database with Exadata and Oracle Database 19c


The Oracle Exadata architecture is being transformed to provide the world's most advanced cloud and in-memory functionality for both online transaction processing and analytics with the introduction of smart storage, vector processing and Machine Learning. But how will this affect the way you operate your database? This session provides an overview of current and future Exadata capabilities,  and explains how these new capabilities can be seamlessly incorporated into new and existing data management systems to supercharge your database.

Oracle Database 19c - A Deeper Look at How the Oracle Database Supports All of Your Workloads


Oracle Database 19c is the last of the 12.2 database family and is therefore the ‘long term support’ release.  While focusing on long term stability, there are a number of enhancements and new features for our DBAs and Developers.  New features include Automatic Indexing, Active Standby DML Redirect, Hybrid Partitioned Tables, JSON enhancements, and many more.   Please join this session to learn about the agile releases of the Oracle database and how these latest features work.

Oracle Exadata: Architecture and Internals Technical Deep Dive


Take a plunge into the technical details of Exadata. This session describes what has been done to enhance Exadata and its integrated database architecture, and how to take maximum advantage of some of the new capabilities. This session examines in detail Exadata's hardware and software architecture, database extensions for Exadata, I/O resource management, Exadata’s Smart Scan and Smart Flash Cache features, as well as snapshot and virtualization capabilities.

Tuesday,  November 13, 2018

Andy Colvin

Accenture Enkitec Group

Exadata Engineer

Download the IOUG book  Expert Oracle Exadata by Martin Back, Karl Arao, Andy Colvin, Frit Hoogland, Kerry Osborne, Randy Johnson, and Tenel Poder.

Presentation Details

Getting the Most From Exadata With EXAchk

One of the most under appreciated benefits of running Oracle Exadata is that every system has a standardized software stack comprising Oracle Linux, Oracle Grid infrastructure, and Oracle Database. Keeping these systems humming with a multitude of database parameters and operating system settings can be a greater challenge than expected. The best tool for keeping this stack running according to Oracle’s best practices is the Oracle Exadata health check tool called Oracle EXAchk in Oracle Database. This session covers the ways that Oracle Exadata Database Machine administrators can take advantage of Oracle EXAchk to identify configuration issues, proactively schedule reports, analyze differences between runs, and keep up with Oracle’s recommendations even when they do not have root access.

5 Tips for Exadata Administrators New and Old

Taking in a new Exadata rack often becomes an exciting and scary event for many DBAs.  Oftentimes, they are left to fend for themselves as the sole administrators of these new machines.  How they handle this responsibility will very often determine the success of the implementation later on. This session will introduce several tips learned from over 100 Exadata implementations.  Topics include memory management basics, backup and recovery suggestions, and how to get the most out of exachk – Oracle’s engineered systems health check utility.

We met in November at :    Lloyd Center / Providence Meeting

Providence Lloyd Center, 3rd Floor

2201 Lloyd Center, Portland, OR 97232

Tuesday, September 18, 2018

Jared Still

Oak Table Network

Oracle ACE


ASM Internals

Carlos Sierra

Oracle ACE Director, emeritus


Slides:   Reducing Plan Flips

Reducing Plan Flips on 12c multi-tenant: a real-life case study

Reducing CPU spikes on 12c multi-tenant: real-life tips and shared tool

Carlos Sierra

Reducing Plan Flips on 12c multi-tenant: a real-life case study

For DBAs, a "plan flip" is when the Cost-based Optimizer (CBO) computes an Execution Plan that performs poorly, compared to prior plans. There are several reasons why plans flip. Mitigation is achieved addressing root cause, but sometimes that process is complex and lengthy. On this sessions we present how we can reduce the amount of plan flips, by enhancing SQL Plan Management (SPM) with a clever algorithm that learns about historical performance of your SQL before implementing a target SQL Plan Baseline (SPB). We also explain how to automate such algorithm to monitor and react to the effects of plan flips, or event to performance regressions while still using the same Execution Plan.

This session is for DBAs, Application Developers, and Managers, responsible for transaction-oriented applications (OLTP). It offers a better understanding of sudden changes on Execution Plans, and how we can prevent performance surprises associated to such changes. Its content is focused on 12c and higer versions of Oracle, but also applicable to 11g.

Jared Still

## ASM Internals - What you need to know

Oracle's ASM storage software is often viewed as a bit of a black box. Typically a DBA creates disk groups, adds tablespaces and disks as needed and forgets about it. Just as a DBA should know how the database works, the astute DBA should have a knowledge of how ASM really works.

A knowledgeable DBA should be able to explain how ASM replicates data, and how this is different than RAID technology. Failgroups are an integral part of ASM, so understanding how they work is critical to understanding ASM.  Allocation units, extents and more will be considered in a discussion of how ASM works.

Many DBA's leave all of the Hardware configuration to System Administrators.  As with DBA's, the quality of System Administrator's work and understanding of the systems vary with the individual.  Dedicated DBA's attending Collaborate 2018 will want to know some basic configuration items to verify before proceeding with ASM installations.  Among topics to be covered will be Disk Partitioning and Sector Alignment.

Troubleshooting and extreme recovery methods will be considered as well. If you do not already know the risks when the value of Usable_file_MB is a negative value, or how you may extract Oracle datafiles directly from ASM disks, then this presentation is for you.

Whether your databases are on premise or in the cloud, if you are using ASM you need to know how it works.

This presentation will show you how ASM works.

How does ASM storage work?  Is it RAID?

What is an Allocation Unit?

Are there utilities to help the DBA diagnose disk and disk group issues?

What is the difference between External and Normal Redundancy?

How do failgroups work?

How do I know which to use?

Should ASM Disks be partitioned?

What is sector alignment, and why should I care?

In the event of failure. can files be retrieved from ASM disks without using ASM?

Carlos Sierra

Reducing CPU spikes on 12c multi-tenant: real-life tips and shared tools

CPU spikes on a database usually trigger some alert, to which a DBA is expected to take some immediate action. A system that gets CPU oversubscription has an impact on latency and throughput, affecting all tenants. The challenge for a DBA in such cases is: determine what causes the CPU spike, then address the root cause. Sometimes the CPU consumption grows slowly over time, and sometimes quite fast. Common causes include "plan flips", repeating jobs, larger datasets, and on 12c multi-tenant, sudden increased load on a pluggable database (PDB) that may impact other tenants if not addressed.

On this session we present real-life tips on how to address common CPU spikes on 12c multi-tenant. We also share some free tools for DBAs to adapt and use. The target audience is: DBAs responsible of databases where SLAs on latency and throughput are critical. It is also educational for Developers and Managers that want to increase their understanding of the database.

Monday, May 7, 2018


HANDS-ON-LAB: Working in the Oracle Cloud

Oracle Cloud Licenses Provided

Instructions E-Mailed to all Registrants

Tuesday, May 8, 2018  


Viscosity North America and OSWOUG Present

Charles Kim

Author of 10 Books, Oracle ACE Director, multiple certifications and mastery, including  RAC expert, Exadata Implementation expert.

Co-Founder of Viscosity North America and many other top honors.

Richard Niemiec

Author of best seller “Oracle 12c Performance Tuning Tips and Techniques” which updates several best selling revisions from Oracle 8i .

Oracle Certified Master,  Oracle ACE Director and one of the earliest employees at Oracle.

Co-Founder of TUSC, previously President and Principal of ROLTA and many other top honors.

Fahd Saeed

Analyst and Architect for Data Integration and Modeling.  Fahd will present Oracle Data Integrator Enterprise Edition

Navigating within and around the Cloud.

Tuesday, February 13, 2018

   Maria Colgan

Master Product Manager at Oracle 

Clay Jackson

SharePlex Leading Technical Expert

Advanced DBA,  Quest Software

The Future of the DBA in a World of Autonomous Databases

Fahd Saeed

Red Pill Analytics

Data Visualization Desktop 12c

Analyze Storage and Performance using Data Visualization Desktop (DataViz)

Tuesday, September 12, 2017

Thanks to Liron, Jared, and Clay for outstanding presentations

Visit Liron Amitzi’s commentary summarizing the event

VIew presentation slides:

Presentation Code Examples coming soon

Basic Datatypes - Deep Understanding

Understanding Query Optimizer Complexity

Liron Amitzi

Senior Database Consultant & Oracle ACE

Founder of DBAces Canada

President of BCOUG

View presentation slides:

Pre-Meeting Revision:  Free-Oracle-Performance-tools

Download Final Meeting Version:

Jared Still

Oracle Oak Table

Oracle ACE

Clay Jackson

What to Consider When Moving Your Oracle Database to the Cloud

Presentation Details:

Free Oracle Performance Tools:  SLIDES   Free-Oracle-Performance-tools-IOUG.pdf

A look and occasional deep dive into the tools developed by leading authorities from around the world of Oracle technologists.  Time will be given for questions and answers

Dealing with the Optimizer Complexity 

The optimizer is one of the most complex components in Oracle. In this session we will talk about the optimizer from a slightly different perspective, its deterministic (and non-deterministic) behavior and how it affects performance. We will explore the recent features that change stability of plans and how, as DBAs of the new generation, we can handle it. The session will include real life examples, best practices, and tips and tricks that will make every DBA understand the new 11g and 12c optimizer features.

Basic Datatypes Deep Understanding - Truly understand Oracle Datatypes

It is well known that choosing the right datatype for columns is important. Every developer and DBA knows the basic datatypes and their meaning. This session will dive deeper into the different datatypes. What are variable size and fixed size datatypes? How much space does each datatype take? How are numbers represented? Which datatype is sorted faster? All of these questions and more will be answered in this session.

May 9-10, 2017

Biju Thomas

Oracle ACE Director, OCP and DB SQL Expert

OneNeck IT Solutions

Tue., May 9, 2017 in Portland, OR.

Wed., May 10, 2017 at Westlake Center, Seattle, WA.  not Bellevue

Speaker BIOs

   As of March 1, 2017, Oracle 12c Release 2 is available for download from OTN. Similar to R1, R2 comes with an array of cool features. We will review a bunch of changes in R2 that are of interest to DBA as well as Developers. It is common to think that you are not going to be using 12cR2 anytime soon then why to bother. Knowing better features that ease the workload and that protect the data better helps you to convince the business and management to get to a newer and fully supported release faster.

    Over the years Biju has seen many challenges and has been part of implementations and upgrades that resulted in better management options, better security, and better performance. Though specific reference is on EBS, the learning applies to any Oracle database.

Top Toad Tips for Boosting Database Performance

Quest Software

Toad for Oracle is famous for protecting database investments and empowering database professionals to automate processes, minimize risks and dramatically cut project timelines. But did you know more than 60% of users reported applications and queries running at least 30% faster, as a direct result of using Toad for Oracle?  During this session, Russ Tuttle, Senior Solutions Architect, will show you how to release the power of Toad to become more proactive toward database performance. You’ll see how simple it can be to automate several performance-enhancing functions, pinpoint areas of inefficiency, and solve your toughest performance challenges, in just minutes. With these tips from Russ, you will be able to shift the time you spend from administration and management to more strategic initiatives. Russ has experience as a DBA and Developer previously employed by Oracle.


Oracle Database 12c R2 Features for Administrators and Developers

Biju Thomas

As of March 1, 2017, Oracle 12c Release 2 is available for download from OTN. Similar to R1, R2 comes with an array of cool features. We will review a bunch of changes in R2 that are of interest to DBA as well as Developers. It is common to think that you are not going to be using 12cR2 anytime soon then why to bother. Knowing better features that ease the workload and that protect the data better helps you to convince the business and management to get to a newer and fully supported release faster.

-       SQL*Plus features (run fast flag, better batch & lob prefetching, etc.)

-       Partition enhancements

-       Materialized view enhancements

-       New in PDB management

-       Is adaptive query optimization still a problem?

-       Notable features missing in EE compared to EE on Exadata or Cloud

  1. -      And much more…

Learnings from my E-Business Suite Diary

Biju Thomas

Biju has been tuning and managing EBS instances since 2007. Over the years he has seen many challenges and has been part of implementations and upgrades that resulted in better management options, better security, and better performance. Though specific reference is on EBS, the learning applies to any Oracle database.

-       Challenges of MRP and ASCP in RAC instance

-       Why we chose Data Pump for DB11gR2/EBS11i/Solaris migration to DB12c/EBSr12/Linux

-       Implication of TEMP_UNDO_ENABLED parameter in 12c

-       Listener stack size & WF error – where is the value coming from?

-       And a few more interesting ones.

February 14, 2017

John King

Join Oracle Oak Table Member and Ace Director  John King,

as he deep dives into Oracle 12c for DBAs and Developers.

Oracle Database 12c New Features for Developers and DBAs

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 too.

Here's a little bio:

John Jay King is partner in King Training Resources tailoring and

conducting IT training since 1988 ( John customizes

and presents courses in various topics including Oracle, IoT, Web Services

(REST and/or SOAP), User Experience (UX), SQL, PL/SQL, APEX, MAF, and ADF

November 8-9, 2016

Jared Still                 
             Tim Gorman

Presentation Slides


There is a lot of talk about moving databases to the cloud.  This presentation is an introduction to the cloud; Specifically in this case the Amazon AWS cloud.

Attendees will learn how to get started with provisioning machines in the cloud, methods used to migrate data to the cloud, as well as how to scale  for capacity on demand.

Jared Still, Pythian Principal Consultant , Oracle Ace,  Oak Table


Three Types of Table Compression:  Tim Gorman  , Delphix Principal Consultant, Oracle Ace Director, Oak Table



1:30    Check-in, registration, networking


1:45        Event kickoff :  Tim Gorman   THREE TYPES OF COMPRESSION: This presentation will discuss all the different types of table data compression in Oracle database (i.e. basic/advanced de-duplication compression and hybrid-columnar compression), as well as some older often-forgotten techniques for fitting more data into less space.                              


2:45        Break/networking Refreshments


3:00        Tim Gorman : Table Compression , Part II


3:50          Break/networking



4:00          Jared Still :  Hey You:  Have You Moved To The Cloud.   The Oracle Cloud : For Business Decision Makers and Lead Implementors:  CAPEX examination through CLI use to create a Virtual Machine.  Hardware, Software, Network and Storage breakdown.


5:00          Wrap-up


10:30    Check-in, registration, networking


11:00        Event kickoff :  Tim Gorman   THREE TYPES OF COMPRESSION: This presentation will discuss all the different types of table data compression in Oracle database (i.e. basic/advanced de-duplication compression and hybrid-columnar compression), as well as some older often-forgotten techniques for fitting more data into less space.                              


12:00        Break/networking Lunch


12:30        Tim Gorman : Table Compression , Part II


1:30          Break/networking



1:45          Jared Still :  Hey You:  Have You Moved To The Cloud.   The Oracle Cloud : For Business Decision Makers and Lead Implementors:  CAPEX examination through CLI use to create a Virtual Machine.  Hardware, Software, Network and Storage breakdown.


2:45          Wrap-up

February 9-10, 2016

Information Security Symposium

Portland Registration:  NO FEE TO ATTEND

Bellevue Registration:  There is a small fee to attend.  Parking is validated compliments of TEK Systems.  Meeting at the TEK Systems offices.


10:30    Check-in, registration, networking
Continental breakfast, coffee, tea, water available


11:00        Event kickoff
Keynote: Francis D’Addario, Former VP, Partner and Asset Protection, Starbucks Coffee.  Current Emeritus Faculty Security Executive Council 

                    (in Bellevue 1st and 2nd speaker will be in reversed order.)



12:00        Lunch and networking


12:45        Speaker: Tom Atwood, Sr. Principal Product Marketing Director, Oracle

                    (in Bellevue 1st and 2nd speaker will be in reversed order.)


1:45          Break/networking

Coffee, tea, water available


2:00          Speaker: Marty Scholes, Marketing Solution Architect, F5 Networks


3:00          Wrap-up, raffle drawing and giveaways

With appreciation for TEKSystems and many years of flawless support.

PANAYA will be there to answer questions about your next UPGRADE.


Risk, Threat and Vulnerabilities              -  Francis D’Addario

Oracle’s Information Fortress                 -  Tom Atwood

SSL and the Hype: What’s Real?             -  Marty Scholes


Tuesday,  February 9, 2016

Portland location:  The Standard Insurance Center

900 SW 5th Avenue Portland, OR  97204

10:30 - 3:00  The current target is to provide free parking, This is tentative, not confirmed, yet.

The Lower Level Conference Center.

Wednesday,  February 10, 2016

Bellevue location:  The Puget Sound Energy Building

10885 NE 4th Street Bellevue, Washington  98004

10:30 - 3:00   Free parking in the garage below the building with validation.

ROOM 170 , First Floor ,   Near the Fireplace.

Institutional Security

Speaker:  Francis D’Addario

V.P. Emeritus Starbucks Security 

Emeritus Faculty, Security Executive Council

Considerations for Insider Risk Threat and Vulnerability Detection and Mitigation

Persistent Protection-in-depth from a Behavioral Point of View

Crime Prevention Through Environmental Design

Proven Practices featuring  ROI

Stolen Credentials Matrix demonstration based on attendee’s .com

Oracle’s Information Fortress

Speaker:  Tom Atwood

Senior Principal Product Director

Converged Systems, Oracle Corp.

Oracle recognizes the growing importance of data center security. The damage caused by a security breach can have serious impacts on affected organizations.  Oracle’s security strategy is to build a layered security defense, or Information Fortress, to protect networks, systems and, most importantly, your data.  This talk will outline Oracle’s security strategy and then talk in more detail about protecting data with Oracle Database and SPARC/Solaris servers.  

SSL and the Hype: What’s Real?

Speaker:  Marty Scholes

Marketing Solution Architect

F5 Networks, Inc.

SSL and the Hype: What's Real?

This presentation covers the hype surrounding SSL, drilling down to the real issues in today’s environments. Marty Scholes will cover topics such as SSL recommended practices which impact your Qualys grade, and even why you should care about your Qualys grade.


Tuesday, Nov. 10 and  Wednesday, Nov. 11, 2015

Location Tuesday:  The Standard Conference Center Lower Level

Times:  Start at 10:45 and will end around 1:45

Lunch Provided

Location Wednesday:  Puget Sound Energy Building, First Floor, see signs

Times:  Start at 4:45 and will end around 7:45

Parking Validated

Dinner Provided

Steve Larson and James Archuleta,  DATA!  

ENTERPRISE DATA QUALITY,  Master Data Hub, ODI,  Golden Gate and much more.

Extreme Performance,  Faster time to value.

The Cloud,  Oracle's Cloud Solutions, Focusing on the private cloud.  Leveraging your Hardware.

Renee Main,  Regional Saies Director

Tom Atwood,  Senior Principal Product Director

Oracle Systems Product Marketing Group


 As one Oracle exec put it: “The Cloud Changes Everything”. All IT vendors are increasing offering some type of either public cloud or private cloud offerings to meet the shift to cloud computing.  Hear about Oracle’s cloud strategy, both public and private cloud, from Tom Atwood. The emphasis will be on private cloud and IaaS (Infracture as a Service) but will include information about Oracle’s full cloud portfolio.

Oracle performance monitoring/diagnostics and introduce their new agentless Foglight for Oracle with Performance Investigator

Steve Yraceburn, Sales Manager,  Dell Performance Monitoring Solutions

Clay Jackson,  Technical Expert,  Dell Software

Dell Performance Solutions have lead the market , acquired from Quest,  for ages.  See how things have evolved and Dell has perfected their products . 

Dell Software to present on Oracle performance monitoring/diagnostics and introduce their new agentless Foglight for Oracle with Performance Investigator which provides:

·         The ability to resolve performance issues across Oracle and other platforms by determining your most critical problems and taking immediate action.

·         Adaptive baselines – Track performance using automatic detection and calculation of normal ranges for all metrics, and receive alerts about deviations from normal activity.

·         12c Multitenant architecture - Easily understand the health and activity of your Pluggable Databases

·         Powerful performance investigation – Optimize performance proactively with an analytics engine that collects and investigates data on baselines, lock analysis and change tracking.

·         Automated change tracking – Find out when changes to server, instance, database and schema environments occur, as well as application SQL degradations. Offers custom change alerts.

·         Statement-level wait-event analysis – View wait-event data down to the statement level to rapidly resolve resource-related performance problems.




Tuesday,  August 11 , 2015

Portland location:  The Standard Insurance Center

10:45 - 2:15  Topics:

Database Replication

Clay Jackson,  Dell Software


Database replication as an architectural strategy has moved into mainstream several years ago. Today, all the major players including IBM, Oracle and Dell offer high speed, log based, fault tolerant, asynchronous streaming replication solutions. This presentation will first cover the fundamentals of replication and then move quickly to specific implementation considerations for several use cases including disaster recovery, load isolation, auditing and more.


Clay Jackson has been working with Oracle since 1991 and participated in the Oracle 7 Beta Program.  He’s also been active in Oracle Customer Focus groups around Very Large Databases, and in IOUG.   He’s been working with database replication since the early 2000s.   After working at Microsoft, US West, Starbucks, WaMu, and Darigold, Clay joined Dell Software in 2012, focusing on Database Performance Management and Database Replication.

TOAD - New Features, Tips & Tricks for Agile Development

Mathew Phan,  Dell Software

Database development processes have always been a step or two behind the rest of the programming community. Your developer peers use agile development methodologies, so why can't you? In this session we'll discuss new features in Toad including static code analysis, automatic debugging, regression testing, and version control into your Oracle development workflow, allowing you to increase your code quality, efficiency, and collaboration with your team. We'll also cover the most popular Toad features to increase productivity.


Mathew Phan began his career as a technical support engineer for Toad for Oracle straight out of graduating the University of California, Irvine, where he obtained a bachelor's degree in computer and information science. He has devoted his entire 10 year career with the Toad family of database solutions and held various positions helping to shape the direction and growth of Toad. Now as a systems consultant, he continues to work with customers to build effective solutions that meet their needs and is a guest speaker at regional user groups and conferences.

Tuesday and Wednesday,  May 12-13, 2015

James Correll,  Oliver Wight Partner

Planning Data Quality

Planning Data Quality has been a major issue since MRP systems came into existence in the 1960s.  The problem has become even worse with the advancement in the capability of these systems and a large increase in the amount of data that is now used for analysis and decision making. 

Many companies have attempted to clean up the required data elements but have little or no success for extended periods of time.  Sustained data accuracy takes people to design a good processes, assistance from tools to do it efficiently and people to be understand how to follow the processes and use the tools properly.

This presentation is about how to develop efficient processes, how to use the tools and what disciplines are required to meet the high levels of accuracy that is required to run an MRP system.

Advanced Sales and Operating Planning, Successful Fast, & Collaborative

Many companies today profess to be operating Sales and Operations Planning (S&OP) to help them manage, their business.  Unfortunately most don’t get the benefits the process should deliver and some don’t get any.  Regardless of whether your company is not achieving the benefits or you simply don’t have the process, you are missing out on a huge competitive advantage.

This presentation will review how Sales and Operation Planning has advanced since its inception, what the benefits should be, what success is, how to implement quickly and the how to use it to collaborate throughout the supply chain.

Lynn Harig,  Global Disaster Senior Manager, Xerox

Enterprise Disaster Recovery Planning

Disasters can take many forms, from Natural Disasters such as Hurricanes, Tsunamis, Earthquakes to Man Made ones such as Human Errors, Power Grid Outages, and Fires.  Planning for such incidents can reduce the crisis, and minimize the impacts to the business and the IT staff.   At Xerox, we hope for the best and plan for the worst.  This presentation will describe how Xerox is transforming its’ Disaster Recovery Strategy for our critical applications and infrastructure services and how we ensure compliance to our DR policy.

Some of the questions answered include:

Why Xerox has a disaster recovery policy.

What are the layers or building blocks.

How the datacenter defined services to support the ITSC (IT Service Continuity) .

Transforming from a Hosted DR solution to a self-reliant DR solution.

Some time maybe spent on Oracle Dataguard for DB replication and Rsync (out of the box)

Critical benchmarks and ROI.


Tuesday,  August 12 in Portland

Wednesday, August 13 in Bellevue at La Residence Inn Hotel

CLAY JACKSON,   Managing the Enterprise,  Dell

    Monitoring of IT Systems has matured significantly in the past 20 years.    Today, IT infrastructure plays a mission critical role for almost every business, large or small.  Even short database or other IT outages can cost companies thousands, if not millions of dollars in lost revenue and reputation.  This presentation builds on a paper initially presented at the 1992 IOUW Conference, and will cover the fundamentals of performance monitoring,  include a survey of the various types of monitors available and the return on investment for these tools;  and conclude with several use cases for Foglight, Dell Software’s premier Enterprise Monitoring Suite.


May Meeting

BIG DATA - noSQL 3.0 just released

Join David Segleau, Oracle Big Data Technical Product Manager

  Sponsors  DELL, TEKSystems, and Oracle

Door prizes provided by Dell

PORTLAND Itinerary

10:45 Reception

11-11:55 am

NoSQL 3.0 Interesting and Useful New Features- Join David Segleau, Oracle Director of Big Data Development

Abstract: Oracle NoSQL Database 3.0 was released in April. Come learn about the exciting new features, including Tables, Secondary Indices, Data Centers and Security. Also hear about the latest use cases with concrete examples of how companies are using this technology to increase revenue and reduce costs.

12:00 Lunch - Join us for lunch provided by TEKSystems 


Title: "Beyond the Basics of Toad: New and Little Known Tips v12.5"

We find that most Toad users utilize only 20% of the product, when they could be getting so much more out of it. This session will introduce you to some of the most effective tips for getting the most out of your Toad investment. This developer focused session will show you how to boost productivity, significantly improve your organization's code quality, optimize SQL performance and reduce risks associated with database changes. Plus, we will give you unique insight into the newest Toad release.

1:15pm - 2:05pm

Topic:  "Data Integration with Toad Business Intelligence"

Learn how to reduce the cost and complexity of your business intelligence systems with Toad. After this session, you'll be able to quickly integrate data between disparate data sources such as traditional RDBMS and external sources like and Google Analytics. Alleviate the burden on IT by automatically publishing to virtual analytical data layers which can be consumed by business analysts and decision makers, as well as enable them with the tools to create and chart their own reports.

2:10pm - 3:00pm

Topic: "Simplified DB Administration with Toad"

During this session, you'll learn how to do more with less resources by getting to know the features in Toad which DBAs use most often to automate mundane tasks, quickly diagnose and troubleshoot issues, and load test their databases in order to meet service level agreements. We'll also compare and contrast features Toad for SQL Server and Toad for MySQL for those who support multiple platforms.


Bellevue Itinerary

Meeting will run from 4:30 to 6:30pm

We will be meeting at Oracle Offices in Bellevue. Talks will be abbreviated to allow people commute time and relaxation time at home after the meeting.  TEKSystems has sponsored the venue including food and drink.

The same talks (as Portland) will be presented in Bellevue.   The event may run longer and we will still cover all of the topics in the two hours officially allocated.  Door prizes will be awarded at 6:40pm.  Dell has donated a backpack and some nice handouts.

Tuesday,  February 18 PORTLAND

Wednesday, February 19 SEATTLE

Jared Still   (Portland only)

Topic: Recursive Subquery Factoring.  There will be new material not covered in the Book co-authored with Karen Morton, and other Oak Table’ists.  “Pro Oracle SQL” .   Lots of references to information like the differences between explain plan and execution plan.  Recursive Subquery Factoring is for anyone who works with hierarchical data.....that’s almost everyone in case you didn’t know!

Bill Brunt,  Dell Architect

Abstract:  Database replication as an architectural strategy has moved into mainstream several years ago. Today, all the major players including IBM, Oracle and Dell offer high speed, log based, fault tolerant, asynchronous streaming replication solutions. This presentation will first cover the fundamentals of replication and then quickly to specific implementation considerations for several use cases including disaster recovery, load isolation, auditing and more.

Roger Freixa Vidal,  Oracle Product Director, WebLogic, Cloud.

Portland only.  Was not available for Seattle.

WEBLOGIC:  The Best Choice For Oracle Database.

Abstract: Oracle WebLogic Server 12c provides flexibility between on-premise and third-party clouds, and it provides extreme cloud performance, scalability, and elasticity, and an unmatched integration with Oracle’s Database 12c including multi-tenant database support, Resident Connection Pools and Application Continuity, like no other app servers in the market. 

Mr. Freixa-Vidal is Senior Principal Product Manager on the Cloud Application Foundation team.  and joined Oracle through the acquisition of BEA Systems.

Martin Giffy D'Souza;  will talk about KSCOPE14 and..... (Bellevue only)

Title: Apex and HTML 5

Abstract: HTML 5 is the next major version for HTML. It consists of many new features which will make developer's jobs a lot easier and improve end-user experience. This presentation will highlight some of these new features and demonstrate how to leverage them within an APEX application. New features include (but not limited to) drag & drop, media, storage, and graphics.

Tuesday, November 19 SEATTLE

Wednesday, November 20 PORTLAND

Oracle Data Integrator and GoldenGate


Oracle in partnership with OSWOUG

Oracle Data Integration Solutions – Moving Data to Transform Business


In today’s competitive world business decisions need to use more relevant, timely data and act fast to create value for the enterprise. Business critical systems must offer the highest availability, ensure fast and easy access to the right data, and quickly adapt to the changing business and IT demands. Join us to learn how Oracle integration technologies can help you achieve pervasive continuous access to trusted data with high performance and low TCO.

Oracle Data Integration delivers non-intrusive real-time data integration, providing customers improved business insight, higher Online Transaction Processing (OLTP) performance, and 24x7, continuous data availability for mission-critical systems.

In partnership with the OSWOUG, Oracle is pleased to invite you to join us for an interactive workshop in a hands-on environment where you will hear best practices real-time operational and analytical data integration solutions, which help reduce complexity and lower total cost of ownership.

Don't miss this opportunity to learn how to leverage high performance solutions that integrate data reliably across heterogeneous sources and targets -- using Oracle GoldenGate and Oracle Data Integrator Enterprise Edition!

      Oracle Bellevue
        411 108th Ave NE, Suite 900
        Bellevue, WA 98004

            Oracle Portland

            PacWest Center – 1211 SW Fifth Avenue

            Portland, OR 97204 

MEETINGS FOR  Tuesday and Thursday  August 13 and 15, 2013*

*There is no cost to attend.   Lunch or Dinner will be provided.

Networking at10:30 am  11 am to 4:45 pm in Portland

3:30 to 8:15 pm in Bellevue

We have lots of detailed slides

Previous Meeting Itinerary

Tuesday, August 13 in Portland networking starting at 10:30 am

Presentation starts at 11 am and ends at 4:15 pm

Thursday, August 15 in Bellevue starting at 3:30 pm

and ends at 8:15 pm

Sponsors  TEKsystems, iAppSys, and Oracle

                 Arup Nanda                        Glenn Fawcett

Arup Nanda, Oracle Ace Director and Principal Database Architect of Starwood Hotels & Resorts Worldwide Inc will present the following topics for the OSWOUG August events in both Portland and Bellevue Washington.  He is one of the most sought after presenters at OpenWorld. See him in September in San Francisco.

  1. 1.Oracle Locking Demystified (1 hour).

  2. 2.Secure your Database in a Single Day (1 hour).

  3. 3.Exadata Demystified for DBAs (1 hour).

  4. 4.Performance Tuning for DBAs, Developers, Business Analysts, and "hands-on" Business Leaders (1 hour).

Glenn Fawcett, a presenter at Oracle Open World and Sr. Staff Engineer atOracle/Sun Microsystems will present on the topic of Exadata performance in both cities, diving into the new "Write-back" cache feature.He will allow lot's of time for questions. (30 minute presentation and 45 minute panel discussion).

The events will last 5 hours, so please check back for exact schedule.

Glenn Fawcett and Arup Nanda will form a round-table discussion.

Lunch provided by OSWOUG event sponsor TEKSystems

Reception and Dinner provided in Bellevue by TEKSystems. We are looking into subsidized parking.

Arup Nanda is one of the earliest members of the Oracle Oak Table and Glenn Fawcett is the newest inductee, tho’ he doesn’t look new.

MAY 2013

11:00 pm - 5:00 pm  Tuesday, May 14, 2013  IN 


Phillip Rizzo,  Oracle, Sales Manager, Data Integration Solutions,  Oracle Active Data Guard and GoldenGate,  Oracle Data Integrator.

David Segleau, Oracle, Senior Director, Big Data,  noSQL,  Second part in his talk,  see the slides posted from Part I.   This will be an executive level briefing and also some of the finer points for implementer

Clay Jackson, Quest/Dell Systems Consultant specializing in Performance, Comparing various toolsets available for database performance monitoring, including Oracle Enterprise Manager and Quest Foglight.

11:00 am - 5:00 pm  Wednesday, May 15, 2013  IN 

Bellevue (east over the bridges)

Phillip Rizzo,  Oracle Sales Manager, Data Integration Solutions, Oracle Active Data Guard and GoldenGate,  Oracle Data Integrator.

Clay Jackson, Quest/Dell Systems Consultant specializing in Performance, Comparing various toolsets available for database performance monitoring, including Oracle Enterprise Manager and Quest Foglight.

February 2013 Meeting: 

Tuesday, February 12, 2013: Portland

Wednesday, Febuary 13, 2013: Bellevue*

Both Cities: There is a 1-1.5 hour local presenter. (see the notes)


1/2 hour:  Keynote: Why Choose Oracle Linux, Oracle VM and Oracle Enterprise Manager 12C
1/2 hour:  New Innovations in Oracle Linux + Oracle Linux Zero-Downtime Kernel Updates with Ksplice
Lunch Break
1 hour:  Server Virtualization—Innovative Business Solutions to Maximize Investment Benefits & Simplify IT

1.5 hours Presentation on DataGuard or Big Data (see details below for which topic is in your city

1 hour:  Oracle Enterprise Manager 12C: Best-of-Breed Oracle Tools for Better Manageability and Performance
1/2 hour:  Review Customer Case Studies

Wrap-Up  Dessert.

Key Topic:  Oracle Linux and Virtualization.  What makes this combination the best choice for your business.  OEM will be covered along with tie-ins to big data and  mySQL.  There will be an executive briefing for senior managers during the first hour and then plenty of deep-dive and examples for the remainder of the day. David Crandall, Mark Atkinson,  Jeff Frix. - from Oracle Redwood Shores.

*There is no cost to attend.   Lunch and Desserts will be provided.


The Standard Insurance Center (click on Meeting Details link)

Portland, Tuesday, Feb. 12, 2013:   

Feb. Mtg. Time: 1:00 - 5:30pm

Gary Fox,  Xerox Lead DBA,  Disaster Recovery with DataGuard,  lots of details from the voice of experience.

Note: The next day the meeting will be held in Bellevue at Oracle Headquarters. 411 108th Ave.,NE , Bellevue, WA. 98004

Bellevue, February 13, 2013

New Time: 11:00 - 5:00pm  (10:30 Networking)

David Segleau, Oracle, Senior Director, Big Data,  noSQL,  Second part in his talk,  see the slides posted from Part I.   This will be an executive level briefing and also some of the finer points for implementers.

Tuesday, August 14, 2012 in Portland

Wed. Aug. 15 in Seattle


Are you planning to upgrade/install  Oracle Applications 12.2?

Oracle Virtual Assembly Builder,  in both cities.

Roger Freixa | Senior Principal Product Manager, Oracle

Cloud Application Foundation team,  WebLogic/Coherence/Java/Jrockit.

The future of Oracle software installations.  Oracle Applications 12.2 maybe one of the first to have this new capability for Stack/Cloud installation and configuration.

Oracle is about to release a Forms/Reports 11g OVAB plug-In, which will allow an easy introspection of existing Forms/Reports 11gR2 installations.

Oracle's roadmap for Application Servers.   Which ones will be deployed and supported going forward.  Mr. Freixa will also be available to answer questions about Oracle’s Java strategy.

An assembly is a collection of appliances, which in turn are corresponding to a single software installation and usually are an OVM image.

OVAB is intended to solve the problem of provisioning multi-tiered applications independent if the app technology (C/C++/Java ...).

Applications having a complex installation or configuration are the ideal candidates. Applications with a less complex installation or configuration are also the right candidates if such applications needs to be installed multiple times on different premises or for different environments.


Jared Still,  Pythian ,  Oracle Oak Table.  Accomplished Oracle author.

Optimizing and Simplifying SQL with Complex Grouping.

Details   BIO

Jared recently co-authored a book on SQL with Karen Morton, in which he “breaks-down” hierarchical programming and other complex tasks.


David Segleau, Director Product Management

An in-depth Technical Presentation on   Oracle NoSQL Database

Details    BIO

Jeremiah Wilton, Blue Gekko/ Data Avail

Send In the Clouds: High Performance Oracle 11g in the Amazon Cloud

Details     BIO

New White Papers from Pythian will be posted after Jared’s Presentation.


Meeting:  Tue., May, 8 and Wed. May 9, 2012


Linda Peel,  Mark Gordon

Oracle Corporation

A thorough understanding of Integrated Business Planning to align your planning and operations from Strategic Planning at the Executive level through Execution – Demand thru Delivery

-          Aligning Business Planning with Sales and Operations Planning to provide the latest view of the business and enables re-optimization in the light of changing circumstances

-          Executive lead Business Excellence Performance with Continuous Focus, Alignment (Realignment) and Synchronization

-          Significantly improve Forecast Accuracy – increased on time delivery driving increased revenues, resulting in reduction of overall inventory and on hand safety stock while increasing productivity

-          Enabling a global process “to put you in the driver’s seat” detecting market change early, understanding business implications, and making timely decisions to keep your business on track

We will provide  both an overview and demonstration of the capabilities your organization can take advantage of in an manner that allows you to start anywhere to drive value into your process.

Craig Shallahamer


Title: Resolving Buffer Busy Related Contention


The buffer busy wait and read by other session are two of the most intriguing wait events. While Oracle never officially locks a buffer, during high concurrency situations buffers can become too busy to access. A methodical step-by-step diagnosis and a solid grasp of the relevant Oracle internals is particularly important because there are a number of reasons why a buffer can become too busy and the solutions are derived in part by understanding the underlying Oracle structures. This presentation guides you through the process of discovering if there is a significant problem, the related Oracle internal structures, wait event name changes, a spot-on diagnosis method, and solutions for the most common situations you're likely to face.

Title: SQL Elapsed Time Analysis


This presentation focuses on how to take standard SQL statement information (e.g., from a Statspack or AWR report) and extend it in a number of practical and profound ways. First we delve into the elapsed time average; what people perceive, what the evidence shows, and ways to collect more useful and valuable elapsed time information. Second, we look at other areas of Oracle performance analysis that present similar challenges. And finally, we discuss why elapsed time change is proportional to both the amount of work to be processed and how long it takes to process each piece of work. Experimental results are shown and analyzed yielding a surprisingly deep understanding of how Oracle performance solutions impact elapsed times. All this helps the performance analyst improve the quality of their work and their marketplace value.

Theresa Merenkov, Senior Director

Oracle Corporation


1.       OUM Program Overview and Briefing

2.       OUM Implement Core Workflow – The Key to Understanding and Applying OUM

3.       Iterative Planning with OUM

4.       An Iterative Approach to Application Implementation using OUM

5.       OUM Knowledge Zone on OPN

6.       OUM Customer Program

7.       OUM Training, Certification, and Specialization

Meeting:  Tue., Feb. 14 and Wed. Feb. 15, 2012

Topic Summary

Exadata,  OBIEE,  Oracle Data Integrator, GoldenGate, Advanced Planning Command Console,  Oracle Supply Chain Management /   Value Chain Planning, Oracle Virtualization /  Cloud / Cloud Grid Controls

Bill Slocumb, Oracle Corp.,  Exadata.  Revealing the Exadata X2-2 architecture.

Edward Whalen, Performance Tuning Corp., Oracle ACE, will give an afternoon seminar on virtualization, Oracle Grid Controls, and 12c taken from his classes and books.

Phillip Rizzo, Oracle Corp.,  will demonstrate Oracle Data Integrator and GoldenGate.  ODI integrates Warehouse Builder and most data components within Oracle’s data integration offerings.

Gwen Shapira, Pythian,  offers a real-world example of migrating a 17-server 68-partition IBM DB2 environment to a geographically distributed Oracle Exadata Database Machine environment and the strategy for success from planning through execution.


Gwen Shapira,  Oracle ACE Director,  Oracle Oak Table

Abstract:  Hadoop - an open source framework for distributed data

analysis. It is also a major part of Oracle's recently announced Big

Data Appliance.

Steven PIerson CPIM,  and team, Oracle Corp.,  Oracle Advanced Planning Command Console,  Value Chain Planning.    A high-level discussion and demonstration of the APIs and capabilities of APCC and it’s approximately 1,000 APIs for data integration and Supply Chain Management  tie-ins.

February Meeting:

Bill Slocumb

Oracle Corporation

50 minutes

Exadata x2-2 - a technical introduction and details.

Gwen Shapira


Implementing Exadata: Lessons from the trenches

50 minutes

In this session Pythian offers a real-world example of migrating a 17-server 68-partition IBM DB2  environment to a geographically distributed Oracle Exadata Database Machine environment and the strategy for success from planning through execution. Learn the significant business and performance advantages of the integrated Oracle Database Machine/Oracle Exadata technology including reduced costs, shorter deployment time, superior performance, increased functionality and streamlined support. Find out how OBIEE analytics and third-party ETL tools can be integrated with Exadata. Experiences with hybrid columnar compression, integrating real-time data updates from multiple sources, performance tuning and 24/7/365 high availability are discussed with pitfalls to avoid and best practices for success.

50 minutes

Abstract:  Hadoop - an open source framework for distributed data analysis. It is also a major part of Oracle's   recently announced Big Data Appliance.

This presentation will discuss questions raised by traditional IT organizations as they are trying to move Hadoop from the developement lab to the data center: Is Hadoop just another ETL tool? What unique value can Hadoop bring to the business? How does the data in Hadoop fit into data life cycle in the organization? And how can we connect the dots to arrive at a consistent and managable BI architecture?

This presentation is aimed at IT professionals who are interested in moving with their organization toward an era where big data is a strategic advantage.

Steven Pierson

Oracle Corporation

Lunch and learn format.  Starts at 12 noon.  60 minutes.

Value Chain Planning Suite:  Strategic Planning for Supply Chains

                DIscussion surrounding APCC

    Capital Planning

    Demand Planning

    Working with Asia based suppliers / facilities

    Advanced Planning Control Center - The tool for Supply Chain Executives

Phillip Rizzo

Oracle Corporation

50 minutes

Oracle Data Integration Solutions:

Learn how Oracle's Data Integration Solutions (GoldenGate and Oracle Data Integrator) can provide continuous access to real-time data; regardless of where it resides or how it is used. You will discover how Oracle's next generation data integration architecture provides both batch and real-time data movement and transformation to support all of your enterprise-wide sources and targets; including Oracle, SQL Server, DB2, Sybase, flat files, JMS, XML, and more.

1.  Eliminate unplanned downtime and minimize data loss for non-Oracle databases

2.  Achieve uninterrupted operations of business-critical systems during maintenance activities

3.  Enable active-active database architectures to maximize performance and reduce total cost of ownership

4.  Minimize risk and downtime during system upgrades, migration, and consolidation projects, including application upgrades

Ed Whalen

Performance Tuning Corporation

3.5 hour seminar in the afternoon

·         Introduction

·         Virtualization Terminology and Definitions

·         Oracle’s Virtualization Products

·         Virtualization Landscape

·         Benefits of Virtualization

·         Types of Virtualization

o   Pros & Cons

·         Oracle VM Specifics

·         Managing Oracle VM


Oracle Enterprise Manger 11g Grid Control and Oracle Enterprise Manager Cloud Control 12c.  Topics will include:

·         Introduction to OEM 11g Grid Control

·         Using Grid Control for Monitoring and Managing Databases

o   Using SQL Monitoring

o   Advance Alerting and User Defined Metrics

·         Introduction to AMP (Application Management Pack) for EBusiness Suite

·         Introduction to OEM Cloud Control 12c

·         Using Cloud Control for Monitoring and Managing Databases

o   Using ASH Analytics

·         Overview of Cloud Control new features

Meeting: Tuesday, November 8, 2011

     Craig Shallahamer       Rick Stehno      Boris Trukhnov


Title: Products offered by Oracle with an emphasis on server virtualization techniques.

A high level discussion of Oracle's offerings in virtualization for the server. Boris has dedicated many years to Oracle database optimization. He spoke previously on virtualization as part of an Oracle grid discussion at OSWOUG last year.


Title: Intro to Oracle Buffer Cache Internals

While Oracle's buffer cache consists entirely of database blocks, the buffer headers and the supporting lists/chains are what makes the buffer cache a consistent topic of importance, interest, and challenge. Using creative visualizations, the presentation begins by introducing the key buffer cache structures followed by Craig role playing as a server process performing a variety of server process related activities. This naturally leads into when and how CPU is consumed and how the various buffer cache related wait events manifest, such as free buffer waits, and cache buffer chain and LRU latch contention. Both new and experienced Oracle DBAs will find this presentation informative, practical, and entertaining.


Title: Oracle Database Acceleration using Solid State Storage

Abstract: The arrival of more cost effective Solid State Disks and Flash based Storage technology has provided significant performance gains in the deployment of an Oracle database. Oracle and storage vendors have started enhancing their products to take advantage of these SSD and Flash technologies. Choosing the right implementation approach can be a challenging proposition for the DBA. In this session we will look at implementing Oracle’s Smart Flash Cache using an internal SSD acceleration board, using cache technology inside of the array, and the benefits of storage tiers using SSD, with the benefits and challenges of each.

Details: Oracle Smart Flash Cache; Technology available in 11gR2; Extends Oracle Buffer Cache; Can use any technology - Flash Cards, Network Flash, Solid State Disk, even USB drives;

Caching Inside the Array; Technology available for all Oracle database releases; Caches disk access to increase performance; Used in conjunction with SSD

Previous Meetings, and Events

General Meeting: Tuesday, May 10, 2011

Jared Still

Making RMAN Perform

Jared has recently made his contribution to another book, this time in partnership with Karen Morton, titled Pro Oracle SQL. OSWOUG feels this book is an outstanding reference.

Edward Roske, CEO

interRel Consulting, LLP

Edward Roske is the CEO and co-founder of interRel Consulting, one of the 5 largest Oracle EPM consulting firms in the world. As an Oracle ACE Director and author of seven books, Edward has spoken on four continents evangelizing everything Oracle Business Intelligence, Enterprise Performance Management, and Hyperion.


Oracle EPM: Hyperion is the Future of Reporting, Analysis, Modeling, and Planning

In 2007, Oracle acquired Hyperion for three primary products: Essbase, Hyperion Financial Management (HFM), and Hyperion Planning. What exactly are these products and how can you begin freeing your data?  In this session, you'll learn how Essbase provides robust reporting, analysis and calculations against multiple data sources; why HFM is the market leading product in the financial management, consolidation, and accounting reporting space; and how Hyperion Planning gives you powerful budgeting, planning, forecasting, what-if'ing, and modeling capabilities.  You'll leave this session with an understanding of not only what the main Hyperion products do, but how they can make your life better at your company by saving you time, reducing costs, and giving you better access to information.  If you don't already have Hyperion or you just want to increase your fundamental Hyperion knowledge, this may be the most important presentation you attend all year.

What is Essbase and Why Should I Care?

Oracle’s acquisition of Hyperion’s Essbase provides powerful analytic and calculation capabilities to Oracle's Business Intelligence suite. Join us for this presentation where we will show you why Essbase is the best multi-dimensional (OLAP) solution for customers. We’ll demonstrate the advanced analytic capabilities, powerful calculation engine, and all of the features and functions of Essbase. With recent Essbase enhancements like Aggregate Storage Databases and XOLAP, the lines are blurring between relational and multi-dimensional storage and traditional relational reporting options. We guarantee you’ll leave this session with a better understanding of what Essbase can do, when Essbase makes sense (and when it doesn’t) as a solution.

Integrating Oracle Essbase & OBIEE with Your Data Warehouse Strategy

If your company has a data warehouse or is thinking of building one, come to this presentation to learn how Oracle EPM System, Fusion Edition (including the products formerly known as Hyperion) helps drive value from your warehouse solution.  Understand the benefit of Essbase and OBIEE+ and how they fit into your overall information delivery platform. Learn about how Essbase and the Oracle technologies combine to provide seamless integration between your applications, relational databases, and multi-dimensional databases. We’ll show how the OBIEE+ Reporting and Analysis components provide a single interface into any type of data source, combining data from your data warehouse and data marts into in nicely formatted reports, user friendly dashboards, and easy-to-use analytic screens. Join us for this informative session to learn the best way to build a warehouse for integration with Oracle EPM System, and how to get information out of your warehouse if you've already built one.

More information about our speaker:

Edward is continuously recruited to host various Hyperion presentations at user groups around the world as he uses his 15+ years of expertise on over 500 implementations in the Hyperion arena to provide insight on the future of Hyperion within Oracle. Edward also offers an Oracle EPM blog,, which offers a unique perspective inside the world of Oracle EPM, including information on upcoming releases, colorful commentary on Edward’s ideas on hot topics in the industry, and much more. Recently, Edward was just made a certified Oracle Fusion Applications Advocate, a title Oracle has only bestowed on 7 people.

Link to InterRel

Edward Roske's Blog

Jared Still's BIO and Presentation Details

Jared Still is a Sr. DBA at Pythian and enjoys exploring all things Oracle and learning how they work and how to use them. Jared is perhaps best known for founding the Oracle-L oracle mailing list many years ago. He is also known as the "Part Time Perl Evangelist" for his use of Perl in conjunction with Oracle, and is co-author of "Perl for Oracle DBA's" and "Pro Oracle SQL". Jared is a member of the Oracle Oak Table and an Oracle ACE.

RMAN is a well-established backup tool. As it has become increasingly robust, it has also become increasingly complex.
When RMAN doesn't seem to be performing as well as you think it should, where do you begin to tune it? While there is some RMAN tuning information available to guide you, it is somewhat sparse.
This presentation is not going to offer any quick tips or silver bullets, because there aren't any.
This presentation is about learning how to determine what makes RMAN perform well in a particular environment, and what makes it perform poorly.
You will see what parameters performed well in my test system, but there are no guarantees that you would see the same results in your systems by applying the same values to these parameters.

Topics for this presentation include:
- Increasing backup performance. - Increasing restore performance. - Compromises between backup and restore performance. - Compromising backup performance to maintain response time.
Recognition to InterRel and Oracle for bringing Edward Roske.
TekSystems providing breakfast and lunch.
The DBAs at Standard Insurance, you know who you are.

Meeting: Tuesday, February 8, 2011. 8:00 a.m.

Craig Shallahamer

Craig's Accomplishments

Bring your stats pack report and calculator to the meeting.

Rick Stehno

Mark Henderson

LSI Corp.

Craig will present:

Resolving Buffer Busy Waits Related Contention (50 min.)

Evaluating Alternative Performance Solutions (50 min.)

Rick and Mark will present:

Performance benefits of using SSD technology in an Oracle database environment. (50 min.)


Craig Shallahamer's bio:

Craig is a researcher, writer, and teacher for 1000s of Oracle professionals. His focus is Oracle performance management, which has led to a string of publishing over 24 technical papers and authoring the books Oracle Performance Firefighting and Forecasting Oracle Performance. Craig is the creator and teacher of the popular Advanced Oracle Performance Analysis, Oracle Performance Firefighting, and the Oracle Forecasting & Predictive Analysis courses. After nine years with Oracle Corporation in which he co-founded the Core Technologies and the System Performance Groups, in 1998 he left Oracle to start OraPub, Inc. He is a passionate educator, a pinnacle of Oracle knowledge, and an engaging instructor. His entertaining presentation style combines with his depth of Oracle experiences to make each presentation unique. An Oracle ACE Director, he has taught 1000s of Oracle professionals on 6 continents in 24 countries.

Presentation: Resolving Buffer Busy Waits Related Contention

Of all the Oracle wait events, the buffer busy wait and read by other session are two of the most intriguing. While Oracle never officially locks a buffer, during high concurrency situations buffers can become too busy to access. A methodical step-by-step diagnosis and a solid grasp of the relevant Oracle internals is particularly important because there are a number of reasons why a buffer can become too busy and the solutions are derived in part by understanding the underlying Oracle structures. This presentation guides you through the process of discovering if there is a significant problem, the related Oracle internal structures, wait event name changes, a spot-on diagnosis method, and solutions for the most common situations you're likely to face. The presentation closes with a case study bringing together all the presented material.

Presentation: Evaluating Alternative Performance Solutions

DBAs can do a pretty good job at diagnosing performance problems and coming up with a list of solutions. But an awkward uncomfortableness can occur when asked to objectively choose and to explain which solution is the best or how the solution will specifically affect the system or a user. This presentation will introduce you how to quantitatively and graphically represent your system and your proposed solutions. This will enable you to objectively compare various solutions and to confidently present your solutions to both management and your colleagues.

Presentation: Advantages of using Solid State Device Storage for Performance in an Oracle Database Environment

Mark Henderson is a Solutions Marketing Manager with LSI Corporation which designs and manufactures high-performance midrange storage systems for IBM, Oracle, Dell, Blue Arc, SGI, Teradata and others. Mark works with Oracle and LSI’s various OEM channels to create and promote solutions that address customer problems and create competitive advantage. He has a degree in Computer Systems Engineering, has designed high-end flight simulators, participated in computer science and networking research at US DOE labs, architected HPC centers, and had been involved with Storage Resellers, Tape Systems, Fibre Channel Director SAN technology and MAID storage systems. He has been in the industry for 25 years.

Rick Stehno is an Oracle Technologist/DBA with LSI Corporation which designs and manufactures high performance storage systems. Rick works with Oracle and LSI's various OEM's to create and promote solutions using LSI's storage systems with the various Oracle technologies. Rick has been in the IT field for over 34 years and working with Oracle databases since 1989.

Thanks to TEK Systems, Standard Insurance, and our speakers; All of whom give time and money to bring together a growing network of professionals.

General Meeting: Tuesday, November 9, 2011. 8:00 a.m.

Cary Millsap


Cary Millsap

will discuss the current state-of-the-art in Oracle performance tuning.

His many accomplishments include the O'Reilly book "Optimizing Oracle Performance". In this crucial book, Cary Millsap, former VP of Oracle's System Performance Group, clearly and concisely explains how to use Oracle's response time statistics to diagnose and repair performance problems. Cary also shows how "queueing theory" can be applied to response time statistics to predict the impact of upgrades and other system changes.

There are certain "camps" in the worldwide Oracle community. For example, there is the "Oak Table Network" of "Oracle scientists" who seek thorough understandings of issues backed up by details, tests and proofs. Contrasting is the "Silver Bullet" family of field-tested generals who prefer rules of thumb and quick fixes even it means some false understandings and occasionally being wrong. Cary Millsap (of the Oak Table Network) stands as someone respected by both sides.

Cary Millsap worked at Oracle for 10 years on system performance before co-founding Hotsos in 1999 [...]. He is one of the most trusted sources on matters of Oracle system performance, and "Optimizing Oracle Performance" is considered his finest work (4.5 out of 5 stars on Amazon).

* The preceding is an anonymous comment from a book reviewer on


expert Anand Thiagaraj from IBM

In this session, Anand with present and demonstrate IBM Cognos Business Intelligence. IBM Cognos Business Intelligence delivers the complete range of BI capabilities: Reporting, Analysis, Dashboarding and Scorecards on a single, service-oriented architecture (SOA). With IBM Cognos you can author, share and use reports that draw on data across all enterprise sources for better business decision.

Bio: Anand Thiagaraj is a Solution Specialist for the IBM Business Analytics' brand. He has more than 17 years of software industry experience and has performed different roles - consulting, engineering, product management and product marketing. He has an MBA from Rutgers University. Anand lives in the San Francisco Bay Area with his wife and two daughters.

General Meeting, August 10, 2010. 8:30 a.m.

Oracle OpenWorld 2010: Brief Presentation.

Erik Kaarto will discuss Oracle OpenWorld 2010

Erik's career with Oracle, starting at Redwood Shores, extended through 15 years. He has attended every OpenWorld and almost every one of the shows prior to being taken over by Oracle marketing. Erik will make light about the "Evolution of Demos" and Oracle Sales.

Presentation: starts 8:50 a.m.

Boris Trukhnov, OCP, OCE

Installing Oracle 11gR2 RAC on Enterprise Linux 5 using VMware Server.

Boris will present installation considerations and details using VMware Virtual Machine and Red Hat Enterprise Linux.

Boris M. Trukhnov has been working with relational databases (primarily Oracle) since 1994 and is an author of several technical books published in US and translated into Portuguese, Chinese, and Russian, including “SQL Bible” (1st and 2nd editions) and “Introduction to Database Management”. Boris’s areas of expertise include RAC, ASM, RMAN, performance tuning, database and system architecture, platform migrations, and system upgrades. Boris is an Oracle 10g Database Administrator Certified Professional (OCP) and Oracle Real Application Clusters 10g Administrator (OCE).

General Meeting Tuesday May 11, 2010. 8:15 a.m.

APEX Class, May 10, 2010. 3:30-8:30p.m. Location: LSI 15220 NW Greenbrier Parkway, Ste 100 Beaverton OR 97006.

Bradley D. Brown, CIO and Co-Founder of TUSC

at The Standard Insurance Center

David Alexander will be honored for his contributions to OSWOUG.

Breakfast sponsored by TekSystems' Beaverton Offices. Tek is a national staffing agency.


Bradley D. Brown, CIO and Co-Founder of TUSC

Brad is an accomplished Oracle author and world-renowned speaker, his books include: "Oracle HTML DB Handbook" (the product was renamed Oracle Application Express), "Oracle Application Server 10g", "Oracle9i Web Development," "Oracle8i Web Development", and "Oracle Application Server Web Toolkit Reference" in 1997.


APEX CLASS is scheduled for Beaverton 3:30-8:30p.m. location TBD.

Developing Applications using Application Express.

Instructions to download and install APEX will be posted here.


Understanding Oracle Licensing. starts at 8:25a.m.

Building a Mashup with Application Express. 1 Hour Presentation.

Recession-proof your company with SOA. 1 Hour Presentation.

Wimpy Web Services vs. Powerful Flexible Web Services. 1 Hour Presentation.

The presentations will include detailed technical demonstrations.

First Presentation, Starting at 8:25am.

Oracle Licensing - How to negotiate.

Brian Decker

Oracle Licensing Specialist for TUSC

The Oracle Specialists.

Approximately 1/2 hour and time allotted for questions. Talk Details

Second Presentation: starts at 9am. (ApEx)

Building a Mashup with Application Express (ApEx)


In this presentation, Brad will talk about how to develop a mashup using Oracle Application Express. Traditionally people think of ApEx as being an "Oracle database" tool only - not a mashup tool. However, Brad will show how you can consuming Web Services to access data from any source - Oracle, MySQL, SQL Server, Access, Excel, Cloud Databases (like Zoho), etc. In Brad's presentation titled "Scalable Oracle ApEx" he explains how to create an n-tier architecture for ApEx. This architecture provides unparalleled scalability to your organization. This presentation explains the implementation side (i.e. the specifics) of this solution.

Third Presentation: starts at 10:10am

Recession-proof your company with SOA

Using Quick Turns for Quick Feedback


The ability to rapidly modify service offerings is becoming key to success in today's turbulent economy. Many companies are turning to SOA to help their business reduce development effort and achieve agility, but implementing SOA effectively has proved a daunting challenge all its own. How can today's IT managers and CIOs realistically propose SOA and quickly deliver benefits without risking their jobs? Rolta TUSC's Brad Brown will explain why historic SOA implementations have failed, how you can benefit from innovative software that fundamentally transforms the complexity of implementing SOA to an "instant" task, and how an agile, iterative approach can deliver rapid ROI for your business and ultimately lower total cost of ownership. In a time where budgets can be cut at a moment's notice, this briefing will ensure you derive value from your SOA initiatives in weeks and become the "hero" for your business.

Fourth Presentation: starts at 11:20am

Wimpy Web Services vs. Powerful Flexible Web Services


In this presentation, Brad will discuss the importance of strong Web Services, the difference between wimpy services and powerful flexible Web services. Many companies today are attaching SOA MBOs to their technical teams. These performance metrics often measure based on quantity rather than quality. What is quality? Reuse? Performance? Flexibility? Brad will discuss this topic in detail.

Will cover integration tools such as Eclipse and Java. Building an open API that provides dynamic services provides a powerful service architecture to any business.


Bradley D. Brown is Chief Technology Officer of TUSC, a ROLTA company.

Oracle Application Server, Oracle Application Express, Web Services, and the Service Oriented Architecture are a few of the technologies Brad has mastered over a career that spans more than 25 years.

Thomas Kurian, senior vice president -- Oracle Server Technologies Division, says, "Brad is among the foremost experts on Oracle's technology in the world."

He is an accomplished Oracle author and world-renowned speaker, his books include: "Oracle HTML DB Handbook" (the product was renamed Oracle Application Express), "Oracle Application Server 10g", "Oracle9i Web Development," "Oracle8i Web Development", and "Oracle Application Server Web Toolkit Reference" in 1997.

Brad has enjoyed a countless number of major implementation successes over the years, One milestone that clearly stands out centers around the development of "Periscope" which he released through TUSC in 2002. Periscope is breakthrough software that makes data from other data sources (i.e., Microsoft Access, Sybase, SQL Server, DB2, Web Services, file systems, APIs, etc.) appear as if it's in one big Oracle Database. The data also can be inserted, updated and deleted from many source databases. The groundbreaking tool works with more than 100 databases.

* More Information on Brad.

Brian Decker - Oracle Licensing - Talk Details

How do you know if you are getting the best deal on your Oracle licenses? What is a fair discount level? Am I affected by User Minimums? What about Processor licenses? What is my core factor multiplier? Do I need full use licenses, Application Specific Licenses, Limited Use licenses? How do I license a DR site, or Test and Dev environments? Can I de-support old licenses? What about these Unlimited License Agreements (ULA's)? When is the best time to buy licenses? I will answer these questions in the presentation. Questions and Answers to follow.

Required: RSVP your attendance to Jon Wasserman: Breakfast is sponsored by Tek Systems.

General Meeting: February 2010

Rich Niemiec

President and co-founder of TUSC

Three presentations.

How Oracle Won the Database World (1hr.)


Performance Tuning Oracle Grid: Parts I and II (50 minutes each)

Oracle Security Issues for DBA's will be presented by a DBA from TUSC.

(45 minutes and Q&A as time allows.)

Send correspondence in advance of the event to Jon Wasserman with requests for security topics to be covered by the experts from TUSC.


Rich Niemiec, 47, Rolta's President of International EICT (Enterprise Information & Communications Technology) and President of TUSC - A Rolta Company.

TUSC is a Chicago-based systems integrator of Oracle-based business solutions since 1988; TUSC was the Oracle Partner of the Year in 2002, 2004, 2007 & 2008.

Rolta is an international market leader in IT-based geospatial solutions, and caters to industries as diverse as infrastructure, telecom, electric, airports, defense, homeland security, urban development, town planning and environmental protection.

Rich is the past President of the International Oracle Users Group (IOUG) and the current President of the Midwest Oracle Users Group (MOUG).

Rich is one of six originally honored worldwide Oracle Certified Masters.

In 2007, he authored the Oracle bestseller "Oracle10g Performance Tuning Tips & Techniques," an update of his previous 2 Oracle best sellers on Oracle8i and Oracle9i Performance Tuning. Rich was inducted into the Entrepreneurship Hall of Fame in 1998.

* abbreviated BIO.

November 2009

Tek Systems discussed the current job market for Oracle professionals.

Anatole Schaff:

Business Process Analysis Suite

As business process management (BPM) expands beyond isolated projects to mainstream programs at the division or enterprise level, there is an increased need for collaboration between process analysts and IT. Oracle Business Process Analysis (BPA) Suite speeds process innovation by rapidly modeling business processes and converting them into IT executables. It supports UML, BPMN, process simulation, and round-trip engineering to BPEL models. This session will present how Oracle BPA Suite allows business users to design, model, simulate, and optimize business processes to achieve maximum operational efficiency and reduce the "strategy to execution" gap.

Oracle Data Integrator (45 minutes plus question and answer session)

A key component of Oracle Fusion Middleware, Oracle Data Integrator (ODI) delivers unique next-generation Extract Load and Transform (ELT) technology that improves performance and reduces data Integration costs, even across heterogeneous systems. ODI provides high-performance movement and transformation of data across heterogeneous systems (Oracle and non-Oracle) in batch, real- time, synchronous, and asynchronous modes. ODI offers the productivity of a declarative design approach, as well as the benefits of Knowledge Modules which encapsulate best practices in loading, transforming, or integrating data for a specific data source or target. Join this session to see how ODI can benefit your Data Warehouse, Application Integration, Master Data Management, or Modernization Migration project.

Anatole Schaff is a principal SOA/BPM solution specialist at Oracle in the areas of Business Process Management and Service Oriented Architecture. His technical expertise covers Oracle BPA Suite, Oracle SOA Suite, Application Integration Architecture and software development. Anatole has more than 10 years of experience in architecting and developing solutions with Oracle technologies. Prior to joining Oracle he was Enterprise Architect at Tektronix. Anatole holds a MS in Engineering and Technology Management from PSU.

Carol-Lee Tutch:

Accessing Hierarchical Data in Oracle (30 minutes plus question and answer session)

Bill of materials, parts explosion, or hierarchically structured data presents challenges for traditional SQL queries. The standard SQL methods for examining hierarchies will be illustrated and their shortcomings described. Oracle provides the CONNECT BY and START WITH clauses, along with several operators and psuedocolumns to greatly expand such querying. These SQL extensions will be examined, along with some of the advanced functions Oracle now provides. The talk will conclude by demonstrating a couple of surprising uses for Oracle's extensions.

Carol-Lee Tutch, began developing relational database solutions in the early 80's by creating a data warehouse and a cartographic metadata database for the Defense Mapping Agency. Her first major project in Oracle involved creating an order bill-of-materiels system for Westinghouse. She has designed database systems for the FBI, PBS, Emery Worldwide, PACE Manufacturing, New Edge Networks, and The Standard. She is currently on assignment, through VOLT, at The Standard.

February 2009

Maxina Parks Oracle Technical Sales Support

Enterprise Grid Management and Oracle 11g.

Tuesday, May 13, 2008

Karen Morton

Director, Consulting & Education

Method R Corporation

The Cary Millsap Company

Oracle continues to add more and more automated features and advisors (i.e. ADDM, AWR, ASSM, SQL Tuning Advisor, etc.). Given all this automation and advice Oracle is providing, a question to ask is whether or not all this advice is "dumbing us down" or "smartening us up". Too often more automation can lead to using these features as a crutch and bypassing the acquisition of key skills and knowledge. Ideally, these features should be tools to help us do our jobs better instead of simply letting Oracle do it for us. The risk is becoming trained to only follow the advisors output, but when a situation arises where our skills and knowledge are needed, it's not there. This presentation looks at some of these automations and the knowledge and critical thinking skills needed by the DBA or Developer to understand and use them properly and effectively.

David Driscoll

Senior Systems Engineer

Pillar Data Systems

Smart Storage Devices designed specifically for Oracle Databases. Designed to work with all major storage hardware. This will be a deep dive into the workings of artificial intelligence for database storage.

Bill Slocumb

Oracle Corporation

Oracle Applications: The newest method for sizing the system.

February 12, 2008

David Alexander

Oracle Corporation

Paul Veilleux

Global Sales Director, Pillar Data Systems


Simplifying the storage grid for Oracle 10g/11g Database