Oregon and Southern Washington Oracle User Group














































Oregon and Southern Washington Oracle User Group

Monday, May 7, 2018    REGISTER
HANDS-ON-LAB: Working in the Oracle Cloud
Oracle Cloud Licenses Provided
Instructions E-Mailed to all Registrants

Tuesday, May 8, 2018   REGISTER
Topics
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.

DIRECTIONS:
HOL Monday:   Providence IT Offices at the Lloyd Center.  Parking is free
Conference Tuesday:  Providence/St. Vincents on the WEST SIDE in the Souther Auditorium.   Parking is free

http://events.constantcontact.com/register/event?llr=tr5fxh8ab&oeidk=a07ef9oxf8z22e2d5afhttp://events.constantcontact.com/register/event?llr=tr5fxh8ab&oeidk=a07ef9owi5r44eff4bcDirections.htmlDirections.htmlDirections.htmlDirections.htmlshapeimage_1_link_0shapeimage_1_link_1shapeimage_1_link_2shapeimage_1_link_3shapeimage_1_link_4shapeimage_1_link_5

Viscosity

North America





Oracle Corp.



Oracle Technology Network: TECHNET.

“www.oracle.com/technet


John J. King

King Training Resources


Jared Still’s SQL

 
MEETING DETAILSDirections.html
WHITE PAPERS
PREVIOUS MEETINGSPrevious_Meetings.html
PRESENTATION SLIDESPresentation_Slides.html

Board of Directors

Jon Wasserman

Gary Fox

Clay Jackson

Fahd Saeed

Arlene Gelbolingo

Souvonnah Ramsey

Ken Knowles

Don Bateson

David Portin

Julia Shozen

Shibin Li

Cheri Mosbrucker

Ping Zhao


Technology Advisory Board

Maria Colgan

Biju Thomas

Jared Still


May 7 & 8, 2018  Itineraries



Oracle versions 12.2.0.1 ,  12.2.0.2 and 18c  


The Oracle Cloud is growing very rapidly.  The Oracle Cloud(s) is fraught with mis-conceptions, bugs and support issues.  The Cloud has evolved.  Attendees are encouraged to interact with the presenters. Attendees are encouraged to discuss their own experiences within the Oracle Cloud.  If you are about to add the Cloud to your enterprise, then your questions will be answered..  To be sure, if you ask.


Monday Hands-On-Lab  Schedule and Agenda


Once you register, you will receive instructions to set up your Cloud Trail, best to set it up on Friday morning before the Monday Workshop.

1:00pm        Charles Kim will discuss all of the types of cloud offerings at Oracle,  briefly. 

                     Then Charles will discuss all of the services in the cloud, briefly. OCI (Oracle Cloud Infrastructure). What and Why’s of OCI.


1:30pm        Setup Networking. How to Create a Virtual Cloud Network. CIDR. Subnets. Availability Domains. VPN Topology and a

                     Fastconnect Topology. The Autonomous Datawarehouse.


2:00pm        SSH.  Key Generation. OPC Account, ssh on a Mac.


2:15pm        Storage. Compartments and Buckets. Block Storage vs. object storage. Create block storage and file storage in the Cloud.


3:15pm        Bare Metal vs. VMs . Shapes.  Assigning network and firewall rules. Build an OS from an image.


3:45pm        DBaaS.  Autonomous vs. Regular DBaaS.  New DB lifecycle.  BM vs. VM vs. Exadata Cloud Service.


4:00pm        DBaaS.  Build a Database.


4:30pm        Backup the Cloud Database.  Analyze the Cloud Database


5:30pm        Select a Cloud Build Topic


6:00pm        Reception

 

                  


Tuesday Schedule and Agenda

Stay for the whole day or come for half day.


9:00        Sign-In, Networking. 


               Continental Breakfast


9:30        Introductions, OSWOUG Business 


9:45        Keynote :  Richard Niemiec, Emerging Technologies: Innovation, Oracle Cloud, Big Data, and the Internet of Things


This session explores Oracle’s acceleration and the cycles of innovation in the world. It looks at the current big data revolution and some of the solutions out there, as well as Oracle’s big data solution. Attendees learn about the role that both Google and Facebook have played in the big data ecosystem and also how NoSQL databases such as MySQL fit in. The session also includes a look at the Internet of Things (IOT), which will drive big data even faster.


