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
https://amitzil.wordpress.com/2017/09/12/oswoug-event-in-portland/Home_files/Basic%20Datatypes%20-%20Deep%20Understanding.pdfHome_files/Optimizer%20Complexity.pdfmailto:no_reply@apple.com?subject=email%20subjectHome_files/Free-Oracle-Performance-tools-IOUG.pdfHome_files/2017_OSWUG_Db12cR2_NewFeatures.pdfHome_files/2017_OSWUG_EBS_Diary%20%281%29.pdfBlogs/Blogs.htmlshapeimage_1_link_0shapeimage_1_link_1shapeimage_1_link_2shapeimage_1_link_3shapeimage_1_link_4shapeimage_1_link_5shapeimage_1_link_6shapeimage_1_link_7


QUEST Software

SharePlex and TOAD





Oracle Corp.



Oracle Technology Network: TECHNET.

“www.oracle.com/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
		Refreshments
 
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
ORACLE SECURITY PROFILE INVITATION
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.





Location_Guidance.htmlLocation_Guidance.htmlHome_files/Free-Oracle-Performance-tools-IOUG_1.pdfmailto:jsw@oswoug.orghttp://livepage.apple.com/shapeimage_8_link_0shapeimage_8_link_1shapeimage_8_link_2shapeimage_8_link_3
 

Events in Oregon and Washington

Events Worldwide

Last Updated: April 24,  2017

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