Past Meeting Archives

Oregon and Southern Washington Oracle Users Group

 

General Meetings


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

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


November 8-9, 2016


Jared Still                 
             Tim Gorman

Presentation Slides


Hey-You_Have-You-Moved-to-the-Cloud_4x3.pdf


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


               
                                       


PORTLAND SCHEDULE AND AGENDA

1:30    Check-in, registration, networking
Lunch

 

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

Refreshments

 

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




BELLEVUE SCHEDULE AND AGENDA

10:30    Check-in, registration, networking
Lunch

 

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

Refreshments

 

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: https://nwoug.clubexpress.com/content.aspx?page_id=87&club_id=165905&item_id=486063  NO FEE TO ATTEND

Bellevue Registration:   https://nwoug.clubexpress.com/content.aspx?page_id=87&club_id=165905&item_id=488400  There is a small fee to attend.  Parking is validated compliments of TEK Systems.  Meeting at the TEK Systems offices.

Agenda

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.


TOPICS

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.






Meeting

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

Outline:

 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.






PREVIOUS MEETING

AGILE DEVELOPMENT

ENTERPRISE REPLICATION


Tuesday,  August 11 , 2015

Portland location:  The Standard Insurance Center

10:45 - 2:15  Topics:

Database Replication

Clay Jackson,  Dell Software

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 move quickly to specific implementation considerations for several use cases including disaster recovery, load isolation, auditing and more.


Bio

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.


Bio

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.








Theme : MANAGING THE ENTERPRISE

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 


12:25am-1:10pm

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 Salesforce.com 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


HANDS-ON LAB

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 

Portland

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)

SCHEDULE

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.


Locations:

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


KEYNOTE ADDRESS

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.


TUESDAY ONLY

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.



WEDNESDAY ONLY

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


PRESENTATION SUBJECT MATTER:

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

Orapub

Title: Resolving Buffer Busy Related Contention

Abstract:

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

Abstract:

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

Agenda

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’S SLIDES


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

Pythian


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

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.


CRAIG SHALLAHAMER


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.


RICK STEHNO

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.

THREE PRESENTATIONS:

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,Looksmarter.blogspot.com, 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.)



DETAILS and BIOs


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

COGNOS


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 safaribooksonline.com



COGNOS


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.


RSPV to jsw@oswoug.org



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.


Monday


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.


Tuesday


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.


BIO*

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: jsw@oswoug.org 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.)

Slides


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.


BIO*

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


Presentation

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