Emerging Technologies: Internet of Things (IoT)

State of the Art Cloud Platform: Big Data, Database                


10:45 - 11:00 Break


11:00        Charles Kim,  Brain Overload with Oracle 12.2.0.2 / 18c New Features


Oracle Database 12 Release 2 is packed with enhancements for DBAs and Developers.  Come listen to all the pertinent new features in Oracle 12.2 that will change how you perform maintenance and tune the database.  This session is not the traditional Oracle 12.2 database features.  Be prepared to be overwhelmed including, but not limited to, the following focused areas:


Oracle 18c

Upgrade to Oracle 12.2

Online Improvements

Partitioning Option

Multi-Tenancy (PDB) Option

Data Guard

RMAN

General Database

RAC

ASM/ACFS

In-Memory

Database Upgrade Options

Oracle DBAs/Developers can take immediate advantage of these new features.  We will rapid fire all the new features to the audience.  


Charles Kim: “We will share all of the code from our presentations so that you can add them to your arsenal.”


Objective 1: Learn new features and functionality for Oracle Database New Features in 12c Release 2: 

* Online Improvements

* Partitioning Option

* Multi-Tenancy (PDB) Option

* Data Guard

* RMAN

* General Database

* RAC

* ASM


Objective 2: Also learn about Oracle 12c Release 1 new features and Oracle's patching direction with Oracle 18c


Objective 3: Attendees will learn key fundamental best practices for upgrading to Oracle 12.2


12:00        Lunch, RAFFLE PRIZES


1:00          Fahd Saeed, Red Pill Analytics      ODIEE


1:45 - 2:00   Coffee Break


2:00          Rich Niemiec: The Best Oracle Database 18c New Features


This presentation will look at which 18c new features should be investigated for use. Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm that focus on the developer. There will be simple examples (such as a quick example using pluggable databases) to show the basic functionality of the new features. The speaker has been working with the Beta program over many versions of Oracle.


1. Overview of New Features including Memory Optimization for IOT, Multitenant Advances like Per-PDB Switchover, Zero Impact Grid Infrastructure Patching, Per-PDB Security, polymorphic table functions, Private Temporary Tables, Docker Support, New Installation Support, 18cXE release, Shard-aware applications, In-Memory External Tables, and Approximate Query improvements.


2. Each specific feature (such as pluggable databases)


3. Example of using specific feature (such as pluggable databases)


4. Other new features not discussed but worth considering


Objective 1: Overview of New Features


Objective 2: Each specific feature detailed


Objective 3: Example of using each specific feature



3:00          Charles Kim,  The future of the DBA - Panel discussion with Oracle Community of Experts


There's a lot of buzz about the "death of the DBA", autonomous database and the future of a career in database administration, no need to fear for there's a session to make sense of it all!  This key, Capstone panel from the Oracle community of experts discuss the strong status of the database administration role, the future skills that will take you to the next level and how to make the most of what you know now.


Discussions will include how technical enhancements, the cloud, AI and machine learning will change the current database scene and how small directional changes will assist in making the DBA more essential to the industry than ever before.


This is a "not to be missed" session to grant insight, intel and to offer clarity with all the information out there and to focus on what is important in the database industry to make the most of a career as a technical professional.


4:00         OSWOUG CLOSING REMARKS, RAFFLE PRIZES


4:15 - 7:00pm.        NETWORKING RECEPTION ( This will include dinner fare)

                                Network with the presenters, panelists,  OSWOUG Board, and other members.



Presentation Details

Monday

Hands-On-Lab

Oracle Future: 12c R1 & R2 / 18c, Multitenant, Database In-Memory,                           Oracle Cloud, Oracle's Autonomous Database   (Presented at Viscosity's Master Class)

This session will look at Oracle’s Future direction for Oracle 18c, the Autonomous Data Warehouse Cloud, and specifically focus on Oracle Database 12c R1 & R2 features:

Database Analytics

Using Memory Target and the Buffer Cache

Multiple indexes on the same Column & Fetch First x Rows

In-Memory Virtual Columns

Adaptive Execution Plans & Patch to fix issues

