Oregon and Southern Washington Oracle User Group

Oregon and Southern Washington Oracle User Group

The NEXT OSWOUG meeting is Tuesday,  February 13, 2017 at Providence.

Learn about Oracle’s newest  easy-to-use BI tools for DBAs and Developers.
Local Oracle 

Thanks to Liron, Jared, and Clay for outstanding presentations
on Tuesday, September 12.
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:  http://bit.ly/free-oracle-tools

Jared Still
Oracle Oak Table
Oracle ACE

Clay Jackson
What to Consider When Moving Your Oracle Database to the Cloud

May 2017 meeting:
Presentation Slides are now available for Download
Oracle 12c New Features
E-Business DBA Diary
Biju Thomas, OneNeck Solutions

QUEST Software

SharePlex and TOAD

Oracle Corp.

Oracle Technology Network: TECHNET.


Jared Still’s SQL

MEETING DETAILSMeeting_Details.html
JOB ANNOUNCEMENTSJob_Announcements.html
WHITE PAPERSWhite_Papers.html
MEMBERSHIP / REGISTRATION (RSVP to attend meetings)Membership___Registration.html
PREVIOUS MEETINGSPrevious_Meetings.html
PRESENTATION SLIDESPresentation_Slides.html

Board of Directors

Jon Wasserman

Gary Fox

Clay Jackson

Arlene Gelbolingo

Souvonnah Ramsey

Ken Knowles

Don Bateson

David Portin

Julia Shozen

Riley Mahler

Shibin Li

Cheri Mosbrucker

Evelyn Eng

Ping Zhao

Technology Advisory Board

Tim Gorman

Jared Still

Biju Thomas

Portland:   Providence St. Vincent Medical Center
9135 SW Barnes Road Portland, OR.  97225. 

Building: Mother Joseph Plaza PSVMC-MJP  
Room: Springwater/Wildwood, 1st Floor Conference Room.

Free Parking: Best to park in the WEST Parking Structure nearest to the West Pavilion. 
Bus and Light Rail are nearby. Directions to Providence St. Vincent

Portland Schedule and Agenda
10:30    	Check-in, registration, Networking. 
                Continental Breakfast
10:45        Oracle BI tool product manager’s , product introduction
                Introduction to Oracle User Group Leadership Forum
11:00	        Not all Clouds are Equal - What to Consider When Moving Your Oracle 
                   Database to the Cloud.
11:40        Liron Amitzi 
                Basic Datatypes Deep Understanding - Truly Understand Oracle Datatypes

12:30	        Lunch is Provided!
12:45	        Jared Still
                Free Oracle Performance Tools: Time provided for questions.
2:10          Break/networking
2:15          Liron Amitzi  
                Dealing with the Optimizer Complexity      

3:15          Wrap-up

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.

 From  the February 2017 meeting
Organized and Presented by:  William J. Slocumb
Bill Slocumb, is a database security specialist and has conducted several dozen database risk assessments over the last couple of years throughout North America.  He’s presenting “Database Risk Assessments Lessons-Learned” to show you common elements and weaknesses common to most of the customers he’s evaluated.  Bill will explain database security concepts, common customer shortfalls and remediation for common database security issues.  Concepts he discusses are applicable to any data store whether Oracle or not.  Oracle’s security profile program is open to all customers.

Please contact Bill or Oracle to arrange an in-depth analysis.  You may also reach Jon Wasserman jsw@oswoug.org to be connected to Bill.


Events in Oregon and Washington

Events Worldwide

Last Updated: April 24,  2017

Copyright Oregon and Southern Washington Oracle User Group and it’s owners.