Runaway query Management

Online Move Partition and R2 Online Features for Partitions

Partial Indexes for Partitioned Table

Pluggable Databases (Includes Flashback PDB)

Approximate Query new 12c R1 & R2 Features

Quick In-Memory Tips with R1 & R2 New Features like In-Memory Joins

Security Enhancements

18c New Features to look forward to and the future ahead


    Charles Kim and Richard Niemiec        Workshop: Backup to the Cloud and Beyond – Real Solutions

    Let us challenge your thoughts about backing up files to Oracle Cloud. Every customer should be considering RMAN backups of their databases to Oracle Cloud (if not already); and backing up the Oracle database to the Cloud is just the tip of the iceberg. You have to think outside the box and consider the entire solution and include the non-database files such as middleware backups, documents, reports, logs, etc.

    In this session, we will provide end-to-end backup solutions to Oracle Cloud and present a deep-dive content of backing up the database to the Oracle Cloud. Charles Kim will go into extensive details on backing up non-oracle files to Oracle Cloud and demonstrate various methods to uploading and downloading various types files (including RMAN) to the Cloud and how to drive performance.  


                                                        .

Tuesday

   Keynote: Richard Niemiec        Emerging Technologies

   Explores Oracle’s acceleration and the cycles of innovation in the world. It looks at the current big data revolution and some of the solutions out there, as well as Oracle’s big data solution. Attendees learn about the role that both Google and Facebook have played in the big data ecosystem and also how NoSQL databases such as MySQL fit in. The session also includes a look at the Internet of Things (IOT), which will drive big data even faster.

    Charles Kim      Brain OverLoad with Oracle Database 12.2 Features

http://viscosityna.com/event/collaborate18-session-1344/ 

    Oracle Database 12 Release 2 is packed with enhancements for DBAs and Developers. Come listen to all the pertinent new features in Oracle 12.2 that will change how you perform maintenance and tune the database. This session is not the traditional Oracle 12.2 database features. Be prepared to have your brain overloaded while discovering more from within the following focus areas:

    Oracle 18c

    Upgrade to Oracle 12.2

    Online Improvements

    Partitioning Option

    Multi-Tenancy (PDB) Option

    Data Guard

    RMAN

    General Database

    RAC

    ASM/ACFS

    In-Memory

    Database Upgrade Options

    Oracle DBAs/Developers can take immediate advantage of these new features. We will rapid fire all the new features to the audience.

    We will share all of the code from our presentation so that you can add them to your arsenal.


    Objective 1: Learn new features and functionality for Oracle Database New Features in 12c Release 2:

* Online Improvements

* Partitioning Option

* Multi-Tenancy (PDB) Option

* Data Guard

* RMAN

* General Database

* RAC

* ASM

    Objective 2: Also learn about Oracle 12c Release 1 new features and Oracle’s patching direction with Oracle 18c

    Objective 3: Attendees will learn key fundamental best practices to upgrading to Oracle 12.2

Audience: Mid-Level


Charles Kim       Oracle Database features every developer should know about

    Over the years, a lot of new features have been introduced in the Oracle Database to save developers time and to spare them from having to reinvent the wheel. Many of these features are actively highlighted via conference sessions or blogs when a new release is launched but over time are forgotten before they can be put to good use.

    In this session, we will discuss the critical features that already existing in the Oracle Database, which every developer should not only know about but also utilize.  Using easy-to-follow examples, we will demonstrate when and where you should take advantage of these features to make your life easier and help you getting the best out of your Oracle Database, regardless of whether you are a DBA or a developer.


Fahd Saeed        Oracle Data Integrator Enterprise Edition: Integration with the Cloud.



PREVIOUS MEETING FOLLOW-UP DETAILS

Special thanks to Liron, Jared, and Clay for outstanding presentations in September 2017

Visit Liron Amitzi’s commentary summarizing the event


VIew presentation slides:

Liron Amitzi

Presentation Code Examples coming soon

Basic Datatypes - Deep Understanding

Understanding Query Optimizer Complexity


View presentation slides:

Jared Still

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

Download Final Meeting Version:  http://bit.ly/free-oracle-tools


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



 

Events in Oregon and Washington

Events Worldwide







Last Updated: June 4,  2018

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